pgsql-hackers since 2023-11-23 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

Nov. 23, 2023

Thread Author Time
Re: [HACKERS] Changing references of password encryption to hashing Bruce Momjian 00:01
Re: [HACKERS] psql casts aspersions on server reliability 📎 Bruce Momjian 00:11
Re: pg_upgrade and logical replication Peter Smith 00:25
Re: [HACKERS] psql casts aspersions on server reliability Tom Lane 00:38
Re: [HACKERS] Changing references of password encryption to hashing Bruce Momjian 01:23
Re: Assert failure on 'list_member_ptr(rel->joininfo, restrictinfo)' 📎 Richard Guo 02:33
Re: [HACKERS] psql casts aspersions on server reliability 📎 Bruce Momjian 03:25
Re: [HACKERS] make async slave to wait for lsn to be replayed Bowen Shi 03:52
Re: Adding a clang-format file Ray Eldath 04:00
Re: [PATCH] Add CHECK_FOR_INTERRUPTS in scram_SaltedPassword loop. 📎 Bowen Shi 04:05
Re: Lockless exit path for ReplicationOriginExitCleanup Bharath Rupireddy 04:09
Re: [HACKERS] pg_upgrade vs vacuum_cost_delay 📎 Bruce Momjian 04:23
Re: Lockless exit path for ReplicationOriginExitCleanup 📎 Bharath Rupireddy 04:40
Re: [HACKERS] Typo in sequence.c Bruce Momjian 04:41
confusion about Re: Write operations in parallel mode's update part. jiye 04:55
Re: Synchronizing slots from primary to standby Amit Kapila 05:13
Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock 📎 Dilip Kumar 06:04
Re: remaining sql/json patches jian he 06:55
Catalog domain not-null constraints 📎 Peter Eisentraut 06:56
Re: GUC names in messages 📎 Peter Smith 07:27
pgoutput incorrectly replaces missing values with NULL since PostgreSQL 15 📎 Nikhil Benesch 07:40
RE: CRC32C Parallel Computation Optimization on ARM Xiang Gao 08:05
Re: [PATCH] Add CHECK_FOR_INTERRUPTS in scram_SaltedPassword loop. Aleksander Alekseev 08:19
Re: patch: improve "user mapping not found" error message Peter Eisentraut 08:41
Re: How to stop autovacuum silently Maxim Orlov 08:43
Re: pg_upgrade and logical replication 📎 vignesh C 08:43
Re: pg_upgrade and logical replication vignesh C 08:48
Re: Synchronizing slots from primary to standby 📎 shveta malik 08:59
Re: pgoutput incorrectly replaces missing values with NULL since PostgreSQL 15 Amit Kapila 09:03
Re: SQL:2011 application time Peter Eisentraut 09:08
Re: psql not responding to SIGINT upon db reconnection Heikki Linnakangas 09:19
Re: POC, WIP: OR-clause support for indexes 📎 Andrei Lepikhov 09:23
Re: undetected deadlock in ALTER SUBSCRIPTION ... REFRESH PUBLICATION Amit Kapila 09:24
RE: Question about the Implementation of vector32_is_highbit_set on ARM Xiang Gao 09:28
Re: should check collations when creating partitioned index 📎 Peter Eisentraut 10:01
Re: Synchronizing slots from primary to standby Ajin Cherian 10:06
[Proposal] global sequence implemented by snowflake ID 📎 Hayato Kuroda (Fujitsu) 10:18
Re: Change GUC hashtable to use simplehash? John Naylor 10:41
Re: [Proposal] global sequence implemented by snowflake ID Michael Paquier 10:45
Re: Synchronizing slots from primary to standby Amit Kapila 10:45
Re: remaining sql/json patches jian he 10:46
Re: autovectorize page checksum code included elsewhere John Naylor 10:50
Re: Question about the Implementation of vector32_is_highbit_set on ARM John Naylor 10:56
Re: Random pg_upgrade test failure on drongo 📎 Alexander Lakhin 11:00
Re: [PATCH] psql: Add tab-complete for optional view parameters 📎 Dean Rasheed 11:07
Re: WaitEventSet resource leakage Heikki Linnakangas 11:35
Use index to estimate expression selectivity Bono Stebler 11:55
RE: Random pg_upgrade test failure on drongo Hayato Kuroda (Fujitsu) 12:15
Re: PL/pgSQL: Incomplete item Allow handling of %TYPE arrays, e.g. tab.col%TYPE[] 📎 Quan Zongliang 12:27
Re: Parallel CREATE INDEX for BRIN indexes Matthias van de Meent 12:33
Table AM Interface Enhancements 📎 Alexander Korotkov 12:42
Re: Catalog domain not-null constraints Aleksander Alekseev 13:13
Re: PoC: prefetching index leaf pages (for inserts) Heikki Linnakangas 13:26
Re: pgsql: meson: docs: Add {html,man} targets, rename install-doc-* Andrew Dunstan 13:32
Re: Parallel CREATE INDEX for BRIN indexes Tomas Vondra 13:35
Re: ALTER COLUMN ... SET EXPRESSION to alter stored generated column's expression 📎 Amul Sul 14:13
Re: [HACKERS] pg_upgrade vs vacuum_cost_delay Magnus Hagander 14:45
Re: PoC: prefetching index leaf pages (for inserts) Tomas Vondra 14:46
Does pg support to write a new buffer cache as an extension? jacktby jacktby 14:48
Re: Synchronizing slots from primary to standby Drouvot, Bertrand 15:45
Re: [HACKERS] psql casts aspersions on server reliability 📎 Bruce Momjian 16:12
Re: Catalog domain not-null constraints Alvaro Herrera 16:35
Re: Catalog domain not-null constraints Alvaro Herrera 16:38
Re: undetected deadlock in ALTER SUBSCRIPTION ... REFRESH PUBLICATION Tomas Vondra 16:45
Re: autovectorize page checksum code included elsewhere Nathan Bossart 16:51
Questions regarding Index AMs and natural ordering Matthias van de Meent 17:16
Re: Use index to estimate expression selectivity Tom Lane 17:30
Re: Use index to estimate expression selectivity Tomas Vondra 18:00
Re: Questions regarding Index AMs and natural ordering Peter Geoghegan 18:51
Re: Questions regarding Index AMs and natural ordering Tom Lane 19:15
Re: PL/pgSQL: Incomplete item Allow handling of %TYPE arrays, e.g. tab.col%TYPE[] 📎 Pavel Stehule 19:39
Re: Questions regarding Index AMs and natural ordering Peter Geoghegan 19:45
Re: Properly pathify the union planner 📎 David Rowley 22:29
Improving the comments in pqsignal() 📎 Thomas Munro 22:33
Re: Table AM Interface Enhancements Matthias van de Meent 23:07

