pgsql-hackers since 2021-07-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

July 13, 2021

Thread	Author	Time
Re: proposal - psql - use pager for \watch command	Thomas Munro	00:01
Re: enable_resultcache confusion	David Rowley	00:01
Re: [PATCH] Pull general SASL framework out of SCRAM	Jacob Champion	00:01
Re: Fix comments of heap_prune_chain()	Alvaro Herrera	00:17
Re: Incorrect usage of strtol, atoi for non-numeric junk inputs	Michael Paquier	00:28
Re: [PATCH] Pull general SASL framework out of SCRAM	Michael Paquier	00:47
Re: Small documentation improvement for ALTER SUBSCRIPTION	Masahiko Sawada	01:05
Re: Fix comments of heap_prune_chain()	Kyotaro Horiguchi	01:22
Re: O_DIRECT on macOS	Thomas Munro	01:25
Re: Is tuplesort meant to support bounded datum sorts?	David Rowley	01:36
Re: Introduce pg_receivewal gzip compression tests 📎	Michael Paquier	01:53
Re: O_DIRECT on macOS	Andres Freund	01:56
Re: Bogus HAVE_DECL_FOO entries in msvc/Solution.pm	Michael Paquier	01:56
Re: Remove useless int64 range checks on BIGINT sequence MINVALUE/MAXVALUE values	David Rowley	02:00
Re: Synchronous commit behavior during network outage	Jeff Davis	02:22
Question about non-blocking mode in libpq	Yugo NAGATA	02:59
Re: [PATCH] Use optimized single-datum tuplesort in ExecSort 📎	David Rowley	03:15
Re: row filtering for logical replication 📎	Peter Smith	03:25
Re: [CLOBBER_CACHE]Server crashed with segfault 11 while executing clusterdb	Amul Sul	03:48
Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors	Tatsuo Ishii	04:00
RE: Transactions involving multiple postgres foreign servers, take 2 📎	[email protected]	04:13
Re: Bogus HAVE_DECL_FOO entries in msvc/Solution.pm	Peter Eisentraut	04:17
Re: Bogus HAVE_DECL_FOO entries in msvc/Solution.pm	Tom Lane	04:25
Re: Diagnostic comment in LogicalIncreaseXminForSlot	Ashutosh Bapat	04:30
Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors	Yugo NAGATA	04:32
Re: proposal - psql - use pager for \watch command	Pavel Stehule	04:34
Re: Add proper planner support for ORDER BY / DISTINCT aggregates 📎	David Rowley	04:44
Re: row filtering for logical replication	Amit Kapila	04:54
Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors	Tatsuo Ishii	05:35
Re: Failed transaction statistics to measure the logical replication progress	vignesh C	05:50
Re: printf %s with NULL pointer (was Re: BUG #17098: Assert failed on composing an error message when adding a type to an extension being dropped)	Laurenz Albe	05:52
Quick tip on building pg with Visual Studio Build Tools 2019 + small patches 📎	Craig Ringer	06:10
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Julien Rouhaud	06:10
RE: Added schema level support for publication.	[email protected]	06:36
Re: Introduce pg_receivewal gzip compression tests	gkokolatos	06:36
Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors	Yugo NAGATA	06:50
Re: row filtering for logical replication 📎	Peter Smith	06:59
RE: Failed transaction statistics to measure the logical replication progress	[email protected]	06:59
Re: [PATCH] Use optimized single-datum tuplesort in ExecSort 📎	Ronan Dunklau	07:19
Re: Introduce pg_receivewal gzip compression tests	Michael Paquier	07:37
Re: Bogus HAVE_DECL_FOO entries in msvc/Solution.pm	Michael Paquier	07:53
Re: Introduce pg_receivewal gzip compression tests	Michael Paquier	08:14
Re: Introduce pg_receivewal gzip compression tests	gkokolatos	08:22
Re: Introduce pg_receivewal gzip compression tests	gkokolatos	08:28
Re: Added schema level support for publication.	Greg Nancarrow	08:51
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Magnus Hagander	08:58
Remove repeated calls to PQserverVersion 📎	Peter Smith	09:02
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Julien Rouhaud	09:38
RE: [PATCH] Pull general SASL framework out of SCRAM 📎	Mikhail Kulagin	09:41
Re: Keep notnullattrs in RelOptInfo (Was part of UniqueKey patch series)	Andy Fan	09:55
Re: Fix comments of heap_prune_chain() 📎	Masahiro Ikeda	10:05
Re: Parallel scan with SubTransGetTopmostTransaction assert coredump 📎	Maxim Orlov	10:10
Re: Fix comments of heap_prune_chain()	Masahiro Ikeda	10:13
Re: Parallel scan with SubTransGetTopmostTransaction assert coredump	Pavel Borisov	10:23
Re: Introduce pg_receivewal gzip compression tests	Michael Paquier	10:26
Re: DROP relation IF EXISTS Docs and Tests - Bug Fix	Ibrar Ahmed	10:30
Re: [PATCH] Pull general SASL framework out of SCRAM	Michael Paquier	10:31
Re: Remove repeated calls to PQserverVersion	Michael Paquier	10:36
Re: Enhanced error message to include hint messages for redundant options error 📎	Dean Rasheed	10:54
Re: row filtering for logical replication	Amit Kapila	10:57
Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails	Ibrar Ahmed	11:07
Re: Introduce pg_receivewal gzip compression tests	gkokolatos	11:16
Re: a misbehavior of partition row movement (?)	Ibrar Ahmed	11:24
Re: Transactions involving multiple postgres foreign servers, take 2	Ranier Vilela	11:24
Re: POC: GROUP BY optimization	Ibrar Ahmed	11:37
Re: Add proper planner support for ORDER BY / DISTINCT aggregates	Ranier Vilela	11:45
Re: psql \copy from sends a lot of packets	Aleksander Alekseev	11:52
Re: [PATCH] Use optimized single-datum tuplesort in ExecSort	Ranier Vilela	12:05
Re: a misbehavior of partition row movement (?)	Amit Langote	12:09
Re: unnesting multirange data types	Alexander Korotkov	12:11
Re: [PATCH] Use optimized single-datum tuplesort in ExecSort	David Rowley	12:24
Re: [PATCH] Use optimized single-datum tuplesort in ExecSort 📎	Ranier Vilela	12:44
Re: [PATCH] improve the pg_upgrade error message 📎	Jeevan Ladhe	13:27
Re: proposal: possibility to read dumped table's name from file	Stephen Frost	13:40
Re: Replace remaining castNode(…, lfirst(…)) and friends calls with l*_node()	Peter Eisentraut	13:55
Re: Bogus HAVE_DECL_FOO entries in msvc/Solution.pm	Tom Lane	13:58
Re: unnesting multirange data types	Justin Pryzby	14:07
Re: RFC: Logging plan of the running query	Masahiro Ikeda	14:11
Re: unnesting multirange data types	Alexander Korotkov	14:13
Re: Remove repeated calls to PQserverVersion	Tom Lane	14:15
Early Sort/Group resjunk column elimination.	Ronan Dunklau	14:19
Re: Add option --drop-cascade for pg_dump/restore	vignesh C	14:22
Re: unnesting multirange data types	Alvaro Herrera	14:29
Re: printf %s with NULL pointer (was Re: BUG #17098: Assert failed on composing an error message when adding a type to an extension being dropped)	Tom Lane	14:29
Re: Enhanced error message to include hint messages for redundant options error	vignesh C	14:30
Re: Column Filtering in Logical Replication 📎	Rahila Syed	14:43
Re: Detecting File Damage & Inconsistencies	Simon Riggs	14:59
Re: Bogus HAVE_DECL_FOO entries in msvc/Solution.pm	Peter Eisentraut	15:01
Re: Printing backtrace of postgres processes	vignesh C	15:33
Re: PG 14 release notes, first draft	Simon Riggs	15:33
Re: DROP relation IF EXISTS Docs and Tests - Bug Fix	David G. Johnston	15:37
Re: row filtering for logical replication	Jeff Davis	15:44
Re: Add option --drop-cascade for pg_dump/restore	Wu Haotian	15:45
Re: printf %s with NULL pointer (was Re: BUG #17098: Assert failed on composing an error message when adding a type to an extension being dropped) 📎	Tom Lane	15:52
Re: proposal: possibility to read dumped table's name from file	Tomas Vondra	16:14
Re: [PATCH] Use optimized single-datum tuplesort in ExecSort 📎	Ranier Vilela	17:42
Re: [PATCH] Use optimized single-datum tuplesort in ExecSort	Ranier Vilela	17:46
Re: proposal - psql - use pager for \watch command	Tom Lane	17:50
Re: More time spending with "delete pending" 📎	Alexander Lakhin	18:00
Re: printf %s with NULL pointer (was Re: BUG #17098: Assert failed on composing an error message when adding a type to an extension being dropped)	Ranier Vilela	18:04
Re: proposal - psql - use pager for \watch command	Pavel Stehule	18:05
Re: printf %s with NULL pointer (was Re: BUG #17098: Assert failed on composing an error message when adding a type to an extension being dropped)	Tom Lane	18:26
Re: printf %s with NULL pointer (was Re: BUG #17098: Assert failed on composing an error message when adding a type to an extension being dropped)	Ranier Vilela	18:38
Re: row filtering for logical replication	Tomas Vondra	19:07
Re: row filtering for logical replication	Tomas Vondra	19:15
Re: row filtering for logical replication	Alvaro Herrera	19:21
Re: Reducing memory consumption for pending inval messages 📎	Tom Lane	20:21
Re: row filtering for logical replication 📎	Euler Taveira	20:37
Re: row filtering for logical replication	Euler Taveira	20:39
Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails 📎	Tom Lane	20:41
Re: proposal: possibility to read dumped table's name from file	Daniel Gustafsson	20:44
Re: proposal: possibility to read dumped table's name from file	Daniel Gustafsson	20:55
Re: proposal: possibility to read dumped table's name from file	Stephen Frost	20:55
Re: row filtering for logical replication	Euler Taveira	21:02
Re: row filtering for logical replication	Alvaro Herrera	21:06
RE: Transactions involving multiple postgres foreign servers, take 2	[email protected]	21:34
Re: proposal: possibility to read dumped table's name from file	Tomas Vondra	21:57
closing heap relation	Zhihong Yu	22:13
Re: psql - factor out echo code	Tom Lane	22:16
Re: closing heap relation	Zhihong Yu	22:21
Re: proposal: possibility to read dumped table's name from file	Stephen Frost	22:32
Re: [PATCH] Pull general SASL framework out of SCRAM	Jacob Champion	22:41
Re: proposal: possibility to read dumped table's name from file	Alvaro Herrera	23:00
Re: [HACKERS] Preserving param location	Tom Lane	23:01
Re: [PATCH] Pull general SASL framework out of SCRAM	Jacob Champion	23:52
Re: Remove repeated calls to PQserverVersion	Peter Smith	23:57

July 14, 2021

Thread	Author	Time
Re: proposal: possibility to read dumped table's name from file	Stephen Frost	00:18
Re: Remove repeated calls to PQserverVersion	Alvaro Herrera	00:19
Re: enable_resultcache confusion	David Rowley	00:46
Re: row filtering for logical replication	Euler Taveira	00:57
Re: Add proper planner support for ORDER BY / DISTINCT aggregates	David Rowley	01:15
Re: Incorrect usage of strtol, atoi for non-numeric junk inputs 📎	Kyotaro Horiguchi	01:35
Re: [PATCH] Pull general SASL framework out of SCRAM	Michael Paquier	01:42
Re: Add proper planner support for ORDER BY / DISTINCT aggregates	Ranier Vilela	01:45
RE: Partition Check not updated when insert into a partition	[email protected]	02:15
Re: Introduce pg_receivewal gzip compression tests	Michael Paquier	02:17
Re: [Proposal] Global temporary tables	Ming Li	02:56
[PATCH] psql: \dn+ to show size of each schema..	Justin Pryzby	03:07
Re: Detecting File Damage & Inconsistencies	Amit Kapila	04:01
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Peter Eisentraut	04:36
Re: proposal: possibility to read dumped table's name from file	Pavel Stehule	05:00
Re: [PATCH] psql: \dn+ to show size of each schema..	Ian Lawrence Barwick	05:05
Re: [PATCH] improve the pg_upgrade error message	Suraj Kharage	05:27
Re: row filtering for logical replication	Amit Kapila	05:39
Re: [PATCH] psql: \dn+ to show size of each schema..	Laurenz Albe	05:42
[PATCH] document 📎	Ian Lawrence Barwick	05:43
Re: [PATCH] psql: \dn+ to show size of each schema..	Pavel Stehule	05:44
Re: [PATCH] document	Laurenz Albe	05:45
Re: row filtering for logical replication	Amit Kapila	05:46
Re: printf %s with NULL pointer (was Re: BUG #17098: Assert failed on composing an error message when adding a type to an extension being dropped)	Laurenz Albe	05:52
Re: printf %s with NULL pointer (was Re: BUG #17098: Assert failed on composing an error message when adding a type to an extension being dropped)	Peter Eisentraut	06:05
Re: [HACKERS] logical decoding of two-phase transactions	Amit Kapila	06:22
Re: Remove repeated calls to PQserverVersion	Daniel Gustafsson	07:02
Re: [PATCH] document pg_encoding_to_char() and pg_char_to_encoding()	Ian Lawrence Barwick	07:13
Re: Transactions involving multiple postgres foreign servers, take 2	Masahiko Sawada	07:52
Re: psql - factor out echo code 📎	Fabien COELHO	07:57
Re: Skipping logical replication transactions on subscriber side	Masahiko Sawada	08:14
Re: [HACKERS] logical decoding of two-phase transactions 📎	Peter Smith	08:33
Avoid repeated PQfnumber() in pg_dump 📎	[email protected]	08:54
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Magnus Hagander	09:09
Re: row filtering for logical replication	Amit Kapila	09:29
Re: Support kerberos authentication for postgres_fdw 📎	Peifeng Qiu	09:30
Re: row filtering for logical replication	Amit Kapila	09:38
Re: [HACKERS] Preserving param location	Julien Rouhaud	09:46
Re: proposal: possibility to read dumped table's name from file	Tomas Vondra	10:08
Re: psql \copy from sends a lot of packets	Heikki Linnakangas	10:11
Re: [PATCH] Use optimized single-datum tuplesort in ExecSort 📎	David Rowley	10:13
Re: Added schema level support for publication. 📎	vignesh C	10:16
Re: row filtering for logical replication	Tomas Vondra	10:28
Re: Extending amcheck to check toast size and compression	Heikki Linnakangas	10:33
Re: Added schema level support for publication.	vignesh C	10:37
Re: ERROR: "ft1" is of the wrong type.	Michael Paquier	10:55
Re: row filtering for logical replication	Dilip Kumar	11:00
Re: alter table set TABLE ACCESS METHOD	vignesh C	11:01
Re: Columns correlation and adaptive query optimization	vignesh C	11:13
Re: [PATCH] Add extra statistics to explain for Nested Loop	vignesh C	11:16
Re: row filtering for logical replication	Greg Nancarrow	11:21
Re: [PATCH] Automatic HASH and LIST partition creation	Pavel Borisov	11:28
Re: partial heap only tuples	vignesh C	11:34
Re: Write visibility map during CLUSTER/VACUUM FULL	vignesh C	11:46
Re: WIP: System Versioned Temporal Table	vignesh C	11:48
Re: Enhance traceability of wal_level changes for backup management	vignesh C	11:58
Re: pg_rewind race condition just after promotion	Aleksander Alekseev	12:03
Re: Toast compression method options	vignesh C	12:05
Re: [PATCH] Finally split StdRdOptions into HeapOptions and ToastOptions	vignesh C	12:09
SI messages sent when excuting ROLLBACK PREPARED command	[email protected]	12:11
Re: Polyphase merge is obsolete	vignesh C	12:12
Re: ResourceOwner refactoring	vignesh C	12:14
Re: logical replication empty transactions 📎	Ajin Cherian	12:30
Re: 回复：Re: Cache relation sizes?	Anastasia Lubennikova	12:38
Re: row filtering for logical replication	Amit Kapila	12:50
RE: Added schema level support for publication.	[email protected]	12:55
Re: libpq compression 📎	Daniil Zakhlystov	13:01
Re: [PATCH] Hooks at XactCommand level 📎	Gilles Darold	13:48
Re: [PATCH] Partial foreign key updates in referential integrity triggers	Peter Eisentraut	13:51
Re: Toast compression method options	Dilip Kumar	13:57
Re: row filtering for logical replication	Alvaro Herrera	14:01
Re: Unused function parameter in get_qual_from_partbound()	John Naylor	14:06
Re: ResourceOwner refactoring	Alvaro Herrera	14:07
Re: Introduce pg_receivewal gzip compression tests 📎	gkokolatos	14:11

Browse Archives

Prev | Next