pgsql-hackers since 2022-10-27 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

Oct. 27, 2022

Thread	Author	Time
Re: Some regression tests for the pg_control_*() functions	Michael Paquier	01:03
Re: GUC values - recommended way to declare the C variables?	Michael Paquier	02:06
Re: [PoC] Improve dead tuple storage for lazy vacuum	Masahiko Sawada	02:11
Re: GUC values - recommended way to declare the C variables?	Justin Pryzby	02:14
Re: GUC values - recommended way to declare the C variables?	Michael Paquier	02:33
RE: Perform streaming logical transactions by background workers and parallel apply 📎	[email protected]	02:34
Re: generic plans and "initial" pruning 📎	Amit Langote	02:41
Re: GUC values - recommended way to declare the C variables?	Justin Pryzby	02:49
Re: GUC values - recommended way to declare the C variables?	Peter Smith	02:49
Re: Use LIMIT instead of Unique for DISTINCT when all distinct pathkeys are redundant	Richard Guo	02:50
Re: GUC values - recommended way to declare the C variables?	Michael Paquier	02:53
Re: Allow file inclusion in pg_hba and pg_ident files	Michael Paquier	03:08
Re: Allow file inclusion in pg_hba and pg_ident files	Michael Paquier	03:10
Re: [PoC] Improve dead tuple storage for lazy vacuum	John Naylor	03:21
Adding doubly linked list type which stores the number of items in the list 📎	David Rowley	03:35
Re: Allow file inclusion in pg_hba and pg_ident files	Julien Rouhaud	04:26
Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes?	Michael Paquier	05:54
Re: Adding doubly linked list type which stores the number of items in the list	Bharath Rupireddy	06:32
Re: [patch] Have psql's \d+ indicate foreign partitions	Alvaro Herrera	07:12
Re: Simplifying our Trap/Assert infrastructure	Michael Paquier	07:23
Re: GUC values - recommended way to declare the C variables? 📎	Peter Smith	08:00
Re: Documentation for building with meson	John Naylor	08:04
Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes? 📎	Bharath Rupireddy	09:27
Re: Add LSN along with offset to error messages reported for WAL file read/write/validate header failures 📎	Bharath Rupireddy	09:28
Allow single table VACUUM in transaction block 📎	Simon Riggs	09:31
Avoid using list_delete_first in simplify_or/and_arguments	Richard Guo	10:06
Re: Support logical replication of DDLs 📎	vignesh C	10:32
Code checks for App Devs, using new options for transaction behavior 📎	Simon Riggs	11:09
Re: pg_recvlogical prints bogus error when interrupted	Bharath Rupireddy	11:26
[PROPOSAL] : Use of ORDER BY clause in insert.sql 📎	Nishant Sharma	12:51
Re: [PATCHES] Post-special page storage TDE support	Matthias van de Meent	13:17
Re: Reducing duplicativeness of EquivalenceClass-derived clauses	Zhang Mingli	13:21
Re: [PROPOSAL] : Use of ORDER BY clause in insert.sql	Tom Lane	13:24
Re: Reducing duplicativeness of EquivalenceClass-derived clauses	Tom Lane	13:29
Re: Reducing duplicativeness of EquivalenceClass-derived clauses	Zhang Mingli	13:37
Re: Proposal to use JSON for Postgres Parser format	Michel Pelletier	14:38
Improve tab completion for ALTER FUNCTION/PROCEDURE/ROUTINE 📎	vignesh C	15:08
Re: Allow single table VACUUM in transaction block	Simon Riggs	16:18
Re: Allow single table VACUUM in transaction block	Bharath Rupireddy	16:21
Re: Code checks for App Devs, using new options for transaction behavior 📎	Simon Riggs	16:35
heavily contended lwlocks with long wait queues scale badly 📎	Andres Freund	16:59
Re: Reducing planning time on tables with many indexes	Alvaro Herrera	17:13
Re: Allow single table VACUUM in transaction block	Justin Pryzby	20:07
Re: Have nodeSort.c use datum sorts single-value byref types	David Rowley	20:26
Re: Documentation for building with meson	Jacob Champion	21:15
Requiring 32 bit atomics	Thomas Munro	22:42
Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes?	Andres Freund	22:58
Re: Documentation for building with meson	Andres Freund	23:03
Re: pg_recvlogical prints bogus error when interrupted	Andres Freund	23:11
Re: Support logical replication of DDLs	Peter Smith	23:18
Re: Proposal to use JSON for Postgres Parser format	Andres Freund	23:38
Re: Requiring 32 bit atomics	Tom Lane	23:44
Re: Requiring 32 bit atomics	Tom Lane	23:46