Nov. 24, 2023

Thread Author Time
Re: PATCH: Add REINDEX tag to event triggers 📎 jian he 00:00
Re: PL/pgSQL: Incomplete item Allow handling of %TYPE arrays, e.g. tab.col%TYPE[] 📎 Quan Zongliang 01:11
Re: pg_upgrade and logical replication Peter Smith 01:29
Re: Adding facility for injection points (or probe points?) for more advanced tests 📎 Michael Paquier 01:56
Re: PATCH: Add REINDEX tag to event triggers Michael Paquier 02:43
Re: [HACKERS] psql casts aspersions on server reliability Laurenz Albe 03:06
Re: GUC names in messages Michael Paquier 03:11
Re: POC, WIP: OR-clause support for indexes 📎 Andrei Lepikhov 03:30
RE: Synchronizing slots from primary to standby Zhijie Hou (Fujitsu) 03:35
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features) Andrei Lepikhov 03:52
Don't use bms_membership in places where it's not needed 📎 David Rowley 04:06
Re: undetected deadlock in ALTER SUBSCRIPTION ... REFRESH PUBLICATION Shlok Kyal 04:15
Re: trying again to get incremental backup Thomas Munro 04:18
Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock Dilip Kumar 04:47
Re: PL/pgSQL: Incomplete item Allow handling of %TYPE arrays, e.g. tab.col%TYPE[] 📎 Pavel Stehule 05:00
Re: POC, WIP: OR-clause support for indexes Alena Rybakina 05:05
Re: Properly pathify the union planner Ashutosh Bapat 05:43
Re: [PATCH] fix race condition in libpq (related to ssl connections) Michael Paquier 05:45
Re: Don't use bms_membership in places where it's not needed Richard Guo 06:53
Re: How to accurately determine when a relation should use local buffers? Давыдов Виталий 07:10
Re: [PATCH] fix race condition in libpq (related to ssl connections) 📎 Michael Paquier 07:48
Re: Improving the comments in pqsignal() Heikki Linnakangas 07:54
Re: Random pg_upgrade test failure on drongo 📎 Alexander Lakhin 08:00
Re: Synchronizing slots from primary to standby Drouvot, Bertrand 08:23
Re: remaining sql/json patches 📎 jian he 08:41
Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock 📎 Dilip Kumar 09:07
Re: Synchronizing slots from primary to standby Drouvot, Bertrand 09:16
Re: remaining sql/json patches Amit Langote 09:32
Re: Synchronizing slots from primary to standby Amit Kapila 09:45
Re: Synchronizing slots from primary to standby Drouvot, Bertrand 09:50
Re: GUC names in messages Alvaro Herrera 09:53
Re: pipe_read_line for reading arbitrary strings 📎 Daniel Gustafsson 10:08
Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning Alena Rybakina 10:20
Re: [HACKERS] pg_upgrade vs vacuum_cost_delay Michael Banck 10:21
Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning Alena Rybakina 10:26
Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning Ashutosh Bapat 10:54
Re: Adding facility for injection points (or probe points?) for more advanced tests Ashutosh Bapat 11:07
Re: [HACKERS] pg_upgrade vs vacuum_cost_delay Magnus Hagander 11:17
Re: undetected deadlock in ALTER SUBSCRIPTION ... REFRESH PUBLICATION 📎 Shlok Kyal 11:35
Re: Patch: Global Unique Index Nikita Malakhov 11:40
Re: pgoutput incorrectly replaces missing values with NULL since PostgreSQL 15 📎 Amit Kapila 11:47
Re: [HACKERS] pg_upgrade vs vacuum_cost_delay 📎 Michael Banck 12:10
RE: pgoutput incorrectly replaces missing values with NULL since PostgreSQL 15 📎 Zhijie Hou (Fujitsu) 12:21
Re: remaining sql/json patches 📎 Alvaro Herrera 12:27
Re: How to accurately determine when a relation should use local buffers? Aleksander Alekseev 12:51
Re: Improve tab completion for ALTER DEFAULT PRIVILEGE and ALTER TABLE Shubham Khanna 13:07
Re: pgoutput incorrectly replaces missing values with NULL since PostgreSQL 15 Nikhil Benesch 13:53
Re: Assert failure on 'list_member_ptr(rel->joininfo, restrictinfo)' 📎 Alexander Korotkov 13:54
Re: GUC names in messages Michael Paquier 14:01
[PATCH] pg_convert improvement 📎 Yurii Rashkovskii 14:05
Re: Adding facility for injection points (or probe points?) for more advanced tests Michael Paquier 14:07
Re: [PATCH] pg_convert improvement Drouvot, Bertrand 14:26
Re: [PATCH] pg_convert improvement 📎 Yurii Rashkovskii 14:32
Re: Stack overflow issue 📎 Heikki Linnakangas 15:14
Re: Table AM Interface Enhancements Mark Dilger 15:18
Re: [HACKERS] psql casts aspersions on server reliability 📎 Bruce Momjian 15:19
Re: pg_upgrade and logical replication 📎 vignesh C 15:35
Re: index prefetching 📎 Tomas Vondra 16:25
Re: [HACKERS] pg_upgrade vs vacuum_cost_delay 📎 Bruce Momjian 16:34
Re: Questions regarding Index AMs and natural ordering Matthias van de Meent 16:44
Re: [HACKERS] pg_upgrade vs vacuum_cost_delay Magnus Hagander 17:20
Re: [HACKERS] pg_upgrade vs vacuum_cost_delay Bruce Momjian 17:40
Re: Questions regarding Index AMs and natural ordering Peter Geoghegan 18:12
Re: Questions regarding Index AMs and natural ordering Tom Lane 18:58
Re: mxid_age() and age(xid) appear undocumented Bruce Momjian 19:36
Re: Questions regarding Index AMs and natural ordering Peter Geoghegan 19:43
Re: Improving the comments in pqsignal() Thomas Munro 21:11
Re: Lifetime of commit timestamps Bruce Momjian 22:56
Re: remove deprecated @@@ operator ? Bruce Momjian 23:02
Re: pg_stats and range statistics 📎 Alexander Korotkov 23:06
Re: Relation bulk write facility 📎 Heikki Linnakangas 23:19

