pgsql-hackers since 2024-10-26 00:00

The PostgreSQL developers team lives here. Discussion of current development issues, problems and bugs, and proposed new features. If your question cannot be answered by people in the other lists, and it is likely that only a developer will know the answer, you may re-post your question in this list. You must try elsewhere first!

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Oct. 26, 2024

Thread Author Time
Re: New function normal_rand_array function to contrib/tablefunc. Andy Fan 00:51
Re: Can rs_cindex be < 0 for bitmap heap scans? Dilip Kumar 04:17
Re: general purpose array_sort 📎 Junwang Zhao 04:20
Re: proposal: plpgsql, new check for extra_errors - strict_expr_check 📎 Pavel Stehule 07:20
Assertion failure when autovacuum drops orphan temp indexes. Masahiko Sawada 07:43
Re: [PATCH] Add sortsupport for range types and btree_gist Andrey M. Borodin 08:40
Re: New function normal_rand_array function to contrib/tablefunc. Dean Rasheed 10:39
Re: Can rs_cindex be < 0 for bitmap heap scans? Melanie Plageman 12:00
Re: Introduce new multi insert Table AM and improve performance of various SQL commands with it for Heap AM 📎 Bharath Rupireddy 13:30
Re: Enhancing Memory Context Statistics Reporting Nitin Jadhav 14:03
Re: Enhancing Memory Context Statistics Reporting Alvaro Herrera 14:14
Re: Fix C23 compiler warning Alvaro Herrera 14:16
make all ereport in gram.y print out relative location 📎 jian he 15:12
Re: sunsetting md5 password support 📎 Nathan Bossart 15:55
Re: UUID v7 📎 Andrey M. Borodin 16:07
Re: Assertion failure when autovacuum drops orphan temp indexes. 📎 Nathan Bossart 16:14
Re: Replace current implementations in crypt() and gen_salt() to OpenSSL 📎 Joe Conway 18:10
heap_inplace_lock vs. autovacuum w/ LOCKTAG_TUPLE Noah Misch 18:49
Re: Assertion failure when autovacuum drops orphan temp indexes. Stepan Neretin 19:12
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails Alvaro Herrera 19:28
Re: Fix C23 compiler warning Tom Lane 21:18
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails 📎 Alvaro Herrera 21:47

Oct. 27, 2024

Thread Author Time
Re: New function normal_rand_array function to contrib/tablefunc. Andy Fan 01:30
Re: -Wformat-signedness Andy Fan 03:59
Re: heap_inplace_lock vs. autovacuum w/ LOCKTAG_TUPLE 📎 Noah Misch 04:09
Re: heap_inplace_lock vs. autovacuum w/ LOCKTAG_TUPLE Alexander Lakhin 05:00
Re: Assertion failure when autovacuum drops orphan temp indexes. Masahiko Sawada 06:54
Re: msvc directory missing in PostgreSQL 17.0 黄铎彦 07:44
Re: msvc directory missing in PostgreSQL 17.0 📎 黄铎彦 07:48
Re: msvc directory missing in PostgreSQL 17.0 📎 黄铎彦 07:56
Re: msvc directory missing in PostgreSQL 17.0 📎 黄铎彦 08:16
Re: msvc directory missing in PostgreSQL 17.0 Dave Page 08:38
Re: Re: msvc directory missing in PostgreSQL 17.0 [email protected] 09:38
Re: msvc directory missing in PostgreSQL 17.0 [email protected] 09:50
Re: Assertion failure when autovacuum drops orphan temp indexes. Stepan Neretin 10:32
Re: Statistics Import and Export Alexander Lakhin 11:00
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails Tender Wang 11:00
Re: Change COPY ... ON_ERROR ignore to ON_ERROR ignore_row jian he 11:32
Allowing pg_recvlogical to create temporary replication slots 📎 Torsten Förtsch 12:37
Re: Better error reporting from extension scripts (Was: Extend ALTER OPERATOR) Tom Lane 17:41
libedit history seems to be misbehaving / broken Tomas Vondra 17:47
Re: Better error reporting from extension scripts (Was: Extend ALTER OPERATOR) Pavel Stehule 17:56
Re: msvc directory missing in PostgreSQL 17.0 Andres Freund 17:58
Re: libedit history seems to be misbehaving / broken Tom Lane 19:03
Re: [Patch] remove duplicated smgrclose Kirill Reshke 19:05
Re: Alias of VALUES RTE in explain plan 📎 Yasir 19:57
Re: Alias of VALUES RTE in explain plan Yasir 20:03
Re: Alias of VALUES RTE in explain plan Tom Lane 20:07
Re: libedit history seems to be misbehaving / broken Tomas Vondra 20:07
Re: Alias of VALUES RTE in explain plan Yasir 20:15
Re: heap_inplace_lock vs. autovacuum w/ LOCKTAG_TUPLE 📎 Noah Misch 21:40
Re: race condition in pg_class Noah Misch 21:45
Re: Proposal for Integrating Data Masking and anonymization into PostgreSQL Hosney Osman 23:00

