pgsql-hackers since 2022-12-06 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

Dec. 6, 2022

Thread	Author	Time
Re: predefined role(s) for VACUUM and ANALYZE 📎	Nathan Bossart	00:04
Re: [PoC] Federated Authn/z with OAUTHBEARER	Andrey Chudnovsky	00:15
Re: pg_basebackup: add test about zstd compress option	Ian Lawrence Barwick	00:15
Re: [PATCH] Add native windows on arm64 support	Michael Paquier	00:16
Re: Error-safe user functions	Tom Lane	00:18
Re: Transaction timeout	Andres Freund	00:22
Re: Add LZ4 compression in pg_dump	Michael Paquier	00:22
Re: [PATCH] Check snapshot argument of index_beginscan and family	Alexander Korotkov	00:31
Re: missing indexes in indexlist with partitioned tables 📎	Arne Roland	00:43
Re: Transaction timeout	Kyotaro Horiguchi	00:44
Re: doc: add missing "id" attributes to extension packaging page	Ian Lawrence Barwick	00:55
Re: Error-safe user functions	Andres Freund	00:56
Re: docs: add missing <varlistentry> id elements for developer GUCs	Ian Lawrence Barwick	00:59
Re: Error-safe user functions	Tom Lane	01:06
Re: Transaction timeout	Andres Freund	01:10
Re: Error-safe user functions	Andres Freund	01:14
Re: Error-safe user functions	Tom Lane	01:19
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?) 📎	Melanie Plageman	01:49
Re: MemoizePath fails to work for partitionwise join	Richard Guo	01:58
Re: Error-safe user functions	Andres Freund	02:23
Re: Error-safe user functions	Tom Lane	02:32
Re: Generate pg_stat_get_* functions with Macros 📎	Michael Paquier	02:45
Re: Add index scan progress to pg_stat_progress_vacuum	Masahiko Sawada	03:18
Re: ANY_VALUE aggregate	Vik Fearing	03:46
Re: Perform streaming logical transactions by background workers and parallel apply	Amit Kapila	03:51
Re: ANY_VALUE aggregate	Vik Fearing	03:52
Re: Generate pg_stat_get_* functions with Macros	Nathan Bossart	03:54
Re: ANY_VALUE aggregate	Isaac Morland	04:06
Re: move some bitmapset.c macros to bitmapset.h	John Naylor	04:17
Re: ANY_VALUE aggregate	David G. Johnston	04:22
Re: Generate pg_stat_get_* functions with Macros	Drouvot, Bertrand	04:28
Re: ANY_VALUE aggregate	Vik Fearing	04:48
Re: ANY_VALUE aggregate	David G. Johnston	04:57
Re: move some bitmapset.c macros to bitmapset.h	Tom Lane	04:57
Re: Generate pg_stat_get_* functions with Macros	Drouvot, Bertrand	05:04
Re: ANY_VALUE aggregate	Vik Fearing	05:40
Re: move some bitmapset.c macros to bitmapset.h	David Rowley	05:46
Re: move some bitmapset.c macros to bitmapset.h	Tom Lane	05:57
Re: move some bitmapset.c macros to bitmapset.h 📎	John Naylor	06:21
Force streaming every change in logical decoding 📎	[email protected]	06:23
RE: Avoid streaming the transaction which are skipped (in corner cases)	[email protected]	06:25
Re: move some bitmapset.c macros to bitmapset.h	Tom Lane	06:29
Re: Generate pg_stat_get_* functions with Macros	Bharath Rupireddy	06:53
Re: Add LSN along with offset to error messages reported for WAL file read/write/validate header failures	Kyotaro Horiguchi	07:27
Re: O(n) tasks cause lengthy startups and checkpoints	Bharath Rupireddy	07:28
Re: Perform streaming logical transactions by background workers and parallel apply	Amit Kapila	07:50
Re: Time delayed LR (WAS Re: logical replication restrictions)	Peter Smith	08:00
Re: Generate pg_stat_get_* functions with Macros	Michael Paquier	08:01
Re: Perform streaming logical transactions by background workers and parallel apply	Peter Smith	08:22
Re: Question regarding "Make archiver process an auxiliary process. commit"	Kyotaro Horiguchi	08:24
Re: doc: add missing "id" attributes to extension packaging page	Brar Piening	08:25
Re: doc: add missing "id" attributes to extension packaging page	Alvaro Herrera	08:38
Re: refactor ExecGrant_*() functions 📎	Antonin Houska	08:41
A problem about ParamPathInfo for an AppendPath	Richard Guo	09:00
Re: Add semi-join pushdown to postgres_fdw 📎	Alexander Pyhalov	09:28
Re: Allow batched insert during cross-partition updates	Etsuro Fujita	09:48
Re: Fix gin index cost estimation 📎	Ronan Dunklau	10:22
RE: Add semi-join pushdown to postgres_fdw	[email protected]	10:25
Re: Force streaming every change in logical decoding	Amit Kapila	10:28
Re: [PoC] Improve dead tuple storage for lazy vacuum 📎	John Naylor	10:32
Re: Time delayed LR (WAS Re: logical replication restrictions)	Amit Kapila	11:10
Re: [PoC] Reducing planning time when tables have many partitions	Thom Brown	11:16
Re: Add LSN along with offset to error messages reported for WAL file read/write/validate header failures	Bharath Rupireddy	11:16
Re: Schema variables - new implementation for Postgres 15 📎	Pavel Stehule	11:16
Re: Question regarding "Make archiver process an auxiliary process. commit" 📎	Sravan Kumar	11:27
Re: Error-safe user functions	Andrew Dunstan	11:46
Re: predefined role(s) for VACUUM and ANALYZE 📎	Dagfinn Ilmari Mannsåker	11:47
Re: Question regarding "Make archiver process an auxiliary process. commit"	Bharath Rupireddy	11:53
Re: Using WaitEventSet in the postmaster 📎	Thomas Munro	11:58
RE: Time delayed LR (WAS Re: logical replication restrictions)	Takamichi Osumi (Fujitsu)	12:13
Re: pg_basebackup: add test about zstd compress option	Dong Wook Lee	12:53
Re: [PATCH] Check snapshot argument of index_beginscan and family	Pavel Borisov	13:44
Re: Add tracking of backend memory allocated to pg_stat_activity	Reid Thompson	13:47
Re: Force streaming every change in logical decoding	Masahiko Sawada	13:48
Re: predefined role(s) for VACUUM and ANALYZE	Pavel Luzanov	13:57
Re: Missing MaterialPath support in reparameterize_path_by_child	Ashutosh Bapat	14:37
Re: Error-safe user functions	Tom Lane	14:42
Re: Missing MaterialPath support in reparameterize_path_by_child	Tom Lane	14:52
Re: old_snapshot: add test for coverage	Dong Wook Lee	15:00
Re: Allow placeholders in ALTER ROLE w/o superuser 📎	Alexander Korotkov	15:00
Re: Improve tab completion for ALTER FUNCTION/PROCEDURE/ROUTINE	Melih Mutlu	15:12
Re: ExecRTCheckPerms() and many prunable partitions	Alvaro Herrera	15:19
Re: Error-safe user functions	Andrew Dunstan	15:43
Re: Add LZ4 compression in pg_dump 📎	gkokolatos	15:52
Re: Error-safe user functions	Tom Lane	16:07
Re: wake up logical workers after ALTER SUBSCRIPTION	Melih Mutlu	16:44
Re: Error-safe user functions	Robert Haas	17:10
Re: Add tracking of backend memory allocated to pg_stat_activity	Andres Freund	17:55
Re: doc: add missing "id" attributes to extension packaging page	Brar Piening	17:59
Re: doc: add missing "id" attributes to extension packaging page 📎	Brar Piening	18:11
Re: pg_upgrade test failure	Andres Freund	18:15
Re: doc: add missing "id" attributes to extension packaging page 📎	Brar Piening	18:16
Re: Error-safe user functions	Corey Huinker	18:16
Re: Make EXPLAIN generate a generic plan for a parameterized query	Andres Freund	18:17
Re: [Proposal] Add foreign-server health checks infrastructure	Andres Freund	18:26
Re: Add the ability to limit the amount of memory that can be allocated to backends.	Andres Freund	18:32
Re: PATCH: AM-specific statistics, with an example implementation for BRIN (WIP)	Andres Freund	18:34
Re: doc: add missing "id" attributes to extension packaging page	Brar Piening	18:35
Re: Eliminating SPI from RI triggers - take 2	Andres Freund	18:37
Re: RFC: Logging plan of the running query	Andres Freund	18:41
Re: New strategies for freezing, advancing relfrozenxid early	Andres Freund	18:42
Re: May be BUG. Periodic burst growth of the checkpoint_req counter on replica.	Andres Freund	18:44
Re: Removing unneeded self joins	Andres Freund	18:46
Re: Temporary tables versus wraparound... again	Greg Stark	18:47
Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher	Andres Freund	18:47
Re: PATCH: Using BRIN indexes for sorted output	Andres Freund	18:51
Re: Support logical replication of DDLs 📎	vignesh C	18:52
Re: 16: Collation versioning and dependency helpers	Andres Freund	18:53
Re: Temporary tables versus wraparound... again	Andres Freund	18:59
Re: generic plans and "initial" pruning	Alvaro Herrera	19:00
Re: Time delayed LR (WAS Re: logical replication restrictions)	Andres Freund	19:08
Re: Split index and table statistics into different types of stats 📎	Drouvot, Bertrand	19:11
Re: Improve tab completion for ALTER FUNCTION/PROCEDURE/ROUTINE 📎	vignesh C	19:11
Re: wake up logical workers after ALTER SUBSCRIPTION 📎	Nathan Bossart	19:25
Re: Cygwin cleanup	Andres Freund	19:31
add \dpS to psql 📎	Nathan Bossart	19:36
Re: 16: Collation versioning and dependency helpers	Jeff Davis	19:37
Re: predefined role(s) for VACUUM and ANALYZE	Nathan Bossart	19:38
Re: Temporary tables versus wraparound... again	Greg Stark	19:50
Re: predefined role(s) for VACUUM and ANALYZE	Nathan Bossart	19:51
Re: Temporary tables versus wraparound... again	Andres Freund	20:18
Re: Error-safe user functions 📎	Tom Lane	20:21
Re: Error-safe user functions	Tom Lane	20:29
Re: Cygwin cleanup	Thomas Munro	20:35
Re: [PATCH] Infinite loop while acquiring new TOAST Oid	Nikita Malakhov	21:00
Re: wake up logical workers after ALTER SUBSCRIPTION 📎	Nathan Bossart	21:29
Re: New strategies for freezing, advancing relfrozenxid early	Peter Geoghegan	21:45
core dumps generated in archive / restore commands etc	Andres Freund	21:58
Re: Allow placeholders in ALTER ROLE w/o superuser 📎	Pavel Borisov	22:26
Re: Using WaitEventSet in the postmaster	Andres Freund	23:12
Re: Allow pageinspect's bt_page_stats function to return a set of rows instead of a single row	Andres Freund	23:16
remove extra space from dumped ALTER DEFAULT PRIVILEGES commands 📎	Nathan Bossart	23:27
Re: Force streaming every change in logical decoding	Peter Smith	23:45