Oct. 28, 2022

Thread	Author	Time
Re: Requiring 32 bit atomics	Andres Freund	00:01
Re: Support logical replication of DDLs	Zheng Li	00:20
Re: pg_ls_tmpdir to show directories and shared filesets (and pg_ls_*) 📎	Justin Pryzby	00:38
Re: Support logical replication of DDLs	Peter Smith	00:38
Re: Perform streaming logical transactions by background workers and parallel apply	Masahiko Sawada	00:47
Re: Allow file inclusion in pg_hba and pg_ident files	Michael Paquier	01:24
Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes?	Michael Paquier	02:09
Re: Improve tab completion for ALTER FUNCTION/PROCEDURE/ROUTINE	Dong Wook Lee	02:32
Re: Make mesage at end-of-recovery less scary. 📎	Justin Pryzby	02:37
Merging LatchWaitSet and FeBeWaitSet 📎	Thomas Munro	02:43
Re: GUC values - recommended way to declare the C variables?	Michael Paquier	02:48
Re: GUC values - recommended way to declare the C variables?	Michael Paquier	03:05
Re: pg_recvlogical prints bogus error when interrupted 📎	Bharath Rupireddy	03:11
Re: Allow file inclusion in pg_hba and pg_ident files	Julien Rouhaud	03:49
Re: [PROPOSAL] : Use of ORDER BY clause in insert.sql	Amul Sul	03:50
Latches vs lwlock contention 📎	Thomas Munro	03:56
Re: [PROPOSAL] : Use of ORDER BY clause in insert.sql	David Rowley	04:58
Re: [PROPOSAL] : Use of ORDER BY clause in insert.sql	Tom Lane	05:13
Re: Adding doubly linked list type which stores the number of items in the list 📎	David Rowley	05:31
Re: [PROPOSAL] : Use of ORDER BY clause in insert.sql	Amul Sul	05:53
Re: [PROPOSAL] : Use of ORDER BY clause in insert.sql	Amul Sul	05:53
Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes? 📎	Bharath Rupireddy	06:08
Re: Support logical replication of DDLs	Peter Smith	06:50
psql: Add command to use extended query protocol 📎	Peter Eisentraut	06:52
Re: Code checks for App Devs, using new options for transaction behavior	Erik Rijkers	06:54
Re: GUC values - recommended way to declare the C variables? 📎	Michael Paquier	07:05
Re: psql: Add command to use extended query protocol	Michael Paquier	07:07
Re: Simplifying our Trap/Assert infrastructure	Peter Eisentraut	07:36
Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes?	Michael Paquier	08:00
Re: Code checks for App Devs, using new options for transaction behavior	Simon Riggs	09:33
RE: Perform streaming logical transactions by background workers and parallel apply 📎	[email protected]	09:34
Re: Fast COPY FROM based on batch insert	Etsuro Fujita	10:12
Re: Transparent column encryption	Jehan-Guillaume de Rorthais	10:16
Re: Use LIMIT instead of Unique for DISTINCT when all distinct pathkeys are redundant	David Rowley	10:17
Re: Fast COPY FROM based on batch insert	Andrey Lepikhov	10:53
Re: Improve tab completion for ALTER FUNCTION/PROCEDURE/ROUTINE 📎	vignesh C	12:04
Re: Proposal to use JSON for Postgres Parser format	Andrew Dunstan	13:26
Re: psql: Add command to use extended query protocol	Justin Pryzby	13:27
Re: psql: Add command to use extended query protocol	Tom Lane	13:35
Re: Transparent column encryption	Frédéric Yhuel	14:07
Re: Documentation for building with meson	Jacob Champion	15:43
Re: cross-platform pg_basebackup	Robert Haas	16:07
Re: SUBTRANS: Minimizing calls to SubTransSetParent() 📎	Julien Tachoires	17:24
Segfault on logical replication to partitioned table with foreign children 📎	ilya.v.gladyshev	19:31
Re: Error for WITH options on partitioned tables	David Zhang	21:21
Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes?	Andres Freund	22:07
Re: [PATCHES] Post-special page storage TDE support	David Christensen	22:25
Re: explain_regress, explain(MACHINE), and default to explain(BUFFERS) (was: BUFFERS enabled by default in EXPLAIN (ANALYZE)) 📎	Justin Pryzby	22:59

