pgsql-hackers since 2025-01-13 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

Jan. 13, 2025

Thread	Author	Time
Re: Pgoutput not capturing the generated columns	Peter Smith	00:15
Re: Adding a '--two-phase' option to 'pg_createsubscriber' utility.	Ajin Cherian	00:16
Re: POC, WIP: OR-clause support for indexes 📎	Yura Sokolov	00:47
Issue with markers in isolation tester? Or not? 📎	Michail Nikolaev	01:02
Re: POC, WIP: OR-clause support for indexes	Alexander Korotkov	01:06
Re: Question about behavior of deletes with REPLICA IDENTITY NOTHING	Peter Smith	01:11
Re: pg_createsubscriber TAP test wrapping makes command options hard to read.	Peter Smith	01:37
Re: Eager aggregation, take 3 📎	Richard Guo	02:04
Re: Enhancing Memory Context Statistics Reporting 📎	Rahila Syed	02:36
Re: Support for NO INHERIT to INHERIT state change with named NOT NULL constraints 📎	Suraj Kharage	02:56
Re: POC, WIP: OR-clause support for indexes 📎	Andrei Lepikhov	03:39
Re: Question about behavior of deletes with REPLICA IDENTITY NOTHING	Amit Kapila	04:00
Re: Question about behavior of deletes with REPLICA IDENTITY NOTHING	Robert Treat	04:51
Re: Compression of bigger WAL records	Andrey Borodin	05:14
Re: Conflict detection for update_deleted in logical replication	Amit Kapila	06:36
Re: Introduce XID age and inactive timeout based replication slot invalidation	vignesh C	06:52
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart 📎	Peter Smith	06:52
Re: Documentation update of wal_retrieve_retry_interval to mention table sync worker 📎	vignesh C	07:03
Re: Introduce XID age and inactive timeout based replication slot invalidation	Peter Smith	07:18
Re: Documentation update of wal_retrieve_retry_interval to mention table sync worker	Peter Smith	07:29
Re: Changing shared_buffers without restart 📎	Ashutosh Bapat	08:11
Re: Psql meta-command conninfo+	Alvaro Herrera	08:44
Re: Vacuum statistics	Andrei Zubkov	08:54
Re: Question about behavior of deletes with REPLICA IDENTITY NOTHING	Amit Kapila	08:55
Re: Documentation update of wal_retrieve_retry_interval to mention table sync worker	Shlok Kyal	09:13
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart	vignesh C	09:22
Re: Pgoutput not capturing the generated columns	Amit Kapila	09:26
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart	Ashutosh Bapat	09:31
Re: proposal: plpgsql, new check for extra_errors - strict_expr_check 📎	Pavel Stehule	09:32
Accept recovery conflict interrupt on blocked writing 📎	Anthonin Bonnefoy	10:30
Re: Skip collecting decoded changes of already-aborted transactions	Amit Kapila	11:06
Re: Psql meta-command conninfo+	Dean Rasheed	11:12
Re: Vacuum statistics 📎	Alena Rybakina	11:19
Re: Vacuum statistics	Alena Rybakina	11:29
Re: Reorder shutdown sequence, to flush pgstats later	Bertrand Drouvot	12:20
Re: Conflict detection for update_deleted in logical replication 📎	Nisha Moond	12:21
Re: Vacuum statistics 📎	Alena Rybakina	13:26
Re: why there is not VACUUM FULL CONCURRENTLY? 📎	Antonin Houska	13:48
Re: why there is not VACUUM FULL CONCURRENTLY?	Michael Banck	13:55
Re: Replace current implementations in crypt() and gen_salt() to OpenSSL 📎	Daniel Gustafsson	14:18
Re: pgsql: Consolidate docs for vacuum-related GUCs in new subsection	Melanie Plageman	15:22
Re: [PATCH] SVE popcount support	Malladi, Rama	15:28
Re: [PATCH] Hex-coding optimizations using SVE on ARM.	Chiranmoy.Bhattacharya@fujitsu.com	15:48
Re: POC: track vacuum/analyze cumulative time per relation	Bertrand Drouvot	15:55
Re: pgbench error: (setshell) of script 0; execution of meta-command failed 📎	Nathan Bossart	16:04
Re: Modern SHA2- based password hashes for pgcrypto	Alvaro Herrera	16:06
Re: [PATCH] Hex-coding optimizations using SVE on ARM.	Nathan Bossart	16:18
Re: Adjusting hash join memory limit to handle batch explosion	Melanie Plageman	16:32
Re: Exists pull-up application with JoinExpr 📎	Alena Rybakina	17:19
Re: Adjusting hash join memory limit to handle batch explosion	Tomas Vondra	17:29
Re: Conflict Detection and Resolution	Michail Nikolaev	17:31
Re: [PATCH] Add get_bytes() and set_bytes() functions 📎	Aleksander Alekseev	17:35
Re: Virtual generated columns	Dean Rasheed	18:15
SQLJSON: errmsg(" .. should ...") -> must 📎	Alvaro Herrera	18:19
Re: Pgoutput not capturing the generated columns 📎	vignesh C	18:21
Re: [PATCH] Add get_bytes() and set_bytes() functions	Dean Rasheed	18:24
Re: Skip collecting decoded changes of already-aborted transactions	Masahiko Sawada	18:54
Re: Skip collecting decoded changes of already-aborted transactions 📎	Masahiko Sawada	18:56
InitControlFile misbehaving on graviton	Christoph Berg	19:04
Re: [PATCH] Add get_bytes() and set_bytes() functions	Alvaro Herrera	19:23
Re: connection establishment versus parallel workers	Nathan Bossart	19:50
Re: pgsql: Consolidate docs for vacuum-related GUCs in new subsection 📎	Melanie Plageman	19:57
Re: InitControlFile misbehaving on graviton	Alexander Lakhin	20:00
Re: Incorrect CHUNKHDRSZ in nodeAgg.c 📎	Jeff Davis	20:09
Re: explain analyze rows=%.0f 📎	Ilia Evdokimov	20:18
Re: New GUC autovacuum_max_threshold ? 📎	Nathan Bossart	20:21
Re: Adding skip scan (including MDAM style range skip scan) to nbtree 📎	Peter Geoghegan	20:22
Re: InitControlFile misbehaving on graviton	Matthias van de Meent	20:39
Re: connection establishment versus parallel workers	Thomas Munro	20:42
Re: AIO v2.2	Robert Haas	20:43
Re: pgsql: Consolidate docs for vacuum-related GUCs in new subsection	Alvaro Herrera	20:46
Re: Question about behavior of deletes with REPLICA IDENTITY NOTHING	Robert Treat	21:22
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart	Masahiko Sawada	21:32
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart	Masahiko Sawada	21:45
Re: AIO v2.2	Andres Freund	21:46
Re: Eagerly scan all-visible pages to amortize aggressive vacuum 📎	Melanie Plageman	21:46
question about relation_open	Giampaolo Capelli	21:47
Re: [PATCH] Add get_bytes() and set_bytes() functions	Dean Rasheed	21:53
Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY 📎	Michail Nikolaev	21:58
Re: Reduce TupleHashEntryData struct size by half	Jeff Davis	22:11
Re: Reorder shutdown sequence, to flush pgstats later	Andres Freund	22:33
Re: pgsql: Consolidate docs for vacuum-related GUCs in new subsection 📎	Melanie Plageman	22:35
Re: Eagerly scan all-visible pages to amortize aggressive vacuum	Alena Rybakina	22:37
Re: pgbench error: (setshell) of script 0; execution of meta-command failed	Tom Lane	22:51
Re: New GUC autovacuum_max_threshold ?	Sami Imseih	23:17
Re: [PoC] Federated Authn/z with OAUTHBEARER 📎	Jacob Champion	23:21
Re: Issue with markers in isolation tester? Or not?	Michail Nikolaev	23:33
Re: pgsql: Consolidate docs for vacuum-related GUCs in new subsection	Alena Rybakina	23:51

