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

March 3, 2023

Thread	Author	Time
Re: Rework LogicalOutputPluginWriterUpdateProgress	Peter Smith	00:18
Re: Evaluate arguments of correlated SubPlans in the referencing ExprState 📎	Andres Freund	00:19
Re: Add the ability to limit the amount of memory that can be allocated to backends.	Andres Freund	00:29
Re: Allow logical replication to copy tables in binary format	Peter Smith	00:32
Re: Normalization of utility queries in pg_stat_statements 📎	Michael Paquier	00:37
Re: Rework LogicalOutputPluginWriterUpdateProgress	Andres Freund	00:37
Re: Making empty Bitmapsets always be NULL 📎	David Rowley	01:52
Re: Understanding, testing and improving our Windows filesystem code	Thomas Munro	01:52
Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher	Peter Smith	02:10
Re: Making empty Bitmapsets always be NULL	Tom Lane	02:17
RE: Rework LogicalOutputPluginWriterUpdateProgress	[email protected]	02:27
Re: Rework LogicalOutputPluginWriterUpdateProgress	Peter Smith	02:43
Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher	Amit Kapila	02:46
Re: Making empty Bitmapsets always be NULL	David Rowley	03:22
RE: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher	[email protected]	03:40
min/max aggregation for jsonb	Daneel Yaitskov	04:24
Re: Date-time extraneous fields with reserved keywords	Keisuke Kuroda	04:41
Re: Remove source code display from \df+?	Isaac Morland	04:49
Re: [EXTERNAL] Re: Support load balancing in libpq	Andrey Borodin	04:52
Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher	Peter Smith	05:10
Re: Add pg_walinspect function with block info columns	Michael Paquier	05:36
Re: Real config values for bytes needs quotes? 📎	Kyotaro Horiguchi	05:38
Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher	Amit Kapila	06:19
Re: Add SHELL_EXIT_CODE to psql	Corey Huinker	06:23
Re: Force testing of query jumbling code in TAP tests	Michael Paquier	06:28
Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher	vignesh C	06:40
Re: meson: Optionally disable installation of test modules	Peter Eisentraut	06:47
Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher	Önder Kalacı	07:39
Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher 📎	Önder Kalacı	07:39
Re: Minimal logical decoding on standbys 📎	Jeff Davis	07:58
Re: Flush SLRU counters in checkpointer process 📎	Anthonin Bonnefoy	08:06
Re: Simplify standby state machine a bit in WaitForWALToBecomeAvailable()	Bharath Rupireddy	08:08
RE: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher	Hayato Kuroda (Fujitsu)	08:46
Re: In-placre persistance change of a relation 📎	Kyotaro Horiguchi	09:03
Re: Add documentation for coverage reports with meson	Peter Eisentraut	09:10
Re: meson: Non-feature feature options	Peter Eisentraut	09:16
Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher 📎	Önder Kalacı	09:32
Re: meson: Non-feature feature options 📎	Nazir Bilal Yavuz	10:01
Re: cataloguing NOT NULL constraints	Peter Eisentraut	10:15
Re: Missing update of all_hasnulls in BRIN opclasses 📎	Alvaro Herrera	10:32
Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher	Amit Kapila	10:34
Re: min/max aggregation for jsonb	David Rowley	10:41
Re: Deduplicate logicalrep_read_tuple() 📎	Bharath Rupireddy	10:43
Re: cataloguing NOT NULL constraints	Alvaro Herrera	10:47
Re: psql: Add role's membership options to the \du+ command	Pavel Luzanov	11:01
Re: [PoC] Improve dead tuple storage for lazy vacuum	John Naylor	11:03
Re: Deduplicate logicalrep_read_tuple()	Amit Kapila	11:04
Re: Add documentation for coverage reports with meson 📎	Michael Paquier	11:12
Re: Simplify standby state machine a bit in WaitForWALToBecomeAvailable()	Michael Paquier	11:13
Re: Add support for unit "B" to pg_size_pretty()	David Rowley	11:23
Re: Fix comments in gistxlogDelete, xl_heap_freeze_page and xl_btree_delete	Amit Kapila	11:30
Re: Testing autovacuum wraparound (including failsafe)	Heikki Linnakangas	11:34
Re: Allow ordered partition scans in more cases	David Rowley	11:56
Re: Missing update of all_hasnulls in BRIN opclasses	Tomas Vondra	12:14
Re: Add support for unit "B" to pg_size_pretty()	Dean Rasheed	12:22
RE: [Proposal] Add foreign-server health checks infrastructure 📎	Hayato Kuroda (Fujitsu)	12:24
What's MultiXactId?	[email protected]	12:37
Re: Allow tailoring of ICU locales with custom rules 📎	Peter Eisentraut	12:45
Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher 📎	Önder Kalacı	13:10
Re: Improve WALRead() to suck data directly from WAL buffers when possible 📎	Bharath Rupireddy	13:30
Re: Testing autovacuum wraparound (including failsafe) 📎	Heikki Linnakangas	13:41
Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher 📎	Önder Kalacı	14:15
Re: [EXTERNAL] Re: Support load balancing in libpq 📎	Jelte Fennema	14:37
Re: Non-superuser subscription owners	Robert Haas	14:43
Re: Missing free_var() at end of accum_sum_final()? 📎	Dean Rasheed	15:11
Re: Time delayed LR (WAS Re: logical replication restrictions)	Masahiko Sawada	15:21
Re: Timeline ID hexadecimal format	Sébastien Lardière	15:52
Re: libpq: PQgetCopyData() and allocation overhead	Jelte Fennema	15:52
running logical replication as the subscription owner 📎	Robert Haas	16:02
Re: Timeline ID hexadecimal format	Robert Haas	16:04
Re: libpq: PQgetCopyData() and allocation overhead	Jeroen Vermeulen	16:16
Re: pgsql: Harden new test case against force_parallel_mode = regress.	Robert Haas	16:16
Re: psql: Add role's membership options to the \du+ command	David G. Johnston	16:21
Re: Minimal logical decoding on standbys	Drouvot, Bertrand	16:23
Re: Minimal logical decoding on standbys	Drouvot, Bertrand	16:26
Re: Fix comments in gistxlogDelete, xl_heap_freeze_page and xl_btree_delete	Drouvot, Bertrand	16:28
Re: libpq: PQgetCopyData() and allocation overhead	Tom Lane	16:33
Re: pgsql: Harden new test case against force_parallel_mode = regress.	Tom Lane	16:37
Re: pgsql: Harden new test case against force_parallel_mode = regress.	Matthias van de Meent	16:38
Re: pgsql: Harden new test case against force_parallel_mode = regress.	Tom Lane	16:47
Re: libpq: PQgetCopyData() and allocation overhead	Jeroen Vermeulen	17:04
libpq-fe.h should compile *entirely* standalone 📎	Tom Lane	17:07
Re: libpq: PQgetCopyData() and allocation overhead	Tom Lane	17:14
Re: pgsql: Harden new test case against force_parallel_mode = regress.	Robert Haas	17:40
Re: pgsql: Harden new test case against force_parallel_mode = regress.	Tom Lane	17:46
Re: libpq: PQgetCopyData() and allocation overhead	Jelte Fennema	17:49
Re: Fix comments in gistxlogDelete, xl_heap_freeze_page and xl_btree_delete	Robert Haas	17:53
Re: libpq: PQgetCopyData() and allocation overhead	Tom Lane	17:55
Re: pgsql: Harden new test case against force_parallel_mode = regress.	Robert Haas	17:56
Re: pgsql: Harden new test case against force_parallel_mode = regress.	Tom Lane	18:03
Re: libpq: PQgetCopyData() and allocation overhead	Jeroen Vermeulen	18:25
Re: zstd compression for pg_dump	Jacob Champion	18:32
Re: libpq-fe.h should compile *entirely* standalone 📎	Tom Lane	18:46
Re: libpq: PQgetCopyData() and allocation overhead	Tom Lane	18:53
Re: zstd compression for pg_dump	Justin Pryzby	18:55
Re: libpq: PQgetCopyData() and allocation overhead 📎	Jeroen Vermeulen	19:30
Re: meson: Optionally disable installation of test modules	Andrew Dunstan	19:43
Re: Evaluate arguments of correlated SubPlans in the referencing ExprState	Tom Lane	20:09
Re: SQL JSON path enhanced numeric literals	Dean Rasheed	20:16
Re: Schema variables - new implementation for Postgres 15	Dmitry Dolgov	20:17
Re: zstd compression for pg_dump	Jacob Champion	21:38
Re: odd buildfarm failure - "pg_ctl: control file appears to be corrupt" 📎	Thomas Munro	21:39
Re: Making empty Bitmapsets always be NULL 📎	Tom Lane	22:08
Re: Raising the SCRAM iteration count 📎	Daniel Gustafsson	22:13
Re: running logical replication as the subscription owner	Jelte Fennema	23:57

