pgsql-hackers since 2025-01-22 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. 22, 2025

Thread	Author	Time
Re: Show WAL write and fsync stats in pg_stat_io	Michael Paquier	00:14
Re: improve DEBUG1 logging of parallel workers for CREATE INDEX?	Sami Imseih	00:33
Re: [PATCH] Optionally record Plan IDs to track plan changes for a query	Michael Paquier	00:46
Re: Some ExecSeqScan optimizations	Amit Langote	01:07
Re: Pre-allocating WAL files	Andy Fan	01:14
Re: Statistics Import and Export	jian he	01:36
RE: pgbench without dbname worked differently with psql and pg_dump 📎	Hayato Kuroda (Fujitsu)	01:54
Re: allow trigger to get updated columns 📎	Tom Lane	02:59
Re: pgbench without dbname worked differently with psql and pg_dump	David G. Johnston	03:11
Re: Statistics Import and Export 📎	Corey Huinker	03:21
RE: create subscription with (origin = none, copy_data = on) 📎	Zhijie Hou (Fujitsu)	03:30
Re: Skip collecting decoded changes of already-aborted transactions	Peter Smith	03:51
Re: SQL:2011 application time	Tom Lane	04:00
Re: Bug in detaching a partition with a foreign key.	Amul Sul	04:07
RE: pgbench without dbname worked differently with psql and pg_dump 📎	Hayato Kuroda (Fujitsu)	04:38
Re: Introduce XID age and inactive timeout based replication slot invalidation 📎	Nisha Moond	05:16
Re: Introduce XID age and inactive timeout based replication slot invalidation	Nisha Moond	05:19
pgsql: Doc: Update the interaction of tablesync with wal_retrieve_retry	Amit Kapila	05:34
Re: pg_createsubscriber TAP test wrapping makes command options hard to read.	Michael Paquier	05:50
Re: [RFC] Lock-free XLog Reservation from WAL	Japin Li	06:09
Re: Allow NOT VALID foreign key constraints on partitioned tables. 📎	Amul Sul	06:12
Re: Pgoutput not capturing the generated columns	Peter Smith	06:20
add function argument name to substring and substr	jian he	06:21
Re: SQLJSON: errmsg(" .. should ...") -> must	Amit Langote	06:41
Re: Pgoutput not capturing the generated columns	Peter Smith	06:47
Re: Eager aggregation, take 3	Richard Guo	06:48
Re: [RFC] Lock-free XLog Reservation from WAL	Yura Sokolov	07:25
Re: [RFC] Lock-free XLog Reservation from WAL	Japin Li	07:54
Re: libedit history seems to be misbehaving / broken	Rudolph Froger	08:05
Re: [RFC] Lock-free XLog Reservation from WAL	Yura Sokolov	08:22
[PATCH] Fix a tiny typo in the documentation	Robin Dupret	08:27
Re: Change GUC hashtable to use simplehash?	John Naylor	08:37
Re: [RFC] Lock-free XLog Reservation from WAL	Japin Li	08:49
Re: Doc: Move standalone backup section, mention -X argument	Benoit Lobréau	08:54
Inconsistent string comparison using modified ICU collations	Oleg Tselebrovskiy	09:03
Re: Windows: openssl & gssapi dislike each other	Daniel Gustafsson	09:17
Re: doc: explain pgstatindex fragmentation 📎	Benoit Lobréau	09:24
Re: Windows: openssl & gssapi dislike each other	Dave Page	09:25
Re: Proposal for Updating CRC32C with AVX-512 Algorithm.	John Naylor	09:48
Re: doc: explain pgstatindex fragmentation	Frédéric Yhuel	09:56
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart	Bertrand Drouvot	10:04
Re: Conflict detection for update_deleted in logical replication	Nisha Moond	10:04
Re: [PATCH] Fix a tiny typo in the documentation	Daniel Gustafsson	10:23
Re: Pgoutput not capturing the generated columns	Amit Kapila	10:51
Re: Adding a '--two-phase' option to 'pg_createsubscriber' utility. 📎	Shubham Khanna	10:53
Re: [PATCH] Hex-coding optimizations using SVE on ARM.	Chiranmoy.Bhattacharya@fujitsu.com	10:58
Re: [PATCH] Fix a tiny typo in the documentation	Daniel Gustafsson	11:01
Re: [PATCH] SVE popcount support	Chiranmoy.Bhattacharya@fujitsu.com	11:04
Re: Orphaned users in PG16 and above can only be managed by Superusers	Ashutosh Sharma	11:07
Re: [PATCH] Hex-coding optimizations using SVE on ARM. 📎	Chiranmoy.Bhattacharya@fujitsu.com	11:10
Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size 📎	Shubham Khanna	11:21
Re: doc: explain pgstatindex fragmentation	Bertrand Drouvot	11:34
RE: Conflict detection for update_deleted in logical replication 📎	Zhijie Hou (Fujitsu)	11:53
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options	Tatsuo Ishii	11:58
Re: Extend ALTER DEFAULT PRIVILEGES for large objects 📎	Laurenz Albe	12:30
Re: [RFC] Lock-free XLog Reservation from WAL	Japin Li	12:37
Re: An improvement of ProcessTwoPhaseBuffer logic 📎	Vitaly Davydov	12:45
Re: Set AUTOCOMMIT to on in script output by pg_dump 📎	Shinya Kato	13:01
Re: [PATCH] Add roman support for to_number function 📎	Hunaid Sohail	13:33
Re: [PATCH] Fix a tiny typo in the documentation	David G. Johnston	13:38
Re: Pgoutput not capturing the generated columns	Peter Eisentraut	13:52
Re: pg_stat_statements: improve loading and saving routines for the dump file	m.litsarev	13:54
Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided. 📎	Shubham Khanna	13:59
Re: Pgoutput not capturing the generated columns 📎	vignesh C	14:00
Re: [RFC] Lock-free XLog Reservation from WAL 📎	Yura Sokolov	14:02
Re: [PATCH] Improve code coverage of network address functions 📎	Aleksander Alekseev	14:05
Re: IWYU annotations	Peter Eisentraut	14:08
Re: [RFC] Lock-free XLog Reservation from WAL	Yura Sokolov	14:09
dblink: Add SCRAM pass-through authentication 📎	Matheus Alcantara	14:10
Re: IWYU annotations	Peter Geoghegan	14:22
Re: [RFC] Lock-free XLog Reservation from WAL	Japin Li	14:44
Re: [PATCH] SVE popcount support	Nathan Bossart	15:27
Re: pg_createsubscriber TAP test wrapping makes command options hard to read. 📎	Dagfinn Ilmari Mannsåker	15:34
Re: [PATCH] Fix a tiny typo in the documentation	Tom Lane	15:34
Re: create subscription with (origin = none, copy_data = on) 📎	Shlok Kyal	15:41
Quadratic planning time for ordered paths over partitioned tables 📎	Alexander Kuzmenkov	15:44
Re: Pre-allocating WAL files	Nathan Bossart	15:50
Re: Pre-allocating WAL files	Nathan Bossart	15:56
Converting pqsignal to void return	Paul Ramsey	15:57
Re: RFC: Additional Directory for Extensions	Peter Eisentraut	16:07
Re: create subscription with (origin = none, copy_data = on)	Sergey Tatarintsev	16:13
Re: Pre-allocating WAL files	Andres Freund	16:21
Re: Converting pqsignal to void return	Nathan Bossart	16:22
Re: Quadratic planning time for ordered paths over partitioned tables	Alvaro Herrera	16:36
Re: Converting pqsignal to void return	Andres Freund	16:50
Re: Quadratic planning time for ordered paths over partitioned tables	Alexander Kuzmenkov	16:50
Re: Converting pqsignal to void return	Andres Freund	17:01
Re: Converting pqsignal to void return	Paul Ramsey	17:01
Re: Quadratic planning time for ordered paths over partitioned tables	Alvaro Herrera	17:05
Re: Quadratic planning time for ordered paths over partitioned tables	Tom Lane	17:15
Re: Converting pqsignal to void return	Andres Freund	17:36
Re: Pre-allocating WAL files	Nathan Bossart	17:43
Re: Converting pqsignal to void return	Paul Ramsey	17:50
Invalid index on partitioned table - is this a bug or feature?	Dmitry Koval	17:51
Re: Invalid index on partitioned table - is this a bug or feature?	Álvaro Herrera	17:57
Re: Quadratic planning time for ordered paths over partitioned tables	Alexander Kuzmenkov	17:57
Re: Pre-allocating WAL files	Andres Freund	18:00
Re: Invalid index on partitioned table - is this a bug or feature?	Dmitry Koval	18:03
Re: Update Unicode data to Unicode 16.0.0	Peter Eisentraut	18:03
Re: Update Unicode data to Unicode 16.0.0	Peter Eisentraut	18:08
Re: Converting pqsignal to void return	Andres Freund	18:15
Re: pg_attribute_noreturn(), MSVC, C11	Peter Eisentraut	18:16
Extended Statistics set/restore/clear functions. 📎	Corey Huinker	18:17
Re: Wrong security context for deferred triggers?	Tom Lane	18:25
Re: Update Unicode data to Unicode 16.0.0	Jeff Davis	18:32
Re: XMLDocument (SQL/XML X030)	Robert Treat	18:41
Re: [PATCH] Add get_bytes() and set_bytes() functions	Peter Eisentraut	18:44
Re: Replace current implementations in crypt() and gen_salt() to OpenSSL	Joe Conway	18:59
Re: attndims, typndims still not enforced, but make the value within a sane threshold	Bruce Momjian	19:32
Re: Issue with markers in isolation tester? Or not?	Noah Misch	20:12
Re: [PATCH] Add roman support for to_number function	Tom Lane	20:29
Re: Proposal: "query_work_mem" GUC, to distribute working memory to the query's individual operators	Tomas Vondra	20:48
Re: 回复：Re: 回复：Re: speed up pg_upgrade with large number of tables	Nathan Bossart	20:49
Re: Proposal: "query_work_mem" GUC, to distribute working memory to the query's individual operators	Tomas Vondra	21:13
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart	Masahiko Sawada	21:17
Re: Purpose of wal_init_zero	Robert Pang	21:18
Re: BitmapHeapScan streaming read user and prelim refactoring 📎	Melanie Plageman	21:24
Re: Set AUTOCOMMIT to on in script output by pg_dump	Robert Treat	21:33
Re: XMLDocument (SQL/XML X030)	Chapman Flack	21:35
Re: Sample rate added to pg_stat_statements 📎	Ilia Evdokimov	22:11
Re: Update Unicode data to Unicode 16.0.0	Jeff Davis	22:12
Re: Wrong security context for deferred triggers? 📎	Tom Lane	22:12
Re: Proposal: "query_work_mem" GUC, to distribute working memory to the query's individual operators	Jeff Davis	22:42
Re: Eagerly scan all-visible pages to amortize aggressive vacuum 📎	Melanie Plageman	22:48
Re: Replace current implementations in crypt() and gen_salt() to OpenSSL 📎	Daniel Gustafsson	22:49
Re: Extended Statistics set/restore/clear functions.	Tomas Vondra	22:50
Re: XMLDocument (SQL/XML X030)	Jim Jones	23:55