Oct. 28, 2024

Thread Author Time
Re: Set query_id for query contained in utility statement Michael Paquier 00:07
make sql-createtable.html less wider 📎 jian he 00:19
Re: Assertion failure when autovacuum drops orphan temp indexes. 📎 Masahiko Sawada 00:19
Re: Assertion failure when autovacuum drops orphan temp indexes. Michael Paquier 00:50
Re: Add isolation test template in injection_points for wait/wakeup/detach Michael Paquier 00:52
Re: Inconsistent RestrictInfo serial numbers Richard Guo 01:01
Re: Forbid to DROP temp tables of other sessions Michael Paquier 01:26
Re: msvc directory missing in PostgreSQL 17.0 📎 黄铎彦 01:31
Re: msvc directory missing in PostgreSQL 17.0 Umar Hayat 01:42
Re: Pgoutput not capturing the generated columns Peter Smith 02:13
Proposal to add exclusion constraint from existing index Marcelo Fernandes 02:43
RE: Conflict detection for update_deleted in logical replication 📎 Zhijie Hou (Fujitsu) 03:06
RE: Pgoutput not capturing the generated columns 📎 Hayato Kuroda (Fujitsu) 03:17
Re: Assertion failure when autovacuum drops orphan temp indexes. Stepan Neretin 03:44
Re: Assertion failure when autovacuum drops orphan temp indexes. Masahiko Sawada 04:36
Re: Alias of VALUES RTE in explain plan Andrei Lepikhov 04:47
Re: Assertion failure when autovacuum drops orphan temp indexes. Stepan Neretin 04:47
Re: Pgoutput not capturing the generated columns 📎 Amit Kapila 05:33
Re: Conflict detection for update_deleted in logical replication Peter Smith 05:40
Re: Make default subscription streaming option as Parallel Amit Kapila 05:45
Re: Can rs_cindex be < 0 for bitmap heap scans? Dilip Kumar 06:27
Re: Pgoutput not capturing the generated columns Amit Kapila 06:45
RE: Pgoutput not capturing the generated columns Hayato Kuroda (Fujitsu) 06:54
Re: New "raw" COPY format jian he 06:56
Re: Pgoutput not capturing the generated columns Peter Smith 06:56
Re: proposal: schema variables 📎 Pavel Stehule 07:01
Re: Pgoutput not capturing the generated columns Peter Smith 07:14
Re: Add isolation test template in injection_points for wait/wakeup/detach Bertrand Drouvot 07:17
Re: POC, WIP: OR-clause support for indexes jian he 07:19
Re: msvc directory missing in PostgreSQL 17.0 黄铎彦 08:14
Re: New "raw" COPY format 📎 Joel Jacobson 08:30
Re: Introduce new multi insert Table AM and improve performance of various SQL commands with it for Heap AM Jingtang Zhang 08:43
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails Tender Wang 08:45
Re: Pgoutput not capturing the generated columns Amit Kapila 08:50
Re: Add ExprState hashing for GROUP BY and hashed SubPlans Andrei Lepikhov 08:51
Re: Inval reliability, especially for inplace updates Nitin Motiani 08:57
Re: sslinfo extension - add notbefore and notafter timestamps 📎 Daniel Gustafsson 08:59
Re: Better error reporting from extension scripts (Was: Extend ALTER OPERATOR) Alexander Lakhin 09:00
Re: Reordering DISTINCT keys to match input path's pathkeys Andrei Lepikhov 09:15
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails 📎 Alvaro Herrera 09:16
Re: Avoid orphaned objects dependencies, take 3 📎 Bertrand Drouvot 09:30
Re: Removing unneeded self joins 📎 Andrei Lepikhov 09:32
Re: pgsql: Implement pg_wal_replay_wait() stored procedure Heikki Linnakangas 09:36
Re: further #include cleanup (IWYU) Peter Eisentraut 09:41
Re: further #include cleanup (IWYU) Peter Eisentraut 09:45
Re: Consider the number of columns in the sort cost model Alena Rybakina 09:48
Re: New "raw" COPY format 📎 Joel Jacobson 10:20
Re: IPC::Run::time[r|out] vs our TAP tests Heikki Linnakangas 10:56
Re: ActiveState Perl is not valid anymore to build PG17 on the Windows 10/11 platforms, So Documentation still suggesting it should be updated Umar Hayat 11:32
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails Tender Wang 11:42
RE: Pgoutput not capturing the generated columns Zhijie Hou (Fujitsu) 11:43
RE: Pgoutput not capturing the generated columns Zhijie Hou (Fujitsu) 11:45
Re: ActiveState Perl is not valid anymore to build PG17 on the Windows 10/11 platforms, So Documentation still suggesting it should be updated Daniel Gustafsson 12:07
Re: Avoid possible overflow (src/port/bsearch_arg.c) Heikki Linnakangas 12:13
Re: Fix C23 compiler warning Dagfinn Ilmari Mannsåker 12:19
Re: Avoid possible overflow (src/port/bsearch_arg.c) Ranier Vilela 12:33
Inconsistent output handling in 002_pg_upgrade.pl test logs Joel Jacobson 12:38
Re: Inconsistent output handling in 002_pg_upgrade.pl test logs Daniel Gustafsson 12:44
Re: RFC: Logging plan of the running query 📎 torikoshia 13:05
Re: Pgoutput not capturing the generated columns 📎 Shubham Khanna 13:07
Re: Pgoutput not capturing the generated columns Shubham Khanna 13:10
Re: Alias of VALUES RTE in explain plan Ashutosh Bapat 13:19
Re: [PoC] Federated Authn/z with OAUTHBEARER 📎 Daniel Gustafsson 13:24
Re: In-placre persistance change of a relation Heikki Linnakangas 13:33
Re: Vacuum statistics Alexander Korotkov 13:40
Re: Alias of VALUES RTE in explain plan Andrei Lepikhov 13:42
Re: Fix C23 compiler warning Tom Lane 14:14
Re: define pg_structiszero(addr, s, r) Heikki Linnakangas 14:32
Re: Introduce new multi insert Table AM and improve performance of various SQL commands with it for Heap AM Jingtang Zhang 14:48
Re: Compress ReorderBuffer spill files using LZ4 📎 Julien Tachoires 14:54
Re: define pg_structiszero(addr, s, r) Ranier Vilela 15:02
Re: Alias of VALUES RTE in explain plan Tom Lane 15:05
Re: define pg_structiszero(addr, s, r) Tom Lane 15:08
Re: Assertion failure when autovacuum drops orphan temp indexes. Nathan Bossart 15:12
Re: Alias of VALUES RTE in explain plan Tom Lane 15:16
Proper object locking for GRANT/REVOKE 📎 Peter Eisentraut 15:20
Reduce one comparison in binaryheap's sift down 📎 cca5507 15:21
Re: Avoid possible overflow (src/port/bsearch_arg.c) Tomas Vondra 15:30
Re: Inconsistent output handling in 002_pg_upgrade.pl test logs 📎 Joel Jacobson 15:44
Re: pgsql: Implement pg_wal_replay_wait() stored procedure Robert Haas 15:47
protocol-level wait-for-LSN 📎 Peter Eisentraut 15:51
Re: Better error reporting from extension scripts (Was: Extend ALTER OPERATOR) Tom Lane 16:06
Re: [PoC] Federated Authn/z with OAUTHBEARER Jacob Champion 16:09
Re: define pg_structiszero(addr, s, r) Ranier Vilela 16:29
Planner issue with BitmapScan recheck on external TOAST Jim Nasby 16:32
Re: Adding skip scan (including MDAM style range skip scan) to nbtree 📎 Peter Geoghegan 16:38
Re: Reduce one comparison in binaryheap's sift down Robert Haas 16:40
Re: general purpose array_sort Aleksander Alekseev 16:48
Re: Avoid possible overflow (src/port/bsearch_arg.c) Heikki Linnakangas 16:52
Re: POC, WIP: OR-clause support for indexes 📎 Alena Rybakina 16:55
Re: protocol-level wait-for-LSN Heikki Linnakangas 16:58
Re: protocol-level wait-for-LSN Jelte Fennema-Nio 17:02
Should we support casting between ARRAYs and JSON(B)? Aleksander Alekseev 17:06
Re: protocol-level wait-for-LSN Jelte Fennema-Nio 17:07
Re: Should we support casting between ARRAYs and JSON(B)? Marcos Pegoraro 17:29
Re: [PATCH] Add sortsupport for range types and btree_gist Bernd Helmle 17:44
Re: New "raw" COPY format Masahiko Sawada 17:50
Re: pgsql: Implement pg_wal_replay_wait() stored procedure Alexander Korotkov 18:35
Re: Better error reporting from extension scripts (Was: Extend ALTER OPERATOR) Alexander Lakhin 19:00
Re: Vacuum statistics Alexander Korotkov 19:07
Re: pgsql: Implement pg_wal_replay_wait() stored procedure Alexander Korotkov 19:42
Re: MergeAppend could consider sorting cheapest child path Nikita Malakhov 19:46
Re: Considering fractional paths in Append node Nikita Malakhov 19:50
Re: sunsetting md5 password support Greg Sabino Mullane 20:21
Re: Reduce one comparison in binaryheap's sift down Nathan Bossart 20:32
Re: Vacuum statistics Jim Nasby 21:03
Re: sunsetting md5 password support Jim Nasby 21:10
Re: trying again to get incremental backup Michael Banck 21:10
Re: Removing unneeded self joins 📎 Alexander Korotkov 21:18
Re: sunsetting md5 password support Tom Lane 21:24
Re: Assertion failure when autovacuum drops orphan temp indexes. Nathan Bossart 21:47
Re: Conflict Detection and Resolution Diego Fronza 21:49
Re: RFC: Extension Packaging & Lookup David E. Wheeler 22:19
Re: define pg_structiszero(addr, s, r) Peter Smith 22:36
Re: EXPLAIN IndexOnlyScan shows disabled when enable_indexonlyscan=on 📎 David Rowley 22:54
Re: On disable_cost 📎 David Rowley 23:21
Re: Considering fractional paths in Append node Andy Fan 23:38
Questions About TODO: Issuing NOTICEs for row count differences in EXPLAIN ANALYZE KAZAR Ayoub 23:43