March 4, 2023

Thread	Author	Time
Re: generate_series for timestamptz and time zone problem	Andreas 'ads' Scherbaum	00:28
Re: Simplify standby state machine a bit in WaitForWALToBecomeAvailable()	Nathan Bossart	00:33
Re: RADIUS tests and improvements 📎	Thomas Munro	01:23
Re: Simplify standby state machine a bit in WaitForWALToBecomeAvailable()	Michael Paquier	02:30
Re: [PoC] Let libpq reject unexpected authentication requests	Michael Paquier	02:35
Re: Simplify standby state machine a bit in WaitForWALToBecomeAvailable()	Bharath Rupireddy	02:44
Re: Simplify standby state machine a bit in WaitForWALToBecomeAvailable() 📎	Bharath Rupireddy	04:17
Re: Move defaults toward ICU in 16? 📎	Jeff Davis	05:45
Re: pg_upgrade and logical replication	Amit Kapila	06:13
Re: Fix comments in gistxlogDelete, xl_heap_freeze_page and xl_btree_delete	Drouvot, Bertrand	08:33
Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher	Amit Kapila	10:33
Re: Minimal logical decoding on standbys 📎	Drouvot, Bertrand	11:19
Re: libpq-fe.h should compile *entirely* standalone	Andrew Dunstan	12:08
Re: [HACKERS] make async slave to wait for lsn to be replayed 📎	Kartyshov Ivan	15:36
Re: Date-time extraneous fields with reserved keywords	Joseph Koshakow	16:33
Re: Request for comment on setting binary format output per session	Jeff Davis	16:35
Re: zstd compression for pg_dump	Justin Pryzby	16:57
Re: libpq-fe.h should compile *entirely* standalone	Tom Lane	17:12
Re: Date-time extraneous fields with reserved keywords 📎	Joseph Koshakow	17:29
Re: Missing free_var() at end of accum_sum_final()?	Joel Jacobson	18:27
Re: Add standard collation UNICODE	Jeff Davis	18:29
Re: Date-time extraneous fields with reserved keywords	Tom Lane	18:56
Re: [Proposal] Allow pg_dump to include all child tables with the root table	Tom Lane	19:18
Re: Add standard collation UNICODE	Thomas Munro	19:27
Re: Date-time extraneous fields with reserved keywords	Joseph Koshakow	19:32
Re: Date-time extraneous fields with reserved keywords	Tom Lane	19:48
Re: Latches vs lwlock contention 📎	Thomas Munro	19:50
Re: Date-time extraneous fields with reserved keywords 📎	Joseph Koshakow	20:05
Re: Date-Time dangling unit fix	Tom Lane	21:05
Re: Request for comment on setting binary format output per session	Dave Cramer	23:04
Re: Allow tests to pass in OpenSSL FIPS mode 📎	Tom Lane	23:04
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?)	Tom Lane	23:21
Re: Date-Time dangling unit fix	Joseph Koshakow	23:31
Re: Add standard collation UNICODE	Jeff Davis	23:56
Re: Request for comment on setting binary format output per session	Jeff Davis	23:58