Oct. 29, 2022

Thread	Author	Time
refactoring relation extension and BufferAlloc(), faster COPY 📎	Andres Freund	02:54
Re: Adding doubly linked list type which stores the number of items in the list	Bharath Rupireddy	05:32
Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes? 📎	Bharath Rupireddy	06:24
Re: Make EXPLAIN generate a generic plan for a parameterized query 📎	Laurenz Albe	08:35
access method xxx does not exist	[email protected]	09:25
Re: Support logical replication of DDLs	Alvaro Herrera	09:30
Fix database creation during installchecks for ICU cluster 📎	Marina Polyakova	09:54
回复: access method xxx does not exist	[email protected]	10:57
Fix order of checking ICU options in initdb and create database 📎	Marina Polyakova	11:33
Re: refactoring relation extension and BufferAlloc(), faster COPY	Bharath Rupireddy	13:03
Re: Fix order of checking ICU options in initdb and create database 📎	Marina Polyakova	13:09
How to started with Contributions	1DS20CS093 Joseph Raj Vishal	15:29
Re: warn if GUC set to an invalid shared library	Justin Pryzby	17:40
Re: refactoring relation extension and BufferAlloc(), faster COPY	Andres Freund	18:39
resowner "cold start" overhead	Andres Freund	20:00

Oct. 30, 2022

Thread	Author	Time
Re: has_wal_read_bug 📎	Noah Misch	03:16
16: Collation versioning and dependency helpers 📎	Jeff Davis	04:41
Re: 16: Collation versioning and dependency helpers	Thomas Munro	06:10
Re: Pulling up direct-correlated ANY_SUBLINK 📎	Andy Fan	07:28
Re: How to started with Contributions	Andy Fan	09:16
Re: Segfault on logical replication to partitioned table with foreign children	Dilip Kumar	09:46
Re: Segfault on logical replication to partitioned table with foreign children	Tom Lane	13:39
Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes? 📎	Alvaro Herrera	14:44
Re: How to started with Contributions	1DS20CS093 Joseph Raj Vishal	14:45
Re: Segfault on logical replication to partitioned table with foreign children	Alvaro Herrera	15:52
pg15 inherited stats expressions: cache lookup failed for statistics object	Justin Pryzby	17:05
Re: Code checks for App Devs, using new options for transaction behavior 📎	Simon Riggs	18:01
Re: Schema variables - new implementation for Postgres 15	Dmitry Dolgov	18:05
Re: Schema variables - new implementation for Postgres 15	Pavel Stehule	18:49
Re: warn if GUC set to an invalid shared library	Maciek Sakrejda	23:12
Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes?	Michael Paquier	23:31

Oct. 31, 2022

