pgsql-hackers since 2021-03-15 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 15, 2021

Thread	Author	Time
Re: REINDEX backend filtering	Mark Dilger	00:01
Re: A qsort template	Thomas Munro	00:09
Re: Different compression methods for FPI 📎	Justin Pryzby	00:31
Re: REINDEX backend filtering	Julien Rouhaud	00:35
Re: Postgres crashes at memcopy() after upgrade to PG 13.	Thomas Munro	00:39
Re: REINDEX backend filtering	Julien Rouhaud	00:46
Re: Postgres crashes at memcopy() after upgrade to PG 13.	Avinash Kumar	01:01
Re: Postgres crashes at memcopy() after upgrade to PG 13.	Avinash Kumar	01:05
Re: Different compression methods for FPI 📎	Justin Pryzby	01:12
Re: Postgres crashes at memcopy() after upgrade to PG 13.	Thomas Munro	01:16
Re: Collation versioning	Thomas Munro	01:25
Re: About to add WAL write/fsync statistics to pg_stat_wal view 📎	Masahiro Ikeda	01:39
Re: About to add WAL write/fsync statistics to pg_stat_wal view	Masahiro Ikeda	01:54
Re: Postgres crashes at memcopy() after upgrade to PG 13.	Avinash Kumar	01:54
Re: cleanup temporary files after crash	Thomas Munro	02:01
Re: New IndexAM API controlling index vacuum strategies 📎	Peter Geoghegan	02:04
Re: Postgres crashes at memcopy() after upgrade to PG 13.	Peter Geoghegan	02:23
Re: Change JOIN tutorial to focus more on explicit joins	Thomas Munro	02:47
Re: [HACKERS] logical decoding of two-phase transactions	Amit Kapila	03:03
Re: recovering from "found xmin ... from before relfrozenxid ..."	Peter Geoghegan	03:17
Re: A new function to wait for the backend exit after termination 📎	Bharath Rupireddy	03:27
Re: EXPLAIN/EXPLAIN ANALYZE REFRESH MATERIALIZED VIEW	Bharath Rupireddy	03:32
Re: REINDEX backend filtering 📎	Julien Rouhaud	03:33
Re: pl/pgsql feature request: shorthand for argument and local variable references	Julien Rouhaud	03:54
Regression tests vs SERIALIZABLE 📎	Thomas Munro	04:24
Re: Change JOIN tutorial to focus more on explicit joins	Pavel Stehule	04:28
Re: pl/pgsql feature request: shorthand for argument and local variable references	Pavel Stehule	04:31
Re: Improvements and additions to COPY progress reporting 📎	Michael Paquier	04:53
Re: Extensions not dumped when --schema is used	Michael Paquier	05:00
Re: Procedures versus the "fastpath" API	Michael Paquier	05:07
Re: A new function to wait for the backend exit after termination	Fujii Masao	05:08
Re: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW	Thomas Munro	05:08
Re: Regression tests vs SERIALIZABLE	Bharath Rupireddy	05:14
Re: Regression tests vs SERIALIZABLE 📎	Thomas Munro	05:33
Re: Should we improve "PID XXXX is not a PostgreSQL server process" warning for pg_terminate_backend(<<postmaster_pid>>)?	torikoshia	05:53
Re: Parallel INSERT (INTO ... SELECT ...) 📎	Amit Kapila	05:55
Re: PITR promote bug: Checkpointer writes to older timeline	Kyotaro Horiguchi	06:01
Re: Parallel INSERT (INTO ... SELECT ...)	Justin Pryzby	06:04
Re: SQL-standard function body	Jaime Casanova	06:05
Re: PATCH: Attempt to make dbsize a bit more consistent	Michael Paquier	06:10
Re: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW	Amit Kapila	06:28
Re: Parallel INSERT (INTO ... SELECT ...)	Amit Kapila	06:32
Re: Regression tests vs SERIALIZABLE	Bharath Rupireddy	06:59
Re: Add some tests for pg_stat_statements compatibility verification under contrib 📎	Erica Zhang	07:05
Re: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW	Bharath Rupireddy	07:25
Re: [Patch] ALTER SYSTEM READ ONLY 📎	Amul Sul	07:25
Re: PITR promote bug: Checkpointer writes to older timeline	Michael Paquier	07:38
row level security (RLS)	Rafal Pietrak	07:57
Re: SQL-standard function body	Julien Rouhaud	08:03
Re: Change JOIN tutorial to focus more on explicit joins 📎	Jürgen Purtz	08:06
Re: SQL-standard function body	Julien Rouhaud	08:14
Re: Extensions not dumped when --schema is used	Guillaume Lelarge	08:19
Re: shared-memory based stats collector	Kyotaro Horiguchi	08:46
Re: shared-memory based stats collector	Kyotaro Horiguchi	08:49
Re: shared-memory based stats collector	Kyotaro Horiguchi	08:51
Re: [HACKERS] logical decoding of two-phase transactions	Peter Smith	09:18
RE: Parallel INSERT (INTO ... SELECT ...)	[email protected]	09:35
Re: Tying an object's ownership to datdba 📎	Noah Misch	09:41
Re: Extensions not dumped when --schema is used	Julien Rouhaud	10:21
Re: Extensions not dumped when --schema is used	Michael Paquier	10:25
Re: Extensions not dumped when --schema is used	Julien Rouhaud	10:31
Re: Regression tests vs SERIALIZABLE	Thomas Munro	10:35
Re: Extensions not dumped when --schema is used	Guillaume Lelarge	10:37
Re: Regression tests vs SERIALIZABLE 📎	Thomas Munro	10:51
Re: Hybrid Hash/Nested Loop joins and caching results from subplans 📎	David Rowley	10:57
RE: libpq debug log 📎	[email protected]	11:26
Re: Improvements and additions to COPY progress reporting	Matthias van de Meent	11:43
Re: [HACKERS] Custom compression methods 📎	Dilip Kumar	12:14
Re: [Patch] ALTER SYSTEM READ ONLY 📎	Amul Sul	12:15
Re: PATCH: Attempt to make dbsize a bit more consistent 📎	gkokolatos	12:18
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch	David Steele	12:18
Re: jsonpath syntax extensions	David Steele	12:25
subscriptionCheck failures	Thomas Munro	12:29
Re: Strange behavior with polygon and NaN	David Steele	12:34
Re: [HACKERS] logical decoding of two-phase transactions 📎	Ajin Cherian	12:44
Re: pg_ls_tmpdir to show directories and shared filesets (and pg_ls_*)	David Steele	12:47
Re: Detecting File Damage & Inconsistencies	David Steele	13:01
Re: allow partial union-all and improve parallel subquery costing	David Steele	13:09
RE: Enhance traceability of wal_level changes for backup management	[email protected]	13:14
Re: Postgres crashes at memcopy() after upgrade to PG 13.	Avinash Kumar	13:56
Re: dynamic result sets support in extended query protocol	David Steele	13:56
Re: documentation fix for SET ROLE	Laurenz Albe	14:05
Re: 2019-03 CF now in progress	David Steele	14:24
Re: Regression tests vs SERIALIZABLE	Tom Lane	14:28
Re: fdatasync performance problem with large number of DB files	Paul Guo	14:30
Re: Freeze the inserted tuples during CTAS?	Paul Guo	14:33
Re: locking [user] catalog tables vs 2pc vs logical rep 📎	vignesh C	14:35
Calendar support in localization	Surafel Temesgen	14:47
Re: [PATCH] Improve amcheck to also check UNIQUE constraint in btree index.	Mark Dilger	15:11
Fwd: row level security (RLS)	Rafal Pietrak	15:28
Re: [HACKERS] GSoC 2017: Foreign Key Arrays 📎	Mark Rofail	15:29
Re: MultiXact\SLRU buffers configuration	Gilles Darold	15:41
Re: Improve join selectivity estimation using extended statistics	Konstantin Knizhnik	15:41
Re: Parser Hook 📎	Jim Mlodgenski	15:48
Re: Proposal: Save user's original authenticated identity for logging 📎	Jacob Champion	15:50
Re: Postgres crashes at memcopy() after upgrade to PG 13.	Peter Geoghegan	16:18
Re: Confusing behavior of psql's \e 📎	Laurenz Albe	16:26
Re: REINDEX backend filtering	Mark Dilger	16:30
Re: archive status ".ready" files may be created too early 📎	Bossart, Nathan	16:34
[BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns 📎	Oh, Mike	16:34
Re: Parser Hook	Julien Rouhaud	16:43
Re: Key management with tests 📎	Bruce Momjian	16:50
Re: REINDEX backend filtering	Julien Rouhaud	16:52
Re: Parser Hook	Joel Jacobson	16:58
Re: Fwd: row level security (RLS)	Laurenz Albe	17:01
Re: Parser Hook	Jim Mlodgenski	17:02
Re: pg_amcheck contrib application	Tom Lane	17:04
Re: Parser Hook	Jim Mlodgenski	17:05
Re: Parser Hook	Pavel Stehule	17:05
Re: documentation fix for SET ROLE	Bossart, Nathan	17:09
Re: REINDEX backend filtering	Mark Dilger	17:13
Re: Parser Hook	Julien Rouhaud	17:18
Re: REINDEX backend filtering	Julien Rouhaud	17:34
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch	Tom Lane	17:35
Re: REINDEX backend filtering	Mark Dilger	17:40
Re: Parser Hook	Pavel Stehule	17:41
Re: REINDEX backend filtering	Julien Rouhaud	17:50
Re: Parser Hook	Julien Rouhaud	17:54
Re: REINDEX backend filtering	Mark Dilger	17:56
Re: Parser Hook	Pavel Stehule	18:02
Re: Different compression methods for FPI 📎	Justin Pryzby	18:09
Re: REINDEX backend filtering	Julien Rouhaud	18:10
Re: pg_amcheck contrib application	Mark Dilger	18:11
Type of wait events WalReceiverWaitStart and WalSenderWaitForWAL	Fujii Masao	18:12
Re: Postgres crashes at memcopy() after upgrade to PG 13.	Avinash Kumar	18:21
Re: REINDEX backend filtering	Mark Dilger	18:32
Re: pg_amcheck contrib application 📎	Mark Dilger	18:38
Re: Parser Hook	Joshua Drake	18:39
Re: Tightening up allowed custom GUC names 📎	Tom Lane	18:49
Re: [HACKERS] PATCH: Batch/pipelining support for libpq 📎	Alvaro Herrera	18:54
Re: pg_amcheck contrib application	Tom Lane	18:57
Re: REINDEX backend filtering	Mark Dilger	18:58
Re: [HACKERS] PATCH: Batch/pipelining support for libpq	Justin Pryzby	19:00
Re: pg_amcheck contrib application	Mark Dilger	19:20
Re: New IndexAM API controlling index vacuum strategies	Andres Freund	19:21
Re: [HACKERS] Custom compression methods	Robert Haas	19:29
Re: pg_amcheck contrib application 📎	Mark Dilger	19:35
Re: REINDEX backend filtering	Julien Rouhaud	19:37
Re: EXPLAIN/EXPLAIN ANALYZE REFRESH MATERIALIZED VIEW	Tom Lane	19:45
Re: [HACKERS] PATCH: Batch/pipelining support for libpq 📎	Alvaro Herrera	19:47
Re: New IndexAM API controlling index vacuum strategies	Peter Geoghegan	19:58
Re: Support tab completion for upper character inputs in psql	Peter Eisentraut	20:20
Re: logical replication worker accesses catalogs in error context callback	Tom Lane	20:51
Re: New IndexAM API controlling index vacuum strategies	Peter Geoghegan	20:58
Nondeterministic collations and the value returned by GROUP BY x	Jim Finnerty	21:31
Re: Enhance traceability of wal_level changes for backup management	Stephen Frost	21:32
pgsql: Add libpq pipeline mode support to pgbench	Alvaro Herrera	21:35
Re: Nondeterministic collations and the value returned by GROUP BY x	Tom Lane	21:46
Re: Calendar support in localization	Thomas Munro	21:57
pg_subscription - substream column?	Peter Smith	22:05
Re: Fwd: row level security (RLS)	Rafal Pietrak	22:24
Re: [PATCH]: Allow errors in parameter values to be reported during the BIND phase itself..	Tom Lane	22:45
Re: [PATCH]: Allow errors in parameter values to be reported during the BIND phase itself..	Justin Pryzby	22:49
Re: [HACKERS] Custom compression methods	Andres Freund	22:58
Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY 📎	Alvaro Herrera	23:04
Re: New IndexAM API controlling index vacuum strategies	Andres Freund	23:11
Re: fdatasync performance problem with large number of DB files	Thomas Munro	23:15
Re: New IndexAM API controlling index vacuum strategies	Andres Freund	23:16
Re: [HACKERS] GSoC 2017: Foreign Key Arrays 📎	Andreas Karlsson	23:27
make the stats collector shutdown without writing the statsfiles if the immediate shutdown is requested. 📎	Masahiro Ikeda	23:50

March 16, 2021

Thread	Author	Time
Re: New IndexAM API controlling index vacuum strategies	Peter Geoghegan	00:00
Re: [PATCH]: Allow errors in parameter values to be reported during the BIND phase itself.. 📎	Tom Lane	00:30
Re: Enhance traceability of wal_level changes for backup management	Laurenz Albe	01:00
Re: Improvements and additions to COPY progress reporting	Michael Paquier	01:00
Re: [PATCH]: Allow errors in parameter values to be reported during the BIND phase itself..	Justin Pryzby	01:18
Re: shared-memory based stats collector 📎	Kyotaro Horiguchi	01:27
Re: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW	Thomas Munro	01:41
Re: shared-memory based stats collector	Andres Freund	02:04
Re: pg_amcheck contrib application 📎	Mark Dilger	02:10
Re: shared-memory based stats collector 📎	Andres Freund	02:55
Re: Type of wait events WalReceiverWaitStart and WalSenderWaitForWAL	Kyotaro Horiguchi	02:59
RE: libpq debug log	[email protected]	03:02
Re: HotStandbyActive() issue in postgres	Hao Wu	03:24
Re: subscriptionCheck failures	Amit Kapila	03:30
RE: subscriptionCheck failures	[email protected]	04:13
RE: make the stats collector shutdown without writing the statsfiles if the immediate shutdown is requested.	[email protected]	04:44
Re: Allow batched insert during cross-partition updates 📎	Amit Langote	05:13
Re: "has_column_privilege()" issue with attnums and non-existent columns	Chengxi Sun	05:42
Re: [HACKERS] Custom compression methods	Dilip Kumar	05:46
Re: [HACKERS] Custom compression methods	Justin Pryzby	05:48
Re: [HACKERS] Custom compression methods	Dilip Kumar	05:59
Re: pg_amcheck contrib application	Noah Misch	06:09
RE: libpq debug log	[email protected]	06:39
Re: Type of wait events WalReceiverWaitStart and WalSenderWaitForWAL	Fujii Masao	06:42
Re: subscriptionCheck failures 📎	Amit Kapila	06:59
Re: subscriptionCheck failures	vignesh C	07:15
Permission failures with WAL files in 13~ on Windows	Michael Paquier	07:20
RE: libpq debug log	[email protected]	07:40
Re: shared-memory based stats collector	Kyotaro Horiguchi	07:44
comment fix in postmaster.c 📎	Kyotaro Horiguchi	07:51
Re: fdatasync performance problem with large number of DB files	Fujii Masao	08:10
Re: Allow batched insert during cross-partition updates	gkokolatos	08:11
Re: shared-memory based stats collector	Kyotaro Horiguchi	08:17
Re: pg_subscription - substream column?	Amit Kapila	08:20
Re: GROUP BY DISTINCT 📎	Vik Fearing	08:21
Re: fdatasync performance problem with large number of DB files	Fujii Masao	08:29
Re: HotStandbyActive() issue in postgres	Fujii Masao	08:44
Re: Allow batched insert during cross-partition updates	Amit Langote	08:59
Re: Permission failures with WAL files in 13~ on Windows	Magnus Hagander	09:02
Re: Allow batched insert during cross-partition updates	gkokolatos	09:13

Browse Archives

Prev | Next