March 5, 2023

Thread	Author	Time
Re: Request for comment on setting binary format output per session	Tom Lane	00:06
Re: Add standard collation UNICODE	Tom Lane	00:10
Re: Request for comment on setting binary format output per session	David G. Johnston	00:13
Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment 📎	Lukas Fittl	00:20
Re: Request for comment on setting binary format output per session	Dave Cramer	00:39
About default inBufSize (connection read buffer size) in libpq 📎	Трофимов Иван	02:42
Re: Deduplicate logicalrep_read_tuple()	Peter Smith	07:52
Re: [Proposal] Allow pg_dump to include all child tables with the root table	Gilles Darold	08:03
Re: Missing free_var() at end of accum_sum_final()?	Joel Jacobson	08:53
[Question] Similar Cost but variable execution time in sort	Ankit Kumar Pandey	11:00
How does pg implement the visiblity of one tuple for specified transaction?	[email protected]	13:19
Re: Date-Time dangling unit fix	Alexander Lakhin	14:00
Re: How does pg implement the visiblity of one tuple for specified transaction?	Ankit Kumar Pandey	15:27
Re: SQL JSON path enhanced numeric literals	Peter Eisentraut	15:55
Re: Date-Time dangling unit fix 📎	Joseph Koshakow	16:39
Re: [Question] Similar Cost but variable execution time in sort	Tom Lane	16:51
Re: zstd compression for pg_dump 📎	Justin Pryzby	17:47
Re: Date-Time dangling unit fix	Tom Lane	17:54
Re: [Question] Similar Cost but variable execution time in sort	Ankit Kumar Pandey	18:17
[PATCH] Add CANONICAL option to xmlserialize 📎	Jim Jones	18:44
Re: Should vacuum process config file reload more often 📎	Melanie Plageman	20:26
Re: [PATCH] Add CANONICAL option to xmlserialize	Thomas Munro	21:00
Re: Date-Time dangling unit fix	Joseph Koshakow	21:10
Re: Date-Time dangling unit fix 📎	Joseph Koshakow	21:14
Re: [PATCH] Add CANONICAL option to xmlserialize	Jim Jones	22:20
Re: Refactor to introduce pg_strcoll().	Thomas Munro	22:20
Re: [PATCH] Add CANONICAL option to xmlserialize	Thomas Munro	23:32