Nov. 25, 2023

Thread Author Time
Re: pg_walfile_name_offset can return inconsistent values Bruce Momjian 00:44
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements 📎 Alexander Korotkov 00:45
Re: POC, WIP: OR-clause support for indexes Alexander Korotkov 01:13
Re: [PATCH] Add CHECK_FOR_INTERRUPTS in scram_SaltedPassword loop. Michael Paquier 01:20
Re: POC, WIP: OR-clause support for indexes Alexander Korotkov 01:23
Re: pg_upgrade and logical replication 📎 vignesh C 01:51
Re: [HACKERS] GIN pageinspect functions Bruce Momjian 03:03
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Julien Rouhaud 03:04
Re: [HACKERS] patch: change magic constants to DEFINE value for readability. Bruce Momjian 03:36
Re: autovectorize page checksum code included elsewhere John Naylor 07:09
Re: autovectorize page checksum code included elsewhere John Naylor 07:24
Re: pg_stats and range statistics jian he 08:28
Re: pg_stats and range statistics jian he 08:57
Re: pg_stats and range statistics Egor Rogov 09:14
Re: undetected deadlock in ALTER SUBSCRIPTION ... REFRESH PUBLICATION Amit Kapila 11:05
Re: POC, WIP: OR-clause support for indexes Alena Rybakina 11:10
Re: pg_upgrade and logical replication Amit Kapila 12:20
RE: Random pg_upgrade test failure on drongo Hayato Kuroda (Fujitsu) 15:19
Re: [HACKERS] Bogus WAL segments archived after promotion Bruce Momjian 15:48
Re: POC, WIP: OR-clause support for indexes Alexander Korotkov 16:13
Re: [HACKERS] Changing references of password encryption to hashing Bruce Momjian 16:49
Re: pg_stats and range statistics 📎 Alexander Korotkov 16:55
Re: pg_stats and range statistics Alexander Korotkov 16:57
Improve rowcount estimate for UNNEST(column) 📎 Paul A Jungwirth 17:19
Re: Table AM Interface Enhancements Alexander Korotkov 17:47
New instability in stats regression test Tom Lane 18:08
Emitting JSON to file using COPY TO Davin Shearer 19:21
Re: New instability in stats regression test Tom Lane 19:34
Test 002_pg_upgrade fails with olddump on Windows 📎 Alexander Lakhin 20:00
Re: Emitting JSON to file using COPY TO David G. Johnston 20:02
Re: brininsert optimization opportunity Tomas Vondra 20:06
strange para/programlisting pattern in sgml docs Tomas Vondra 20:44
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov 20:45
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Alexander Korotkov 20:46
Re: Emitting JSON to file using COPY TO Adrian Klaver 21:00
Re: brininsert optimization opportunity Ashwin Agrawal 22:33
Re: brininsert optimization opportunity Soumyadeep Chakraborty 23:23
Mentor PostgreSQL at CodePeak 2023! 📎 gautam.sharma 23:36