Jan. 14, 2025

Thread	Author	Time
Re: [PoC] Federated Authn/z with OAUTHBEARER	Jacob Champion	01:00
Re: Question about behavior of deletes with REPLICA IDENTITY NOTHING	Peter Smith	01:07
Re: Skip collecting decoded changes of already-aborted transactions	Peter Smith	01:35
Re: Conflict detection for update_deleted in logical replication	Masahiko Sawada	01:43
Re: Skip collecting decoded changes of already-aborted transactions	Peter Smith	02:01
Re: Several buildfarm animals fail tests because of shared memory error	Tom Lane	02:02
Re: New GUC autovacuum_max_threshold ? 📎	Nathan Bossart	02:09
Re: Some ExecSeqScan optimizations	Amit Langote	02:13
Re: Some ExecSeqScan optimizations	Amit Langote	02:17
Docs for pg_basebackup needs v17 note for incremental backup	David G. Johnston	03:13
Re: Make pg_stat_io view count IOs as bytes instead of blocks	Michael Paquier	03:18
Re: WAL-logging facility for pgstats kinds 📎	Michael Paquier	03:54
Re: Issue with markers in isolation tester? Or not?	Noah Misch	04:03
Re: Conflict detection for update_deleted in logical replication	Amit Kapila	04:39
Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size 📎	Peter Smith	04:40
Re: Skip collecting decoded changes of already-aborted transactions	Amit Kapila	04:47
Re: per backend I/O statistics	Michael Paquier	04:56
Re: Conflict Detection and Resolution	Amit Kapila	04:57
Re: [PATCH] Hex-coding optimizations using SVE on ARM. 📎	John Naylor	05:27
Re: [PATCH] Hex-coding optimizations using SVE on ARM.	Michael Paquier	05:40
Re: Change COPY ... ON_ERROR ignore to ON_ERROR ignore_row 📎	jian he	05:51
Re: Reorder shutdown sequence, to flush pgstats later 📎	Andres Freund	05:58
Re: [PATCH] Hex-coding optimizations using SVE on ARM.	Tom Lane	05:59
Re: Possible integer overflow in bringetbitmap()	Michael Paquier	06:28
RE: COPY performance on Windows	Ryohei Takahashi (Fujitsu)	06:50
Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size 📎	Shubham Khanna	06:54
RE: COPY performance on Windows	Ryohei Takahashi (Fujitsu)	06:55
Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size	Shubham Khanna	07:02
Re: pg_createsubscriber TAP test wrapping makes command options hard to read.	Peter Smith	07:03
Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size	Shubham Khanna	07:05
Prevent an error on attaching/creating a DSM/DSA from an interrupt handler. 📎	Rahila Syed	07:45
Re: Psql meta-command conninfo+	Hunaid Sohail	07:57
Re: XMLDocument (SQL/XML X030)	Pavel Stehule	08:14
Re: psql: Add leakproof field to \dAo+ meta-command results 📎	Yugo NAGATA	08:44
Re: Add Pipelining support in psql 📎	Anthonin Bonnefoy	08:49
Re: Psql meta-command conninfo+	Alvaro Herrera	08:51
Re: Sort functions with specialized comparators 📎	John Naylor	08:58
Re: Reduce TupleHashEntryData struct size by half	David Rowley	09:01
question about executor hooks	Luca Ferrari	09:08
Re: downgrade some aclchk.c errors to internal	Alvaro Herrera	09:10
Re: SCRAM pass-through authentication for postgres_fdw 📎	Peter Eisentraut	09:21
Re: Sort functions with specialized comparators	Andrey Borodin	09:22
Re: Modern SHA2- based password hashes for pgcrypto	Bernd Helmle	09:34
Re: Virtual generated columns	Peter Eisentraut	09:42
Re: Psql meta-command conninfo+	Dean Rasheed	09:50
Re: Virtual generated columns	Peter Eisentraut	09:58
Re: Retiring is_pushed_down	Richard Guo	10:41
Re: Modern SHA2- based password hashes for pgcrypto	Alvaro Herrera	10:47
Re: Issue with markers in isolation tester? Or not? 📎	Michail Nikolaev	11:16
Re: Adding a '--two-phase' option to 'pg_createsubscriber' utility.	Shlok Kyal	11:23
Re: question about relation_open	Rahila Syed	11:26
Re: question about relation_open	Giampaolo Capelli	11:33
Re: Modern SHA2- based password hashes for pgcrypto	Bernd Helmle	11:41
Re: [WIP]Vertical Clustered Index (columnar store extension) - take2	Alvaro Herrera	12:00
Re: Sample rate added to pg_stat_statements 📎	Ilia Evdokimov	12:00
RE: Replace current implementations in crypt() and gen_salt() to OpenSSL	Hayato Kuroda (Fujitsu)	12:12
Support --include-analyze in pg_dump, pg_dumpall, pg_restore 📎	jian he	12:54
Re: Reorder shutdown sequence, to flush pgstats later	Bertrand Drouvot	13:06
Re: Recovering from detoast-related catcache invalidations	Heikki Linnakangas	13:13
Re: question about executor hooks	jian he	13:14
Re: [PATCH] Add get_bytes() and set_bytes() functions 📎	Aleksander Alekseev	13:25
Re: Virtual generated columns 📎	Peter Eisentraut	13:37
Re: postgres_fdw: Provide better emulation of READ COMMITTED behavior	Robert Haas	13:39
Re: AIO v2.2	Robert Haas	13:40
Re: Question about behavior of deletes with REPLICA IDENTITY NOTHING 📎	Robert Treat	13:41
Re: Make pg_stat_io view count IOs as bytes instead of blocks	Nazir Bilal Yavuz	13:43
Re: psql: Add leakproof field to \dAo+ meta-command results	Dean Rasheed	13:58
Re: SCRAM pass-through authentication for postgres_fdw 📎	Matheus Alcantara	14:14
Re: Support --include-analyze in pg_dump, pg_dumpall, pg_restore	Tom Lane	14:32
Re: question about relation_open	Tom Lane	14:39
Re: [RFC] Lock-free XLog Reservation from WAL	Zhou, Zhiguo	14:49
Re: Eager aggregation, take 3	Robert Haas	15:07
Re: Coccinelle for PostgreSQL development [1/N]: coccicheck.py	Aleksander Alekseev	15:18
Re: Use Python "Limited API" in PL/Python	Jakob Egger	15:51
Re: question about executor hooks	Sami Imseih	15:59
Re: psql: Add leakproof field to \dAo+ meta-command results	Yugo NAGATA	16:21
Re: Support --include-analyze in pg_dump, pg_dumpall, pg_restore	Nathan Bossart	16:23
Re: pgbench error: (setshell) of script 0; execution of meta-command failed	Nathan Bossart	16:29
Re: ecpg command does not warn COPY ... FROM STDIN;	Fujii Masao	16:34
Re: refactor AlterDomainAddConstraint (alter domain add constraint)	Alvaro Herrera	16:37
Re: Allow ILIKE forward matching to use btree index 📎	Yugo NAGATA	16:40
Re: [PATCH] Hex-coding optimizations using SVE on ARM.	Nathan Bossart	16:57
Re: New GUC autovacuum_max_threshold ?	Sami Imseih	17:08
Re: psql: Option to use expanded mode for various meta-commands	Dean Rasheed	17:10
Re: Adding extension default version to \dx	Yugo Nagata	17:11
Re: Bypassing cursors in postgres_fdw to enable parallel plans	Robert Haas	17:33
Re: New GUC autovacuum_max_threshold ?	Nathan Bossart	17:45
Re: CREATE TABLE NOT VALID for check and foreign key 📎	Alvaro Herrera	17:46
Re: New GUC autovacuum_max_threshold ?	Sami Imseih	17:59
Re: Reduce TupleHashEntryData struct size by half	Alvaro Herrera	18:11
Re: pgsql: Consolidate docs for vacuum-related GUCs in new subsection	Alvaro Herrera	18:21
Re: Reduce TupleHashEntryData struct size by half	Jeff Davis	18:47
Re: pgsql: Consolidate docs for vacuum-related GUCs in new subsection	Melanie Plageman	19:01
Re: pgsql: Consolidate docs for vacuum-related GUCs in new subsection	Alvaro Herrera	19:28
Re: pgsql: Consolidate docs for vacuum-related GUCs in new subsection	Alena Rybakina	19:29
Re: New GUC autovacuum_max_threshold ?	Robert Haas	19:30
Re: Reduce TupleHashEntryData struct size by half	David Rowley	19:38
Re: New GUC autovacuum_max_threshold ?	Sami Imseih	19:46
Re: Issue with markers in isolation tester? Or not?	Noah Misch	19:48
Re: Eagerly scan all-visible pages to amortize aggressive vacuum 📎	Melanie Plageman	19:51
Re: pgbench error: (setshell) of script 0; execution of meta-command failed	Tom Lane	19:52
Re: RFC: Additional Directory for Extensions	David E. Wheeler	20:01
Re: Skip collecting decoded changes of already-aborted transactions 📎	Masahiko Sawada	20:02
Re: New GUC autovacuum_max_threshold ?	Alena Rybakina	20:35
Re: pgsql: Consolidate docs for vacuum-related GUCs in new subsection	Melanie Plageman	20:35
Re: pgbench error: (setshell) of script 0; execution of meta-command failed	Nathan Bossart	20:49
Re: pgbench error: (setshell) of script 0; execution of meta-command failed	Tom Lane	20:51
Re: Skip collecting decoded changes of already-aborted transactions	Masahiko Sawada	21:40
Re: Proposal: Progressive explain	Adrien Nayrat	21:55
Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size	Peter Smith	21:58
Re: Sample rate added to pg_stat_statements	Sami Imseih	22:07
Re: POC: track vacuum/analyze cumulative time per relation 📎	Sami Imseih	23:01

Browse Archives

Prev | Next