March 6, 2023

Thread	Author	Time
pg_rewind: Skip log directory for file type check like pg_wal 📎	Soumyadeep Chakraborty	02:10
Re: SQL/JSON revisited 📎	Amit Langote	03:18
Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes?	Michael Paquier	04:29
Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher	Peter Smith	04:41
Re: Removing unneeded self joins	Michał Kłeczek	05:30
Inaccurate comment for pg_get_partkeydef 📎	Japin Li	05:54
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?)	Kyotaro Horiguchi	06:24
Re: [PoC] Improve dead tuple storage for lazy vacuum	Masahiko Sawada	06:27
Re: Support logical replication of DDLs 📎	Ajin Cherian	06:34
Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher	Amit Kapila	06:44
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?) 📎	Kyotaro Horiguchi	06:48
Re: Reconcile stats in find_tabstat_entry() and get rid of PgStat_BackendFunctionEntry 📎	Drouvot, Bertrand	07:33
Re: shoud be get_extension_schema visible?	Julien Rouhaud	07:33
using memoize in in paralel query decreases performance 📎	Pavel Stehule	07:33
Re: shoud be get_extension_schema visible?	Pavel Stehule	07:34
Re: psql: Add role's membership options to the \du+ command	Pavel Luzanov	07:43
Re: shoud be get_extension_schema visible?	Michael Paquier	07:44
Re: add PROCESS_MAIN to VACUUM	Michael Paquier	07:51
Re: Simplify standby state machine a bit in WaitForWALToBecomeAvailable()	Michael Paquier	07:56
Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher	Peter Smith	08:10
Re: Add support for unit "B" to pg_size_pretty() 📎	Peter Eisentraut	08:13
Re: using memoize in in paralel query decreases performance	David Rowley	08:16
Re: Simplify standby state machine a bit in WaitForWALToBecomeAvailable()	Bharath Rupireddy	08:17
Re: Add support for unit "B" to pg_size_pretty()	David Rowley	08:27
Re: pg_rewind: Skip log directory for file type check like pg_wal	Alexander Kukushkin	08:28
Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher	Amit Kapila	08:40
Re: Combine pg_walinspect till_end_of_wal functions with others	Julien Rouhaud	08:52
Re: using memoize in in paralel query decreases performance	Pavel Stehule	08:54
Re: Allow tests to pass in OpenSSL FIPS mode	Daniel Gustafsson	09:02
Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher 📎	Önder Kalacı	09:08
wrong results due to qual pushdown	tender wang	09:30
Re: [HACKERS] make async slave to wait for lsn to be replayed 📎	Kartyshov Ivan	09:40
Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher	Amit Kapila	09:40

Browse Archives

Prev | Next