Oct. 29, 2024

Thread Author Time
Re: EXPLAIN IndexOnlyScan shows disabled when enable_indexonlyscan=on David G. Johnston 00:29
Re: Questions About TODO: Issuing NOTICEs for row count differences in EXPLAIN ANALYZE David Rowley 00:39
freespace.c modifies buffer without any locks Andres Freund 00:50
Re: EXPLAIN IndexOnlyScan shows disabled when enable_indexonlyscan=on David Rowley 01:03
Re: sunsetting md5 password support 📎 Nathan Bossart 01:06
Re: ActiveState Perl is not valid anymore to build PG17 on the Windows 10/11 platforms, So Documentation still suggesting it should be updated Michael Paquier 01:24
Re: EXPLAIN IndexOnlyScan shows disabled when enable_indexonlyscan=on David G. Johnston 01:25
Re: detoast datum into the given buffer as a optimization. Andy Fan 01:26
Re: EXPLAIN IndexOnlyScan shows disabled when enable_indexonlyscan=on David G. Johnston 01:40
Re: Statistics Import and Export 📎 Jeff Davis 01:55
Re: Pgoutput not capturing the generated columns Peter Smith 02:14
Re: Consider the number of columns in the sort cost model 📎 Andrei Lepikhov 02:47
Re: EXPLAIN IndexOnlyScan shows disabled when enable_indexonlyscan=on David Rowley 03:06
Re: Introduce new multi insert Table AM and improve performance of various SQL commands with it for Heap AM Jingtang Zhang 03:18
Re: Reduce one comparison in binaryheap's sift down 📎 cca5507 03:21
Re: Add isolation test template in injection_points for wait/wakeup/detach Michael Paquier 04:12
Re: Pgoutput not capturing the generated columns Amit Kapila 04:23
Re: Why don't we consider explicit Incremental Sort? Andrei Lepikhov 04:43
Re: protocol-level wait-for-LSN Tatsuo Ishii 05:06
Re: Alias of VALUES RTE in explain plan Yasir 05:32
RE: Pgoutput not capturing the generated columns Hayato Kuroda (Fujitsu) 05:49
Re: Pgoutput not capturing the generated columns Peter Smith 06:00
Re: Pgoutput not capturing the generated columns Amit Kapila 06:15
Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different. 📎 jian he 06:15
Re: Forbid to DROP temp tables of other sessions 📎 Daniil Davydov 06:21
RE: [PoC] Partition path cache Bykov Ivan 06:27
Re: Pgoutput not capturing the generated columns Amit Kapila 06:28
Re: protocol-level wait-for-LSN Peter Eisentraut 06:28
Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different. Tender Wang 06:38

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31