Jan. 23, 2025

Thread	Author	Time
Re: Pgoutput not capturing the generated columns 📎	Peter Smith	00:22
Re: New process of getting changes into the commitfest app	Jacob Brazeal	00:25
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart	Masahiko Sawada	00:46
Re: Pgoutput not capturing the generated columns	Peter Smith	00:50
Re: Change GUC hashtable to use simplehash?	Anton A. Melnikov	01:52
Re: Increase NUM_XLOGINSERT_LOCKS	Japin Li	02:30
Re: create subscription with (origin = none, copy_data = on)	Amit Kapila	02:46
Re: Skip collecting decoded changes of already-aborted transactions	Amit Kapila	03:17
Re: Doc: Move standalone backup section, mention -X argument	David G. Johnston	03:18
Re: Skip collecting decoded changes of already-aborted transactions	Peter Smith	03:35
Re: Pgoutput not capturing the generated columns 📎	Peter Smith	03:48
Re: Pgoutput not capturing the generated columns	Amit Kapila	03:53
Re: Separate GUC for replication origins	Keisuke Kuroda	04:19
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options	Tatsuo Ishii	04:25
Re: Pgoutput not capturing the generated columns 📎	vignesh C	04:28
Re: AIO v2.3 📎	Andres Freund	04:29
Re: Adding a '--two-phase' option to 'pg_createsubscriber' utility.	Peter Smith	04:55
Re: Converting pqsignal to void return	Michael Paquier	05:08
Re: Sample rate added to pg_stat_statements	Andrey Borodin	05:21
Re: Increase NUM_XLOGINSERT_LOCKS	wenhui qiu	05:41
Re: Pgoutput not capturing the generated columns	Peter Smith	05:47
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options	Krasiyan Andreev	06:08
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options	Tatsuo Ishii	06:27
Re: XMLDocument (SQL/XML X030)	Pavel Stehule	06:50
Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size	Peter Smith	06:59
Re: pg_createsubscriber TAP test wrapping makes command options hard to read.	Michael Paquier	07:05
Re: create subscription with (origin = none, copy_data = on)	Shlok Kyal	07:05
Re: generic plans and "initial" pruning 📎	Amit Langote	07:15
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart	Bertrand Drouvot	07:42
Re: Statistics Import and Export	Michael Paquier	07:49
Re: per backend WAL statistics	Michael Paquier	08:05
why -Fdance archive format option works with ./pg_restore but not with ./pg_dump?	Srinath Reddy	08:18
Re: create subscription with (origin = none, copy_data = on) 📎	Shlok Kyal	08:42
Re: Sample rate added to pg_stat_statements 📎	Ilia Evdokimov	08:46
Re: [RFC] Lock-free XLog Reservation from WAL	Japin Li	08:46
Re: doc: explain pgstatindex fragmentation	Frédéric Yhuel	09:00
Re: Make COPY format extendable: Extract COPY TO format implementations	Sutou Kouhei	09:09
Re: Make COPY format extendable: Extract COPY TO format implementations 📎	Sutou Kouhei	09:12
Re: Non-text mode for pg_dumpall 📎	jian he	09:28
Re: per backend WAL statistics	Bertrand Drouvot	09:57
Re: Doc: Move standalone backup section, mention -X argument	Benoit Lobréau	10:21
Re: Extend ALTER DEFAULT PRIVILEGES for large objects	Yugo NAGATA	10:22
Re: Wrong security context for deferred triggers? 📎	Laurenz Albe	10:26
Re: Non-text mode for pg_dumpall	Mahendra Singh Thalor	10:35
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart	Ashutosh Bapat	11:24
Re: pgsql: Doc: Update the interaction of tablesync with wal_retrieve_retry	Erik Rijkers	11:26
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Ashutosh Bapat	11:33
Re: Pgoutput not capturing the generated columns	Amit Kapila	11:33
Re: Convert macros to static inline functions	Peter Eisentraut	11:38
RE: Conflict detection for update_deleted in logical replication 📎	Zhijie Hou (Fujitsu)	11:47
Re: Virtual generated columns	Shlok Kyal	11:52
Re: [RFC] Lock-free XLog Reservation from WAL	Yura Sokolov	12:03
Re: pgsql: Doc: Update the interaction of tablesync with wal_retrieve_retry	Amit Kapila	12:11
Re: Pgoutput not capturing the generated columns 📎	vignesh C	12:19
RE: create subscription with (origin = none, copy_data = on)	Zhijie Hou (Fujitsu)	12:24
Re: Pgoutput not capturing the generated columns	Daniel Gustafsson	12:44
Re: Increase NUM_XLOGINSERT_LOCKS	Yura Sokolov	12:50
New process of getting changes into the commitfest app	Jelte Fennema-Nio	12:57
RE: Pgoutput not capturing the generated columns 📎	Shinoda, Noriyoshi (SXD Japan FSI)	13:02
Re: create subscription with (origin = none, copy_data = on)	Sergey Tatarintsev	13:03
Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size 📎	Shubham Khanna	13:11
Re: New process of getting changes into the commitfest app	Jelte Fennema-Nio	13:17
Re: Modern SHA2- based password hashes for pgcrypto	Japin Li	13:36
Re: [RFC] Lock-free XLog Reservation from WAL	Japin Li	13:44
Re: Increase NUM_XLOGINSERT_LOCKS	Japin Li	13:45
Re: doc: explain pgstatindex fragmentation 📎	Laurenz Albe	13:52
Re: [PATCH] Add get_bytes() and set_bytes() functions	Aleksander Alekseev	14:30
Re: [PATCH] Fix a tiny typo in the documentation	Robin Dupret	14:42
Re: Extended Statistics set/restore/clear functions.	Corey Huinker	14:51
Improve verification of recovery_target_timeline GUC. 📎	David Steele	14:53
Re: Allow NOT VALID foreign key constraints on partitioned tables.	Álvaro Herrera	15:04
Re: XMLDocument (SQL/XML X030) 📎	Jim Jones	15:06
Re: Compression of bigger WAL records	Japin Li	15:13

Browse Archives

Prev | Next