Thread	Author	Time
Re: Simplifying our Trap/Assert infrastructure 📎	Michael Paquier	00:04
Re: GUC values - recommended way to declare the C variables?	Peter Smith	01:01
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?)	Maciek Sakrejda	01:08
Re: resowner "cold start" overhead	Kyotaro Horiguchi	02:28
Lock on ShmemVariableCache fields?	Japin Li	02:48
Re: Adding doubly linked list type which stores the number of items in the list 📎	David Rowley	02:56
RE: Segfault on logical replication to partitioned table with foreign children	[email protected]	03:20
Re: Documentation for building with meson 📎	samay sharma	03:51
Prefetch the next tuple's memory during seqscans 📎	David Rowley	03:52
Re: pg15 inherited stats expressions: cache lookup failed for statistics object	Richard Guo	04:26
Re: GUC values - recommended way to declare the C variables?	Michael Paquier	05:02
Re: pg15 inherited stats expressions: cache lookup failed for statistics object 📎	Richard Guo	05:12
Re: heavily contended lwlocks with long wait queues scale badly	Kyotaro Horiguchi	05:32
Re: pg15 inherited stats expressions: cache lookup failed for statistics object	Michael Paquier	05:33
Limit of WAL LSN value of type pg_lsn	Shubham Shingne	05:33
Commit fest 2022-11	Michael Paquier	05:42
Re: [PoC] Improve dead tuple storage for lazy vacuum 📎	Masahiko Sawada	05:46
RE: [PATCH] Support % wildcard in extension upgrade filenames	Regina Obe	05:55
Re: Adding doubly linked list type which stores the number of items in the list	Bharath Rupireddy	06:05
Re: Lock on ShmemVariableCache fields?	Zhang Mingli	06:15
Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes?	Bharath Rupireddy	06:20
Re: GUC values - recommended way to declare the C variables?	Peter Smith	06:21
Re: Adding doubly linked list type which stores the number of items in the list	David Rowley	07:14
Re: Lock on ShmemVariableCache fields?	Japin Li	07:14
Re: Support logical replication of DDLs	Peter Smith	08:07
Check return value of pclose() correctly 📎	Peter Eisentraut	08:12
Re: heavily contended lwlocks with long wait queues scale badly	Dilip Kumar	08:41
Re: Expand palloc/pg_malloc API 📎	Peter Eisentraut	08:47
Re: Segfault on logical replication to partitioned table with foreign children	Dilip Kumar	08:48
Re: Fast COPY FROM based on batch insert	Etsuro Fujita	08:50
Re: Simplifying our Trap/Assert infrastructure 📎	Peter Eisentraut	09:02
Error for row-level triggers with transition tables on partitioned tables 📎	Etsuro Fujita	09:27
Re: ResourceOwner refactoring 📎	Heikki Linnakangas	09:51
Re: resowner "cold start" overhead	Heikki Linnakangas	10:05
Re: [PATCH] minor optimization for ineq_histogram_selectivity()	Frédéric Yhuel	10:30
Lockless queue of waiters in LWLock 📎	Pavel Borisov	10:38
Re: Perform streaming logical transactions by background workers and parallel apply	Amit Kapila	10:44
Re: Support logical replication of DDLs	vignesh C	10:47
Re: heavily contended lwlocks with long wait queues scale badly	Bharath Rupireddy	10:51
Re: Code checks for App Devs, using new options for transaction behavior	Dilip Kumar	10:53
Commitfest documentation	Jehan-Guillaume de Rorthais	10:59
Re: Lockless queue of waiters in LWLock 📎	Pavel Borisov	11:00
Re: heavily contended lwlocks with long wait queues scale badly	Pavel Borisov	11:09
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock	Amit Kapila	11:26
Re: Code checks for App Devs, using new options for transaction behavior	Dilip Kumar	11:33
Re: Tracking last scan time	Dave Page	11:36
Re: [patch] Have psql's \d+ indicate foreign partitions	Ian Lawrence Barwick	12:13
Re: Code checks for App Devs, using new options for transaction behavior	Dilip Kumar	12:22
Re: Adding doubly linked list type which stores the number of items in the list	Bharath Rupireddy	12:22
Re: heavily contended lwlocks with long wait queues scale badly	Alexander Korotkov	12:38
Re: Code checks for App Devs, using new options for transaction behavior	Simon Riggs	12:43
Re: Proposal to use JSON for Postgres Parser format	Alexander Korotkov	12:45
Re: ResourceOwner refactoring	Aleksander Alekseev	12:49
Re: Limit of WAL LSN value of type pg_lsn	Ashutosh Bapat	12:55
Re: Simplifying our Trap/Assert infrastructure	Tom Lane	13:14
Split index and table statistics into different types of stats 📎	Drouvot, Bertrand	13:14
Re: Proposal to use JSON for Postgres Parser format	Matthias van de Meent	13:15
Re: Segfault on logical replication to partitioned table with foreign children	ilya.v.gladyshev	13:15
Re: shared memory stats ideas	Drouvot, Bertrand	13:20
Re: Code checks for App Devs, using new options for transaction behavior 📎	Simon Riggs	13:24
Re: Adding doubly linked list type which stores the number of items in the list	Aleksander Alekseev	13:28
Re: warn if GUC set to an invalid shared library	Justin Pryzby	13:31
Re: doc: Fix description of how the default user name is chosen	Peter Eisentraut	13:41
Re: warn if GUC set to an invalid shared library	Tom Lane	13:43
Re: Commitfest documentation 📎	Aleksander Alekseev	13:51
Re: WIN32 pg_import_system_collations	Peter Eisentraut	14:09
Re: Prefetch the next tuple's memory during seqscans	Aleksander Alekseev	14:12
Re: Proposal to use JSON for Postgres Parser format	Michel Pelletier	14:55

Browse Archives

Prev | Next