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

Thread Author Time
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Thomas Munro 00:34
Fwd: GROUP BY DISTINCT Pantelis Theodosiou 01:03
Re: pg_amcheck contrib application 📎 Mark Dilger 01:04
Re: pg_amcheck contrib application Robert Haas 01:16
Re: Different compression methods for FPI 📎 Justin Pryzby 01:28
Re: EXPLAIN/EXPLAIN ANALYZE REFRESH MATERIALIZED VIEW Japin Li 01:29
Re: pgbench: option delaying queries till connections establishment? Tom Lane 02:46
Re: A qsort template Thomas Munro 02:49
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 03:00
Re: pgbench: option delaying queries till connections establishment? Thomas Munro 03:00
Re: pgbench: option delaying queries till connections establishment? Tom Lane 03:08
Re: TRUNCATE on foreign table Kazutaka Onishi 03:35
Re: pgbench: option delaying queries till connections establishment? 📎 Thomas Munro 03:37
Re: pgbench: option delaying queries till connections establishment? Tom Lane 03:58
Re: pgbench: option delaying queries till connections establishment? Thomas Munro 04:23
Re: [HACKERS] PATCH: Batch/pipelining support for libpq 📎 Alvaro Herrera 04:28
Re: Parallel INSERT (INTO ... SELECT ...) Tom Lane 04:38
Re: pg_amcheck contrib application 📎 Mark Dilger 04:41
Re: pg_amcheck contrib application Tom Lane 04:53
Re: pg_amcheck contrib application Tom Lane 04:56
Re: pg_amcheck contrib application Tom Lane 05:08
Re: pg_amcheck contrib application Mark Dilger 05:09
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 05:17
Re: pg_amcheck contrib application Tom Lane 05:27
Re: pg_amcheck contrib application Tom Lane 05:30
Re: New IndexAM API controlling index vacuum strategies Masahiko Sawada 05:34
Re: proposal: schema variables 📎 Pavel Stehule 06:01
Re: pg_amcheck contrib application Tom Lane 06:07
Re: pg_amcheck contrib application Noah Misch 06:16
Re: pg_amcheck contrib application Mark Dilger 06:18
Re: shared-memory based stats collector Andres Freund 06:20
Re: pg_amcheck contrib application Tom Lane 06:22
Re: pg_amcheck contrib application Mark Dilger 06:28
Re: pg_amcheck contrib application Andres Freund 06:30
Re: pgbench: option delaying queries till connections establishment? Tom Lane 06:31
Re: pg_amcheck contrib application 📎 Mark Dilger 06:33
Re: pg_amcheck contrib application Tom Lane 06:36
Re: pg_amcheck contrib application Mark Dilger 06:55
Re: pg_amcheck contrib application Tom Lane 07:00
Re: pg_amcheck contrib application Noah Misch 07:19
Re: pg_amcheck contrib application Tom Lane 07:36
RE: [HACKERS] logical decoding of two-phase transactions [email protected] 08:00
Re: pgbench: option delaying queries till connections establishment? Fabien COELHO 08:08
Re: pgbench - add pseudo-random permutation function 📎 Fabien COELHO 08:49
Re: pl/pgsql feature request: shorthand for argument and local variable references Julien Rouhaud 08:53
Re: pgbench: option delaying queries till connections establishment? Thomas Munro 09:54
Re: TRUNCATE on foreign table 📎 Kazutaka Onishi 09:57
Re: [HACKERS] GSoC 2017: Foreign Key Arrays 📎 Mark Rofail 10:08
Re: [PATCH] Provide more information to filter_prepare Amit Kapila 10:13
Re: pgbench: option delaying queries till connections establishment? Fabien COELHO 11:09
Re: pl/pgsql feature request: shorthand for argument and local variable references 📎 Pavel Stehule 11:10
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail 11:42
Re: pl/pgsql feature request: shorthand for argument and local variable references Julien Rouhaud 11:49
Re: shared-memory based stats collector Magnus Hagander 11:53
Re: pg_amcheck contrib application Robert Haas 13:49
Re: pgbench - add pseudo-random permutation function Alvaro Herrera 14:44
Re: pg_amcheck contrib application Tom Lane 14:50
Re: pg_amcheck contrib application 📎 Mark Dilger 15:20
Re: pgbench - add pseudo-random permutation function 📎 Fabien COELHO 15:42
Re: Different compression methods for FPI Andrey Borodin 15:48
Re: pg_amcheck contrib application Robert Haas 15:59
Re: shared-memory based stats collector Andres Freund 18:05
amcheck hardening 📎 Mark Dilger 18:35
Re: pg_amcheck contrib application Noah Misch 18:46
Re: pg_amcheck contrib application Mark Dilger 18:51
Re: amcheck hardening Peter Geoghegan 19:06
Re: pg_amcheck contrib application Noah Misch 19:18
Re: amcheck hardening Mark Dilger 19:29
Re: PITR promote bug: Checkpointer writes to older timeline 📎 Soumyadeep Chakraborty 20:29
Re: Using COPY FREEZE in pgbench Fabien COELHO 21:16

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

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