pgsql-hackers since 2021-05-16 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)

Browse Archives

Prev | Next

May 16, 2021

Thread Author Time
Re: [HACKERS] Re: Improve OR conditions on joined columns (common star schema problem) Andy Fan 02:03
Re: PG 14 release notes, first draft Tom Lane 02:27
Re: compute_query_id and pg_stat_statements Bruce Momjian 02:29
Re: compute_query_id and pg_stat_statements Alvaro Herrera 03:23
Re: Windows default locale vs initdb Noah Misch 04:29
Re: seawasp failing, maybe in glibc allocator Thomas Munro 10:58
Typo in README.barrier 📎 Tatsuo Ishii 12:11
Re: compute_query_id and pg_stat_statements Julien Rouhaud 12:39
Re: Typo in README.barrier David Rowley 12:51
FDW and connections Phil Godfrin 12:57
Re: Typo in README.barrier 📎 Tatsuo Ishii 13:29
Re: naming of async_mode parameter Etsuro Fujita 14:10
Re: Asynchronous Append on postgres_fdw nodes. 📎 Etsuro Fujita 14:39
Query about time zone patterns in to_char Nitin Jadhav 14:55
Re: Query about time zone patterns in to_char Tom Lane 15:10
Re: Query about time zone patterns in to_char Nitin Jadhav 16:13
Re: Removed extra memory allocations from create_list_bounds 📎 Justin Pryzby 17:00
Re: Query about time zone patterns in to_char Tom Lane 17:04
Re: Removed extra memory allocations from create_list_bounds Zhihong Yu 17:26
Re: Query about time zone patterns in to_char 📎 Nitin Jadhav 18:22
Re: prion failed with ERROR: missing chunk number 0 for toast value 14334 in pg_toast_2619 📎 Tom Lane 20:23
Re: prion failed with ERROR: missing chunk number 0 for toast value 14334 in pg_toast_2619 Peter Geoghegan 20:34
Re: prion failed with ERROR: missing chunk number 0 for toast value 14334 in pg_toast_2619 Tom Lane 22:21
Re: prion failed with ERROR: missing chunk number 0 for toast value 14334 in pg_toast_2619 Andres Freund 22:27
Re: prion failed with ERROR: missing chunk number 0 for toast value 14334 in pg_toast_2619 Andres Freund 22:35
Re: prion failed with ERROR: missing chunk number 0 for toast value 14334 in pg_toast_2619 Tom Lane 22:42
Re: prion failed with ERROR: missing chunk number 0 for toast value 14334 in pg_toast_2619 Andres Freund 23:28

May 17, 2021

