pgsql-hackers since 2021-03-14 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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

March 14, 2021

Thread Author Time
Re: Using COPY FREEZE in pgbench Tatsuo Ishii 00:22
Re: Using COPY FREEZE in pgbench Tatsuo Ishii 00:28
Re: A qsort template 📎 Thomas Munro 02:35
RE: [HACKERS] logical decoding of two-phase transactions [email protected] 02:52
Re: New IndexAM API controlling index vacuum strategies Peter Geoghegan 03:23
Re: A qsort template Zhihong Yu 04:06
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? 📎 Julien Rouhaud 08:06
Re: REINDEX backend filtering 📎 Julien Rouhaud 08:10
Re: Using COPY FREEZE in pgbench Fabien COELHO 08:48
Re: PITR promote bug: Checkpointer writes to older timeline 📎 Michael Paquier 08:59
Re: psql - add SHOW_ALL_RESULTS option Fabien COELHO 09:54
Re: pgbench - add pseudo-random permutation function 📎 Fabien COELHO 10:17
Re: REINDEX backend filtering Michael Paquier 11:54
Re: Fallback table AM for relkinds without storage Michael Paquier 11:59
Re: Using COPY FREEZE in pgbench Tatsuo Ishii 12:14
Re: Index Skip Scan (new UniqueKeys) 📎 Dmitry Dolgov 14:48
Re: pgbench - add pseudo-random permutation function Alvaro Herrera 14:54
Re: REINDEX backend filtering Julien Rouhaud 14:57
Re: More time spending with "delete pending" 📎 Alexander Lakhin 15:00
Re: pgbench - add pseudo-random permutation function Fabien COELHO 16:08
Re: [Patch] ALTER SYSTEM READ ONLY 📎 Ibrar Ahmed 18:21
Re: Transactions involving multiple postgres foreign servers, take 2 Ibrar Ahmed 18:55
Re: New IndexAM API controlling index vacuum strategies Peter Geoghegan 19:36
Re: pl/pgsql feature request: shorthand for argument and local variable references 📎 Pavel Stehule 19:41
A Case For Inlining Immediate Referential Integrity Checks Corey Huinker 19:49
Re: [HACKERS] GSoC 2017: Foreign Key Arrays 📎 Justin Pryzby 20:06
Re: fdatasync performance problem with large number of DB files 📎 Thomas Munro 22:52
Postgres crashes at memcopy() after upgrade to PG 13. Avinash Kumar 23:14
Re: Boundary value check in lazy_tid_reaped() Thomas Munro 23:22
Re: fdatasync performance problem with large number of DB files 📎 Thomas Munro 23:33
Re: REINDEX backend filtering Michael Paquier 23:56

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

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31