pgsql-hackers
Thread
Date
Earlier messages
Later messages
Messages by Date
2026/10/19
Re: Proposal: Conflict log history table for Logical Replication
shveta malik
2026/10/19
Re: [DEPARSE] Pretty-printed sublink test expressions lose needed parentheses
Tom Lane
2026/10/19
Re: Publication of same parent table with ONLY-ness mismatch should error
Peter Smith
2026/10/19
Re: regress: query discrepancy between explain vs execution
David Rowley
2026/10/19
Re: query_int wrongly parses zero-padded input
Marko Grujic
2026/10/19
Re: DOCS - CREATE PUBLICATION wording re 'ONLY' for partitioned tables.
Peter Smith
2026/10/19
Re: [PATCH] Add support for INSERT ... SET syntax
Mario González
2026/10/19
Re: [PG19] Promotion hangs behind a backend blocked on a stuck client
Masahiko Sawada
2026/10/19
Re: [PATCH] initdb: map Windows' new Canadian time zone names
Tom Lane
2026/10/19
Re: Expanding HOT updates for expression and partial indexes
Matthias van de Meent
2026/10/19
Re: Be strict when request to flush past end of WAL in WaitXLogInsertionsToFinish
Bharath Rupireddy
2026/10/19
Re: Hash a ScalarArrayOpExpr whose array is fixed for one execution
best xmg
2026/10/19
Re: Show expression of virtual columns in error messages
Matheus Alcantara
2026/10/19
Re: Show expression of virtual columns in error messages
Matheus Alcantara
2026/10/19
Re: HashAggregate loses worker spill stats on rescan
Osama Abdul Qader
2026/10/19
Re: Fix WITHOUT OVERLAPS multirange with location replication
kedar anavardekar
2026/10/19
Re: [PATCH] initdb: map Windows' new Canadian time zone names
David Rowley
2026/10/19
Re: regress: query discrepancy between explain vs execution
Matthias van de Meent
2026/10/19
Add compiler option -fstrict-flex-arrays=1
Peter Eisentraut
2026/10/19
Re: "variable not found in subplan target lists" with partitionwise join
wenhui qiu
2026/10/19
Re: ALTER COLUMN SET NOT NULL differ from ALTER TABLE ADD CONSTRAINT
Osama Abdul Qader
2026/10/19
Re: query_int wrongly parses zero-padded input
Chao Li
2026/10/19
Re: tablecmds: Deadlock caused by Attach Partition
surya poondla
2026/10/19
Re: [PATCH] Remove useless ORDER BY from scalar subqueries
David Geier
2026/10/19
Re: Possible race condition in pg_basebackup
Raja Sai pranav
2026/10/19
Re: Proposal: Conflict log history table for Logical Replication
Masahiko Sawada
2026/10/19
Re: [PATCH] initdb: map Windows' new Canadian time zone names
Tom Lane
2026/10/19
Allow a promotion request to supply the new timeline ID
Andrey Borodin
2026/10/19
Re: Allow table AMs to define their own reloptions
Andrew Dunstan
2026/10/19
Re: COALESCE patch
Ilia Evdokimov
2026/10/19
Re: postgres_fdw: transaction mode inheritance corner cases
Matheus Alcantara
2026/10/19
[PATCH] initdb: map Windows' new Canadian time zone names
CyberNative AI
2026/10/19
Re: pg_get_*_ddl() needs a redesign
Mario González
2026/10/19
Re: pull-up subquery if JOIN-ON contains refs to upper-query
Ilia Evdokimov
2026/10/19
Re: [DEPARSE] Pretty-printed sublink test expressions lose needed parentheses
Henson Choi
2026/10/19
Re: Improving scalability of Parallel Bitmap Heap/Index Scan
David Geier
2026/10/19
Re: Add compiler option -fstrict-flex-arrays=1
Peter Eisentraut
2026/10/19
Re: [DEPARSE] An alias named 'set' on an UPDATE, DELETE or MERGE target does not read back
Henson Choi
2026/10/19
Re: Improve Hash/Merge Join estimate accuracy when all predicates are Hash/Merge clauses
Ilia Evdokimov
2026/10/19
ALTER COLUMN SET NOT NULL differ from ALTER TABLE ADD CONSTRAINT
jian he
2026/10/19
Re: Add compiler option -fstrict-flex-arrays=1
David Geier
2026/10/19
Re: Row pattern recognition
Henson Choi
2026/10/19
Re: RFC: Logging plan of the running query
torikoshia
2026/10/19
Re: Fold NOT IN / <> ALL expressions containing NULL to FALSE
Ilia Evdokimov
2026/10/19
Re: Allow table AMs to define their own reloptions
Andrew Dunstan
2026/10/19
Re: fix more casting away of qualifiers
Tom Lane
2026/10/19
Re: Historic snapshot doesn't track txns committed inBUILDING_SNAPSHOT state
Zhijie Hou
2026/10/19
Re: fix more casting away of qualifiers
Andres Freund
2026/10/19
Re: DOCS - CREATE PUBLICATION wording re 'ONLY' for partitioned tables.
shveta malik
2026/10/19
Re: [PATCH v1] Generic Datum Encoding and Compression Contexts (pg_encoding_type, pg_encoding_context)
Osama Abdul Qader
2026/10/19
Re: Parallel Apply
Manu
2026/10/19
Re: Reducing relcache memory usage 2: shrink sizeof(RelationData)
David Geier
2026/10/19
Re: Reducing relcache memory usage 2: shrink sizeof(RelationData)
Matthias van de Meent
2026/10/19
Re: Reducing relcache memory usage 2: shrink sizeof(RelationData)
David Geier
2026/10/19
Re: PROXY protocol support
Peter Eisentraut
2026/10/19
Re: postgres_fdw: transaction mode inheritance corner cases
Etsuro Fujita
2026/10/19
Re: query_int wrongly parses zero-padded input
Marko Grujic
2026/10/19
Re: Add returns_nonnull to infallible allocators
Peter Eisentraut
2026/10/19
Re: DOCS - CREATE PUBLICATION wording re 'ONLY' for partitioned tables.
Chao Li
2026/10/19
Re: walreceiver: stale hot_standby_feedback xmin on primary when wal_receiver_status_interval = 0 (PG16 and later)
Vaibhav Dalvi
2026/10/19
Re: Fix stale allocChunkLimit when recycling AllocSet
Chao Li
2026/10/19
Re: Use C11 alignas instead of palloc/malloc for alignment
Peter Eisentraut
2026/10/19
Re: [PG19] Three bugs with a CHECK constraint that only the child enforces
jian he
2026/10/19
Re: fix more casting away of qualifiers
Peter Eisentraut
2026/10/19
Re: Publication of same parent table with ONLY-ness mismatch should error
shveta malik
2026/10/19
Re: Publication of same parent table with ONLY-ness mismatch should error
Peter Smith
2026/10/19
Re: Stabilize and shorten test_checksums/013_rewind test
Alexander Lakhin
2026/10/18
DOCS - CREATE PUBLICATION wording re 'ONLY' for partitioned tables.
Peter Smith
2026/10/18
"variable not found in subplan target lists" with partitionwise join
Richard Guo
2026/10/18
Re: Fix stale allocChunkLimit when recycling AllocSet
David Rowley
2026/10/18
Re: Fix stale allocChunkLimit when recycling AllocSet
Chao Li
2026/10/18
Re: pgstat: don't assert on dropped entries when writing stats file
Michael Paquier
2026/10/18
Re: [PATCH v1] Fix tab completion for DROP INDEX CONCURRENTLY
Chao Li
2026/10/18
[PATCH] Fix leaked hash scans in pg_listening_channels()
Joel Jacobson
2026/10/18
Re: query_int wrongly parses zero-padded input
Chao Li
2026/10/18
Re: [PATCH v1] Batch B-tree TIDs when building a bitmap
John Naylor
2026/10/18
Re: pgstat: allow a stats kind to use its own dedicated dsa/dshash
Alexander Lakhin
2026/10/18
Re: walreceiver: stale hot_standby_feedback xmin on primary when wal_receiver_status_interval = 0 (PG16 and later)
Vaibhav Dalvi
2026/10/18
Re: [PATCH] Corruption Issue: Fix missing tts_tid in ExecForceStoreHeapTuple
shihao zhong
2026/10/18
Re: [PATCH v1] Fix tab completion for DROP INDEX CONCURRENTLY
Fujii Masao
2026/10/18
Re: Proposal: Conflict log history table for Logical Replication
shveta malik
2026/10/18
Re: Reduce logging during prepared transaction recovery
Fujii Masao
2026/10/18
[PATCH v1] Fix tab completion for DROP INDEX CONCURRENTLY
Sho Ito
2026/10/18
Re: Fix WITHOUT OVERLAPS multirange with location replication
Zhijie Hou
2026/10/18
Re: Assert failure in create_lateral_join_info
Richard Guo
2026/10/18
Re: [PG19] ILIKE index scan misses rows with a libc UTF-8 collation on macOS
Chao Li
2026/10/18
Re: pg_xmin_horizon: a system view of everything pinning the xmin horizon
Scott Ray
2026/10/18
[PG19] Hash join writes null-keyed outer rows to temp files
shihao zhong
2026/10/18
Re: [PG19] ILIKE index scan misses rows with a libc UTF-8 collation on macOS
Fujii Masao
2026/10/18
Re: Row pattern recognition
Tatsuo Ishii
2026/10/18
Re: [PG19] Promotion hangs behind a backend blocked on a stuck client
shihao zhong
2026/10/18
Re: regress: query discrepancy between explain vs execution
David Rowley
2026/10/18
Re: First draft of PG 19 release notes
shihao zhong
2026/10/18
Re: [PG19] pg_dump --statistics restores extended statistics by attribute number
shihao zhong
2026/10/18
Re: [PG19] pg_dump --statistics restores extended statistics by attribute number
Michael Paquier
2026/10/18
Re: Revert libpq servicefile connection option in v19 (info leak and uninterruptible backend DoS)
Michael Paquier
2026/10/18
Re: PSQL schema "describe" \dn is not escaping quotes
Peter Smith
2026/10/18
Re: Include schema-qualified names in publication error messages (generalised to all of LR).
Peter Smith
2026/10/18
Re: pgstat: allow a stats kind to use its own dedicated dsa/dshash
Michael Paquier
2026/10/18
Re: [PATCH] Remove useless ORDER BY from scalar subqueries
Iliia Khaprov
2026/10/18
Re: [PATCH] Remove useless ORDER BY from scalar subqueries
Tom Lane
2026/10/18
Re: [PATCH] Remove useless ORDER BY from scalar subqueries
Iliia Khaprov
2026/10/18
[PATCH] Remove useless ORDER BY from scalar subqueries
Iliia Khaprov
2026/10/18
Re: XMLSerialize: version and explicit XML declaration
Jim Jones
2026/10/18
HashAggregate loses worker spill stats on rescan
Ayush Tiwari
2026/10/18
Re: ILIKE '%' never matches a non-ASCII byte in single-byte C-ctype databases
Manu
2026/10/18
Re: BUG #19686: Rolling back SET TABLESPACE
Manu
2026/10/18
Re: [DEPARSE] An alias named 'set' on an UPDATE, DELETE or MERGE target does not read back
Tom Lane
2026/10/18
Re: [DEPARSE] Pretty-printed sublink test expressions lose needed parentheses
Tom Lane
2026/10/18
ILIKE '%' never matches a non-ASCII byte in single-byte C-ctype databases
Greg Burd
2026/10/18
Reject access to unlogged tables in contrib modules
Jim Jones
2026/10/18
Re: Reject COPY TO of unlogged relations during recovery
Jim Jones
2026/10/18
Re: index prefetching
Peter Geoghegan
2026/10/18
Re: [PATCH v1] Batch B-tree TIDs when building a bitmap
Peter Geoghegan
2026/10/18
Re: Improve read_local_xlog_page_guts by replacing polling with latch-based waiting
Xuneng Zhou
2026/10/18
Re: Reducing relcache memory usage 2: shrink sizeof(RelationData)
David Geier
2026/10/18
Re: psql single-step mode woes
Rui Zhao
2026/10/18
Re: [DEPARSE] Pretty-printed sublink test expressions lose needed parentheses
Sho Ito
2026/10/18
[PATCH] Fix plpgsql's R/W optimization for simple expressions run via SPI
Muzzammil Sarwar
2026/10/18
Re: [PATCH] Fix recovery connection detail in EXEC_BACKEND builds
Nitin Jadhav
2026/10/18
Re: pgstat: allow a stats kind to use its own dedicated dsa/dshash
Alexander Lakhin
2026/10/17
Re: pgstat: allow a stats kind to use its own dedicated dsa/dshash
Michael Paquier
2026/10/17
Re: PG19: flat-copied RelOptInfos share extension_state with the original rel
Shubhankar Anand Kulkarni
2026/10/17
Re: json/jsonb cleanup + FmgrInfo caching
Manu
2026/10/17
Re: [PG19] Bugs found comparing 19 with 18, list before I open threads
shihao zhong
2026/10/17
Re: BUG #19686: Rolling back SET TABLESPACE
shihao zhong
2026/10/17
[PG19] A canceled notify read leaves the NOTIFY queue stuck
shihao zhong
2026/10/17
Re: Improving scalability of Parallel Bitmap Heap/Index Scan
shihao zhong
2026/10/17
[PG19] ILIKE index scan misses rows with a libc UTF-8 collation on macOS
shihao zhong
2026/10/17
Re: Wrong results from a parameterized Append
shihao zhong
2026/10/17
Re: json/jsonb cleanup + FmgrInfo caching
shihao zhong
2026/10/17
Re: query_int wrongly parses zero-padded input
Manu
2026/10/17
Re: pgstat: allow a stats kind to use its own dedicated dsa/dshash
Sami Imseih
2026/10/17
Re: query_int wrongly parses zero-padded input
Tom Lane
2026/10/17
Re: query_int wrongly parses zero-padded input
Tom Lane
2026/10/17
Re: query_int wrongly parses zero-padded input
Manu
2026/10/17
Re: query_int wrongly parses zero-padded input
Manu
2026/10/17
Re: UNDO with FILEOPS, and the FLUX table AM
Manu
2026/10/17
Re: pgstat: allow a stats kind to use its own dedicated dsa/dshash
Tom Lane
2026/10/17
Re: query_int wrongly parses zero-padded input
Tom Lane
2026/10/17
Re: [PATCH] Extensible ReadyForQuery wire protocol message and C hook, for connection pools and WAIT FOR LSN
Manu
2026/10/17
Re: Possible race condition in pg_basebackup
Raja Sai pranav
2026/10/17
query_int wrongly parses zero-padded input
Marko Grujic
2026/10/17
Re: ZSTD TOAST compression, and an extensible compression method encoding
Manu
2026/10/17
Re: Parallel vacuum: check XID wraparound failsafe between indexes
Sami Imseih
2026/10/17
Re: ANSI SQL proposal: SELECT DISTINCT ON (... ORDER BY ...) and UNION DISTINCT ON (... ORDER BY ...)
Manu
2026/10/17
Re: Add Dockerfile for OSS Scanner
Andres Freund
2026/10/17
Re: Add Dockerfile for OSS Scanner
Sehrope Sarkuni
2026/10/17
Re: Add Dockerfile for OSS Scanner
Noah Misch
2026/10/17
Re: Add Dockerfile for OSS Scanner
Noah Misch
2026/10/17
Re: Add Dockerfile for OSS Scanner
Ayush Tiwari
2026/10/17
Re: [PG19] Sequence sync stops when the subscription owner can't SET ROLE to a sequence owner
Zhijie Hou
2026/10/17
Bug in multi-level nbtree page deletion
Peter Geoghegan
2026/10/17
Re: Add Dockerfile for OSS Scanner
Ayush Tiwari
2026/10/17
Re: Add Dockerfile for OSS Scanner
Noah Misch
2026/10/17
Re: Assert failure in create_lateral_join_info
Ayush Tiwari
2026/10/17
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows
harrisontbooth
2026/10/17
Re: Add Dockerfile for OSS Scanner
Sehrope Sarkuni
2026/10/17
Re: Reduce logging during prepared transaction recovery
Pierre Forstmann
2026/10/17
Re: [PATCH] Add immediate_global_insert_visibility GUC for immediate frozen inserts
Osama Abdul Qader
2026/10/17
[PATCH] Add immediate_global_insert_visibility GUC for immediate frozen inserts
Hannu Krosing
2026/10/17
An intro about myself and an important notification
Osama Abdul Qader
2026/10/17
Re: Assert failure in standard_join_search()
Richard Guo
2026/10/17
Re: Bug in logical decoding with DDL and subtransactions
Manu
2026/10/17
Re: pg_upgrade stores an invalid datminmxid/relminmxid when the old cluster's newest multixact is 0xFFFFFFFF
Manu
2026/10/17
Re: [PG19] Promotion hangs behind a backend blocked on a stuck client
Manu
2026/10/17
Re: Internal error codes triggered by regression tests and user queries, take 2
Alexander Lakhin
2026/10/17
Re: Reject COPY TO of unlogged relations during recovery
Jim Jones
2026/10/17
Re: regress: query discrepancy between explain vs execution
Pierre Forstmann
2026/10/17
Re: pg_upgrade stores an invalid datminmxid/relminmxid when the old cluster's newest multixact is 0xFFFFFFFF
Zsolt Parragi
2026/10/17
Re: [PG19] Eager aggregation runs a volatile join clause once per group
Manu
2026/10/17
pg_upgrade stores an invalid datminmxid/relminmxid when the old cluster's newest multixact is 0xFFFFFFFF
Manu
2026/10/17
Re: PG19: flat-copied RelOptInfos share extension_state with the original rel
Sho Ito
2026/10/16
Re: Bug in logical decoding with DDL and subtransactions
Ayush Tiwari
2026/10/16
[PG19] CREATE SCHEMA puts an index or trigger on a same-named temp table
shihao zhong
2026/10/16
Re: First draft of PG 19 release notes
shihao zhong
2026/10/16
Re: First draft of PG 19 release notes
shihao zhong
2026/10/16
Re: [PG19] Wrong results from NOT NULL-based expression simplification
shihao zhong
2026/10/16
Re: First draft of PG 19 release notes
Tom Lane
2026/10/16
Re: First draft of PG 19 release notes
shihao zhong
2026/10/16
Re: [PG19] Wrong results from NOT NULL-based expression simplification
Manu
2026/10/16
Re: [PG19] psql backslash commands fail with translated messages and a non UTF-8 client encoding
shihao zhong
2026/10/16
Re: [PG19] Three bugs with a CHECK constraint that only the child enforces
shihao zhong
2026/10/16
Re: [PG19] Indexes from 18 miss rows after pg_upgrade
shihao zhong
2026/10/16
Re: [PATCH] Fix grouping-set nulling of variable-free grouping expressions
shihao zhong
2026/10/16
Add Dockerfile for OSS Scanner
Noah Misch
2026/10/16
Re: Row pattern recognition
jian he
2026/10/16
Re: Fix doc: explanation of how postgres works when OOM killer is invoked
C W
2026/10/16
Re: Fix doc: explanation of how postgres works when OOM killer is invoked
Takeshi Ideriha
2026/10/16
Re: [PG19] Indexes from 18 miss rows after pg_upgrade
Jeff Davis
2026/10/16
Re: ERROR: failed to apply nullingrels to a non-Var
Richard Guo
2026/10/16
Re: Two more RI fast-path issues
Amit Langote
2026/10/16
Re: Fix stale allocChunkLimit when recycling AllocSet
Donghang Lin
2026/10/16
Re: [PG19] Promotion hangs behind a backend blocked on a stuck client
Masahiko Sawada
2026/10/16
Re: Reducing relcache memory usage 2: shrink sizeof(RelationData)
Haibo Yan
2026/10/16
Re: Use instr_time for pg_stat_database block read/write time counters
Bernd Reiß
2026/10/16
Re: postgres_fdw: transaction mode inheritance corner cases
Matheus Alcantara
2026/10/16
Re: Use WALReadFromBuffers in more places
Bharath Rupireddy
2026/10/16
Re: [PATCH] Doc fix for autovacuum_max_parallel_workers
Fujii Masao
2026/10/16
Re: Add a hook for handling logical decoding messages on subscribers.
Bharath Rupireddy
Earlier messages
Later messages