Thread Author Time
Re: Typo in README.barrier 📎 David Rowley 00:19
Re: terminate called after throwing an instance of 'std::bad_alloc' Justin Pryzby 00:29
Re: Typo in README.barrier Tatsuo Ishii 00:33
RE: FDW and connections [email protected] 00:43
pg_dumpall misses --no-toast-compression 📎 Michael Paquier 01:12
RE: Support for VACUUMing Foreign Tables [email protected] 01:17
Re: Query about time zone patterns in to_char David Rowley 01:35
Re: Possible memory corruption (src/timezone/zic.c b/src/timezone/zic.c) Kyotaro Horiguchi 01:36
Re: FDW and connections Phil Godfrin 01:52
Re: Rewriting the test of pg_upgrade as a TAP test - take three - remastered set Michael Paquier 01:55
Re: PG 14 release notes, first draft Bruce Momjian 02:51
Re: Condition pushdown: why (=) is pushed down into join, but BETWEEN or >= is not? Andy Fan 02:52
Re: PG 14 release notes, first draft Bruce Momjian 03:06
Re: PG 14 release notes, first draft Bruce Momjian 03:10
Re: compute_query_id and pg_stat_statements Bruce Momjian 03:12
Re: compute_query_id and pg_stat_statements Bruce Momjian 03:12
Re: compute_query_id and pg_stat_statements Bruce Momjian 03:13
Re: PG 14 release notes, first draft Tom Lane 03:17
Re: Race condition in recovery? Kyotaro Horiguchi 03:20
Re: prion failed with ERROR: missing chunk number 0 for toast value 14334 in pg_toast_2619 Bruce Momjian 03:21
Re: PG 14 release notes, first draft Bruce Momjian 03:32
Re: subscriptioncheck failure Amit Kapila 03:36
Re: Race condition in recovery? Kyotaro Horiguchi 04:01
Re: Race condition in recovery? Kyotaro Horiguchi 04:05
Re: Query about time zone patterns in to_char Nitin Jadhav 04:22
Re: Addition of authenticated ID to pg_stat_activity Michael Paquier 04:35
Re: Implementing Incremental View Maintenance 📎 Yugo NAGATA 04:36
Re: Race condition in recovery? Dilip Kumar 04:39
Re: Typo in README.barrier Tatsuo Ishii 04:45
Re: Typo in README.barrier David Rowley 04:46
Re: use AV worker items infrastructure for GIN pending list's cleanup Masahiko Sawada 04:46
Re: amvalidate(): cache lookup failed for operator class 123 Michael Paquier 04:48
Re: Typo in README.barrier Tatsuo Ishii 04:48
Re: Typo in README.barrier Michael Paquier 04:52
Re: subscriptioncheck failure Amit Kapila 05:10
Re: Race condition in recovery? Dilip Kumar 05:16
Re: Typo in README.barrier Tatsuo Ishii 05:18
Re: pg_dumpall misses --no-toast-compression Dilip Kumar 05:50
RE: making update/delete of inheritance trees scale better [email protected] 06:07
Re: [Patch] ALTER SYSTEM READ ONLY 📎 Amul Sul 06:17
Re: making update/delete of inheritance trees scale better 📎 Amit Langote 06:32
"ERROR: deadlock detected" when replicating TRUNCATE 📎 Peter Smith 06:59
Re: wal stats questions torikoshia 07:07
Re: PG 14 release notes, first draft Fujii Masao 07:18
Re: [Patch] ALTER SYSTEM READ ONLY Dilip Kumar 07:36
Re: wal stats questions 📎 Masahiro Ikeda 07:39
Re: Different compression methods for FPI Michael Paquier 07:44
Winflex docs and distro Magnus Hagander 08:17
Re: Addition of authenticated ID to pg_stat_activity Magnus Hagander 08:28
Re: Asynchronous Append on postgres_fdw nodes. Etsuro Fujita 08:40
Re: "ERROR: deadlock detected" when replicating TRUNCATE Amit Kapila 08:47
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Magnus Hagander 09:02
Re: Schema variables - new implementation for Postgres 15 📎 Pavel Stehule 09:04
Re: logical replication worker accesses catalogs in error context callback 📎 Bharath Rupireddy 09:07
Re: Winflex docs and distro Daniel Gustafsson 09:11
Re: Forget close an open relation in ReorderBufferProcessTXN() Amit Kapila 09:13
RE: making update/delete of inheritance trees scale better [email protected] 09:18
Re: "ERROR: deadlock detected" when replicating TRUNCATE Dilip Kumar 09:34
RE: "ERROR: deadlock detected" when replicating TRUNCATE 📎 [email protected] 09:36
Re: Forget close an open relation in ReorderBufferProcessTXN() Amit Kapila 09:44
Re: Winflex docs and distro Magnus Hagander 09:51
Re: Forget close an open relation in ReorderBufferProcessTXN() 📎 Amit Langote 09:52
postgres_fdw - should we tighten up batch_size, fetch_size options against non-numeric values? 📎 Bharath Rupireddy 09:58
Re: "ERROR: deadlock detected" when replicating TRUNCATE Amit Kapila 10:13
Re: "ERROR: deadlock detected" when replicating TRUNCATE Dilip Kumar 10:46
Re: Inaccurate error message when set fdw batch_size to 0 Amit Kapila 10:53
Re: Multiple hosts in connection string failed to failover in non-hot standby mode Daniel Gustafsson 11:06
RE: Parallel scan with SubTransGetTopmostTransaction assert coredump Pengchengliu 11:18
Re: Possible memory corruption (src/timezone/zic.c b/src/timezone/zic.c) 📎 Ranier Vilela 11:28
Skip partition tuple routing with constant partition key 📎 [email protected] 11:36
Re: subscriptioncheck failure 📎 vignesh C 12:18
Re: [HACKERS] logical decoding of two-phase transactions 📎 Ajin Cherian 12:40
RE: Forget close an open relation in ReorderBufferProcessTXN() [email protected] 12:45
Re: postgres_fdw - should we tighten up batch_size, fetch_size options against non-numeric values? Ashutosh Bapat 12:47
Re: Winflex docs and distro Andrew Dunstan 12:55
Re: Re: Parallel scan with SubTransGetTopmostTransaction assert coredump Greg Nancarrow 12:58
Re: Skip partition tuple routing with constant partition key Amit Langote 13:30
Re: wal stats questions Fujii Masao 13:34
Re: PG 14 release notes, first draft Bruce Momjian 13:45
Re: pg_dumpall misses --no-toast-compression Daniel Gustafsson 14:05
Re: PG 14 release notes, first draft Jonathan S. Katz 14:18
Re: postgres_fdw - should we tighten up batch_size, fetch_size options against non-numeric values? Bharath Rupireddy 14:20
pg_get_wal_replay_pause_state() should not return 'paused' while a promotion is ongoing. 📎 Fujii Masao 14:29
Re: pg_dumpall misses --no-toast-compression Tom Lane 14:38
Re: Removed extra memory allocations from create_list_bounds 📎 Nitin Jadhav 14:52
Re: Corrected documentation of data type for the logical replication message formats. vignesh C 14:56
Re: Removed extra memory allocations from create_list_bounds Zhihong Yu 15:00
Re: Removed extra memory allocations from create_list_bounds Justin Pryzby 15:03
Re: [HACKERS] logical decoding of two-phase transactions vignesh C 15:07
Re: Rewriting the test of pg_upgrade as a TAP test - take three - remastered set Andrew Dunstan 16:32
Re: prion failed with ERROR: missing chunk number 0 for toast value 14334 in pg_toast_2619 Drouvot, Bertrand 18:14
Re: prion failed with ERROR: missing chunk number 0 for toast value 14334 in pg_toast_2619 Andres Freund 18:56
Re: PG 14 release notes, first draft Alvaro Herrera 19:29
Re: PG 14 release notes, first draft Peter Geoghegan 19:45
Re: PG 14 release notes, first draft Peter Geoghegan 19:47
Re: Winflex docs and distro Magnus Hagander 19:56
Re: Race condition in recovery? Robert Haas 19:58
Re: pg_hba.conf.sample wording improvement Magnus Hagander 20:10
Re: allow specifying direct role membership in pg_hba.conf Magnus Hagander 20:15
Re: allow specifying direct role membership in pg_hba.conf Chapman Flack 20:31
Re: PG 14 release notes, first draft Bruce Momjian 20:32
Re: allow specifying direct role membership in pg_hba.conf Magnus Hagander 20:35
Move pg_attribute.attcompression to earlier in struct for reduced size? Andres Freund 20:48
Re: pgsql: Move tablespace path re-creation from the makefiles to pg_regres Tom Lane 20:53
ICU bool problem Peter Eisentraut 20:56
Re: ICU bool problem Bruce Momjian 21:01
Re: Move pg_attribute.attcompression to earlier in struct for reduced size? Justin Pryzby 21:05
Re: Move pg_attribute.attcompression to earlier in struct for reduced size? Tom Lane 21:06
Re: allow specifying direct role membership in pg_hba.conf Chapman Flack 21:18
Re: Move pg_attribute.attcompression to earlier in struct for reduced size? Andres Freund 21:28
Re: pgsql: Move tablespace path re-creation from the makefiles to pg_regres 📎 Tom Lane 21:51
Re: allow specifying direct role membership in pg_hba.conf Tom Lane 21:55
Re: Typo in README.barrier David Rowley 22:07
Re: Typo in README.barrier Tom Lane 22:37
Re: Always bump PG_CONTROL_VERSION? Andres Freund 22:47