Nov. 26, 2023

Thread Author Time
Re: Add recovery to pg_control and remove backup_label Stephen Frost 08:42
Missing docs on AT TIME ZONE precedence? Shay Rojansky 10:13
Re: Missing docs on AT TIME ZONE precedence? Bruce Momjian 14:27
Should timezone be inherited from template database? Anton A. Melnikov 14:47
How to get started with contributions Kirtika Gautam 15:14
Re: Should timezone be inherited from template database? David G. Johnston 15:53
Re: Should timezone be inherited from template database? Anton A. Melnikov 16:02
Re: Missing docs on AT TIME ZONE precedence? Tom Lane 16:35
Re: WIP: libpq: add a possibility to not send D(escribe) when executing a prepared statement Ivan Trofimov 16:38
Re: WIP: libpq: add a possibility to not send D(escribe) when executing a prepared statement Tom Lane 17:13
Re: Missing docs on AT TIME ZONE precedence? Shay Rojansky 17:45
Re: Schema variables - new implementation for Postgres 15 📎 Dmitry Dolgov 17:52
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule 18:19
Re: Missing docs on AT TIME ZONE precedence? 📎 Tom Lane 20:11
Re: Improve rowcount estimate for UNNEST(column) Laurenz Albe 20:11
Re: Improve rowcount estimate for UNNEST(column) Tom Lane 20:22

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