Dec. 7, 2022

Thread	Author	Time
Re: Generate pg_stat_get_* functions with Macros	Michael Paquier	00:16
Collation DDL inconsistencies	Jeff Davis	00:33
Re: Query Jumbling for CALL and SET utility statements	Michael Paquier	00:57
Re: Using WaitEventSet in the postmaster	Justin Pryzby	01:08
Re: Using WaitEventSet in the postmaster 📎	Thomas Munro	01:12
Re: Using WaitEventSet in the postmaster	Thomas Munro	01:13
Re: Force streaming every change in logical decoding	Peter Smith	01:14
Re: Using WaitEventSet in the postmaster	Andres Freund	01:22
Re: [DOCS] Stats views and functions not in order?	Peter Smith	01:36
Re: Force streaming every change in logical decoding	Masahiko Sawada	02:00
Creating HeapTuple from char and date values	Amin	02:06
Re: Force streaming every change in logical decoding	Amit Kapila	02:44
Re: Transaction timeout	Kyotaro Horiguchi	02:52
Re: Commit fest 2022-11	vignesh C	02:55
Re: [DOCS] Stats views and functions not in order?	David G. Johnston	02:57
RE: Perform streaming logical transactions by background workers and parallel apply 📎	[email protected]	02:58
Re: Time delayed LR (WAS Re: logical replication restrictions)	Kyotaro Horiguchi	02:59
RE: Perform streaming logical transactions by background workers and parallel apply	[email protected]	03:01
Re: meson PGXS compatibility	Andres Freund	03:05
Re: Using WaitEventSet in the postmaster 📎	Thomas Munro	03:16
Re: Commit fest 2022-11	Michael Paquier	03:20
Re: ANY_VALUE aggregate	David G. Johnston	03:22
Re: [RFC] building postgres with meson - v13 📎	Andres Freund	03:25
Re: Perform streaming logical transactions by background workers and parallel apply	Masahiko Sawada	03:29
Re: Force streaming every change in logical decoding	Amit Kapila	03:55
Re: Avoid streaming the transaction which are skipped (in corner cases)	Amit Kapila	03:58
Re: Avoid streaming the transaction which are skipped (in corner cases)	Dilip Kumar	04:00
RE: Avoid streaming the transaction which are skipped (in corner cases)	[email protected]	04:05
Re: Perform streaming logical transactions by background workers and parallel apply	Amit Kapila	04:28
Re: Perform streaming logical transactions by background workers and parallel apply	Masahiko Sawada	04:39
Re: Is the plan for IN(1,2,3) always the same as for =ANY('{1,2,3}') when using PQexec with no params?	Dmitry Koterov	04:45
Re: Time delayed LR (WAS Re: logical replication restrictions)	Amit Kapila	05:06
RE: Time delayed LR (WAS Re: logical replication restrictions)	Takamichi Osumi (Fujitsu)	05:23
Re: Force streaming every change in logical decoding	Masahiko Sawada	05:24
Re: Question regarding "Make archiver process an auxiliary process. commit"	Sravan Kumar	05:58
RE: [Proposal] Add foreign-server health checks infrastructure 📎	Hayato Kuroda (Fujitsu)	05:59
Re: Question regarding "Make archiver process an auxiliary process. commit"	Kyotaro Horiguchi	06:01
Re: Question regarding "Make archiver process an auxiliary process. commit"	Kyotaro Horiguchi	06:19
Re: ExecRTCheckPerms() and many prunable partitions	Amit Langote	07:01
Re: PGDOCS - Logical replication GUCs - added some xrefs 📎	Peter Smith	07:12
Re: Perform streaming logical transactions by background workers and parallel apply	Amit Kapila	07:31
Re: add \dpS to psql	Pavel Luzanov	07:48
Re: Force streaming every change in logical decoding	Amit Kapila	07:51
Generating code for query jumbling through gen_node_support.pl 📎	Michael Paquier	07:56
Re: Allow pageinspect's bt_page_stats function to return a set of rows instead of a single row	Alvaro Herrera	08:01
Re: May be BUG. Periodic burst growth of the checkpoint_req counter on replica. 📎	Anton A. Melnikov	08:03
Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15) 📎	Aleksander Alekseev	08:40
Re: ExecRTCheckPerms() and many prunable partitions 📎	Amit Langote	08:47
Re: Improve tab completion for ALTER FUNCTION/PROCEDURE/ROUTINE	Melih Mutlu	08:55
Re: ANY_VALUE aggregate	Pantelis Theodosiou	08:58
Re: Minimal logical decoding on standbys 📎	Drouvot, Bertrand	09:00
on placeholder entries in view rule action query's range table 📎	Amit Langote	09:42
Re: on placeholder entries in view rule action query's range table	Amit Langote	09:47
Re: Split index and table statistics into different types of stats 📎	Drouvot, Bertrand	10:11
Re: Allow pageinspect's bt_page_stats function to return a set of rows instead of a single row 📎	Hamid Akhtar	10:23
Re: ExecRTCheckPerms() and many prunable partitions	Alvaro Herrera	10:42
Re: Perform streaming logical transactions by background workers and parallel apply	Amit Kapila	10:48
Re: ExecRTCheckPerms() and many prunable partitions	Amit Langote	10:50
Re: wake up logical workers after ALTER SUBSCRIPTION	Melih Mutlu	11:07
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features)	Nikita Malakhov	11:15
Re: Support logical replication of DDLs 📎	vignesh C	11:22
Re: Make EXPLAIN generate a generic plan for a parameterized query 📎	Laurenz Albe	11:23
Re: [PoC] Reducing planning time when tables have many partitions 📎	Yuya Watari	11:30
Re: ExecRTCheckPerms() and many prunable partitions	Alvaro Herrera	11:44
Re: Perform streaming logical transactions by background workers and parallel apply	Masahiko Sawada	11:51
moving extraUpdatedCols out of RangeTblEntry (into ModifyTable) 📎	Amit Langote	11:54
Directly associate primary key with user-defined tablespace	MichaelDBA	11:56

Browse Archives

Prev | Next