May 18, 2021

Thread Author Time
Re: Typo in README.barrier Michael Paquier 00:04
Re: pgsql: Move tablespace path re-creation from the makefiles to pg_regres Michael Paquier 00:26
Re: pg_dumpall misses --no-toast-compression Michael Paquier 00:48
Re: "ERROR: deadlock detected" when replicating TRUNCATE Peter Smith 00:49
Re: wal stats questions 📎 Masahiro Ikeda 00:57
Re: pgsql: Move tablespace path re-creation from the makefiles to pg_regres Tom Lane 00:57
Re: pg_get_wal_replay_pause_state() should not return 'paused' while a promotion is ongoing. Kyotaro Horiguchi 00:58
Re: pgsql: Move tablespace path re-creation from the makefiles to pg_regres Michael Paquier 01:01
Re: allow specifying direct role membership in pg_hba.conf Chapman Flack 01:19
Re: "ERROR: deadlock detected" when replicating TRUNCATE Peter Smith 01:22
Re: Move pg_attribute.attcompression to earlier in struct for reduced size? Michael Paquier 01:24
RE: Re: Parallel scan with SubTransGetTopmostTransaction assert coredump Pengchengliu 01:27
Re: Skip partition tuple routing with constant partition key David Rowley 01:27
Re: allow specifying direct role membership in pg_hba.conf Chapman Flack 01:31
Re: Rewriting the test of pg_upgrade as a TAP test - take three - remastered set Michael Paquier 01:49
Re: What is lurking in the shadows? Peter Smith 02:08
RE: Skip partition tuple routing with constant partition key [email protected] 02:11
Re: Performance degradation of REFRESH MATERIALIZED VIEW 📎 Masahiko Sawada 02:20
Re: Addition of authenticated ID to pg_stat_activity Michael Paquier 02:20
Re: What is lurking in the shadows? Michael Paquier 02:25
Re: What is lurking in the shadows? David Rowley 02:26
Re: Skip partition tuple routing with constant partition key Michael Paquier 02:32
Re: Always bump PG_CONTROL_VERSION? Michael Paquier 02:40
Re: subscriptioncheck failure Amit Kapila 03:39
Re: pg_get_wal_replay_pause_state() should not return 'paused' while a promotion is ongoing. Fujii Masao 03:48
RE: Bug in query rewriter - hasModifyingCTE not getting set [email protected] 03:59
Re: "ERROR: deadlock detected" when replicating TRUNCATE Amit Kapila 04:09
Re: Testing autovacuum wraparound (including failsafe) Masahiko Sawada 05:28
Re: Race condition in recovery? Dilip Kumar 05:33
Re: Testing autovacuum wraparound (including failsafe) Peter Geoghegan 05:42
Re: Testing autovacuum wraparound (including failsafe) Masahiko Sawada 05:46
Re: pg_get_wal_replay_pause_state() should not return 'paused' while a promotion is ongoing. 📎 Dilip Kumar 05:53
Re: subscriptioncheck failure 📎 vignesh C 05:54
Re: Forget close an open relation in ReorderBufferProcessTXN() 📎 Amit Langote 06:30
Re: pg_get_wal_replay_pause_state() should not return 'paused' while a promotion is ongoing. Michael Paquier 06:46
Re: Race condition in recovery? Kyotaro Horiguchi 06:52
Re: Race condition in recovery? Kyotaro Horiguchi 06:58
Re: Testing autovacuum wraparound (including failsafe) Masahiko Sawada 07:09
RE: Forget close an open relation in ReorderBufferProcessTXN() [email protected] 07:59
Re: [PATCH v3 1/1] Fix detection of preadv/pwritev support for OSX. Sandeep Thakkar 08:13
Re: pg_get_wal_replay_pause_state() should not return 'paused' while a promotion is ongoing. Fujii Masao 08:13
Re: Re: Parallel scan with SubTransGetTopmostTransaction assert coredump Pavel Borisov 08:18
Re: pg_get_wal_replay_pause_state() should not return 'paused' while a promotion is ongoing. Dilip Kumar 08:52
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith 08:53
Re: allow specifying direct role membership in pg_hba.conf Magnus Hagander 08:54
How to launch parallel aggregations ? Esteban Zimanyi 09:04
Re: Re: Parallel scan with SubTransGetTopmostTransaction assert coredump Greg Nancarrow 09:14
Re: How to launch parallel aggregations ? Bharath Rupireddy 09:15
Re: How to launch parallel aggregations ? Esteban Zimanyi 09:24
Re: PG 14 release notes, first draft Masahiko Sawada 09:28
RE: [HACKERS] logical decoding of two-phase transactions [email protected] 10:50
Re: prion failed with ERROR: missing chunk number 0 for toast value 14334 in pg_toast_2619 Drouvot, Bertrand 11:04
Re: [UNVERIFIED SENDER] Re: pg_upgrade can result in early wraparound on databases with high transaction load 📎 Drouvot, Bertrand 11:26
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila 11:31
Re: Parallel scan with SubTransGetTopmostTransaction assert coredump [email protected] 11:41
Re: Forget close an open relation in ReorderBufferProcessTXN() Amit Kapila 11:59
Re: allow specifying direct role membership in pg_hba.conf Chapman Flack 12:05
Re: Parallel scan with SubTransGetTopmostTransaction assert coredump Greg Nancarrow 12:29

Browse Archives

Prev | Next