pgsql-hackers before 2020-04-20 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

April 16, 2020

Thread Author Time
Re: cleaning perl code Mark Dilger 21:35
Re: Poll: are people okay with function/operator table redesign? Andreas Karlsson 22:05
Re: [BUG] non archived WAL removed during production crash recovery Jehan-Guillaume de Rorthais 22:07
Re: [DOC] Document concurrent index builds waiting on each other Andres Freund 22:12
Re: [PATCH'] Variables assigned with values that is never used. Ranier Vilela 22:21
Re: documenting the backup manifest file format Jehan-Guillaume de Rorthais 22:23
Re: remove_useless_groupby_columns does not need to record constraint dependencies David Rowley 22:31
Re: xid wraparound danger due to INDEX_CLEANUP false Andres Freund 22:49
[PATCH] Tiny optimization on nbtinsert.c 📎 Ranier Vilela 22:59
Re: Poll: are people okay with function/operator table redesign? Alvaro Herrera 23:03
Re: sqlsmith crash incremental sort Tomas Vondra 23:13
[PATCH] Fix possible overflow on tuplesort.c 📎 Ranier Vilela 23:54

April 17, 2020

Thread Author Time
Re: Poll: are people okay with function/operator table redesign? 📎 Tom Lane 00:25
Re: Problem with logical replication (crash with REPLICA IDENTITY FULL and cascading replication) Justin Pryzby 00:27
Re: Do we need to handle orphaned prepared transactions in the server? Michael Paquier 00:40
Re: sqlsmith crash incremental sort Tomas Vondra 00:54
Re: sqlsmith crash incremental sort James Coleman 01:02
Re: [DOC] Document concurrent index builds waiting on each other James Coleman 01:04
Re: [PATCH] Keeps tracking the uniqueness with UniqueKey Andy Fan 01:16
Re: sqlsmith crash incremental sort Tom Lane 01:26
Re: [PATCH] Incremental sort (was: PoC: Partial sort) James Coleman 01:28
Re: Allow pg_read_all_stats to read pg_stat_progress_* Kyotaro Horiguchi 01:29
Re: xid wraparound danger due to INDEX_CLEANUP false Peter Geoghegan 01:35
Re: [PATHC] Fix minor memory leak in pg_basebackup Michael Paquier 01:47
Re: Lexer issues Patrick REED 01:57
Re: Making openssl_tls_init_hook OpenSSL specific Michael Paquier 01:57
Re: fixing old_snapshot_threshold's time->xid mapping 📎 Thomas Munro 02:12
Re: where should I stick that backup? Robert Haas 02:22
Re: snapshot too old issues, first around wraparound and then more. 📎 Thomas Munro 03:37
Re: Do we need to handle orphaned prepared transactions in the server? Hamid Akhtar 04:07
It is not documented that pg_promote can exit standby mode 📎 ikedamsh 04:11
Re: ERROR: could not open file "pg_tblspc/ issue with replication setup. Michael Paquier 04:21
Re: It is not documented that pg_promote can exit standby mode Fujii Masao 04:40
Re: It is not documented that pg_promote can exit standby mode Michael Paquier 04:54
Re: snapshot too old issues, first around wraparound and then more. 📎 Thomas Munro 05:17
Re: 001_rep_changes.pl stalls Noah Misch 05:41
Re: Race condition in SyncRepGetSyncStandbysPriority 📎 Kyotaro Horiguchi 05:58
Re: WIP/PoC for parallel backup Kashif Zeeshan 06:00
Possible cache reference leak by removeExtObjInitPriv 📎 Kyotaro Horiguchi 06:18
Re: xid wraparound danger due to INDEX_CLEANUP false Masahiko Sawada 06:18
Re: ERROR: could not open file "pg_tblspc/ issue with replication setup. Rajkumar Raghuwanshi 06:39
Re: [BUG] non archived WAL removed during production crash recovery 📎 Michael Paquier 06:50
Re: It is not documented that pg_promote can exit standby mode Laurenz Albe 06:51
Re: cleaning perl code Noah Misch 06:56
Re: Race condition in SyncRepGetSyncStandbysPriority Fujii Masao 07:03
Re: Parallel Append can break run-time partition pruning 📎 Amit Langote 07:07
Re: WIP/PoC for parallel backup Kashif Zeeshan 07:08
Re: Race condition in SyncRepGetSyncStandbysPriority 📎 Fujii Masao 07:31
Re: 001_rep_changes.pl stalls Kyotaro Horiguchi 08:00
Re: Race condition in SyncRepGetSyncStandbysPriority Masahiko Sawada 08:03
Re: 001_rep_changes.pl stalls Kyotaro Horiguchi 08:06
Re: Race condition in SyncRepGetSyncStandbysPriority Kyotaro Horiguchi 08:07
Re: PG compilation error with Visual Studio 2015/2017/2019 📎 Amit Kapila 08:32
Re: Race condition in SyncRepGetSyncStandbysPriority Kyotaro Horiguchi 08:41
Re: sqlsmith crash incremental sort Richard Guo 08:41
Re: Support for DATETIMEOFFSET Jeremy Morton 09:00
Re: sqlsmith crash incremental sort Richard Guo 09:03
Re: [Proposal] Global temporary tables 曾文旌 09:14
Build errors in VS Lin, Cuiping 09:18
Re: documenting the backup manifest file format Fujii Masao 09:39
Re: Support for DATETIMEOFFSET Andreas Karlsson 09:57
pgstattuple: Have pgstattuple_approx accept TOAST tables 📎 Peter Eisentraut 11:01
Re: [Proposal] Global temporary tables Prabhat Sahu 11:26
Re: snapshot too old issues, first around wraparound and then more. Robert Haas 12:19
Re: wrong relkind error messages Peter Eisentraut 12:45
Re: [Proposal] Global temporary tables Prabhat Sahu 12:59
Re: wrong relkind error messages Tom Lane 13:09
Re: Autovacuum on partitioned table (autoanalyze) Amit Langote 13:09
Re: WAL usage calculation patch Peter Eisentraut 13:15
Re: Support for DATETIMEOFFSET Tom Lane 13:22
Re: adding partitioned tables to publications Peter Eisentraut 13:23
Re: Lexer issues Julien Rouhaud 13:24
Re: [BUG] non archived WAL removed during production crash recovery Jehan-Guillaume de Rorthais 13:33
Re: Support for DATETIMEOFFSET Jeremy Morton 13:36
Re: While restoring -getting error if dump contain sql statements generated from generated.sql file 📎 Masahiko Sawada 13:50
Re: Build errors in VS Andrew Dunstan 13:56
Re: 001_rep_changes.pl stalls Tom Lane 13:59
Re: spin_delay() for ARM Ants Aasma 13:59
Re: adding partitioned tables to publications 📎 Amit Langote 14:58
Re: 001_rep_changes.pl stalls Fujii Masao 15:29
Re: Race condition in SyncRepGetSyncStandbysPriority 📎 Tom Lane 15:31
matchingsel() and NULL-returning operators 📎 Nikita Glukhov 15:50
Re: Making openssl_tls_init_hook OpenSSL specific Andrew Dunstan 16:01
Re: matchingsel() and NULL-returning operators Tom Lane 16:01
Re: where should I stick that backup? Robert Haas 16:19
Re: Race condition in SyncRepGetSyncStandbysPriority Tom Lane 16:30
Re: Possible cache reference leak by removeExtObjInitPriv Tom Lane 17:07
Re: spin_delay() for ARM Robert Haas 17:24
Re: Should we add xid_current() or a int8->xid cast? Robert Haas 17:33
Re: Should we add xid_current() or a int8->xid cast? Andres Freund 17:45
Re: It is not documented that pg_promote can exit standby mode Tom Lane 17:46
proposal - function string_to_table 📎 Pavel Stehule 17:47
Additional Chapter for Tutorial 📎 Jürgen Purtz 17:56
Re: Should we add xid_current() or a int8->xid cast? Robert Haas 18:07
Re: Additional Chapter for Tutorial Corey Huinker 18:18
Re: xid wraparound danger due to INDEX_CLEANUP false Robert Haas 18:21
Re: Poll: are people okay with function/operator table redesign? Robert Haas 18:26
Re: Poll: are people okay with function/operator table redesign? Tom Lane 18:38
Re: Additional Chapter for Tutorial Erik Rijkers 18:40
Re: Should we add xid_current() or a int8->xid cast? Andres Freund 18:42
Re: PG compilation error with Visual Studio 2015/2017/2019 📎 Juan José Santamaría Flecha 18:43
Re: Build errors in VS Andrew Dunstan 19:00
Split interval (used by nbtree suffix truncation) and posting list tuples 📎 Peter Geoghegan 19:11
Re: Poll: are people okay with function/operator table redesign? Robert Haas 19:16
Re: Should we add xid_current() or a int8->xid cast? Alvaro Herrera 19:26
return value from pq_putmessage() is widely ignored Robert Haas 19:49
Re: Poll: are people okay with function/operator table redesign? Tom Lane 19:58
Re: Poll: are people okay with function/operator table redesign? Robert Haas 20:14
Re: return value from pq_putmessage() is widely ignored Tom Lane 20:20
Re: Poll: are people okay with function/operator table redesign? Tom Lane 20:22
Re: snapshot too old issues, first around wraparound and then more. Thomas Munro 20:39
Re: Should we add xid_current() or a int8->xid cast? 📎 Thomas Munro 21:17
Re: proposal - function string_to_table Justin Pryzby 21:29
Re: spin_delay() for ARM Thomas Munro 21:59
Re: Poll: are people okay with function/operator table redesign? David G. Johnston 22:30
Re: Poll: are people okay with function/operator table redesign? Tom Lane 23:04
Re: Poll: are people okay with function/operator table redesign? David G. Johnston 23:08
Re: Poll: are people okay with function/operator table redesign? Tom Lane 23:16
Re: Support for DATETIMEOFFSET Alvaro Herrera 23:25
Re: Poll: are people okay with function/operator table redesign? David G. Johnston 23:40
Re: where should I stick that backup? Andres Freund 23:44

April 18, 2020

Thread Author Time
Re: Poll: are people okay with function/operator table redesign? Tom Lane 00:27
Summary: State of Caching Stable Subexpressions James Coleman 00:43
Re: execExprInterp() questions / How to improve scalar array op expr eval? James Coleman 00:43
Re: Race condition in SyncRepGetSyncStandbysPriority Masahiko Sawada 03:38
Re: proposal - function string_to_table 📎 Pavel Stehule 03:45
Re: PG compilation error with Visual Studio 2015/2017/2019 Amit Kapila 04:07
Re: WAL usage calculation patch Amit Kapila 04:16
Re: Autovacuum on partitioned table (autoanalyze) Justin Pryzby 05:08
Re: fixing old_snapshot_threshold's time->xid mapping 📎 Thomas Munro 06:16
Re: 001_rep_changes.pl stalls 📎 Noah Misch 07:01
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Erik Rijkers 09:07
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎 Erik Rijkers 09:10
Re: [BUG] non archived WAL removed during production crash recovery Michael Paquier 09:26
Re: fixing old_snapshot_threshold's time->xid mapping Dilip Kumar 09:27
Re: PG compilation error with Visual Studio 2015/2017/2019 Ranier Vilela 11:42
Implementation DISTINCT for window aggregate function: SUM Eugen Konkov 11:46
Re: Poll: are people okay with function/operator table redesign? Robert Haas 12:27
Re: snapshot too old issues, first around wraparound and then more. Robert Haas 12:34
relocating the server's backup manifest code 📎 Robert Haas 12:37
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Erik Rijkers 12:42
Re: relocating the server's backup manifest code Michael Paquier 12:57
valgrind error Andrew Dunstan 13:15
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Dilip Kumar 14:01
Re: relocating the server's backup manifest code Robert Haas 14:43
Re: where should I stick that backup? Robert Haas 15:04
Re: Error on failed COMMIT Tony Locke 15:27
Re: WAL usage calculation patch 📎 Julien Rouhaud 15:39
Re: relocating the server's backup manifest code Tom Lane 15:42
Re: Race condition in SyncRepGetSyncStandbysPriority Tom Lane 16:00
Re: relocating the server's backup manifest code Magnus Hagander 16:33
Re: sqlsmith crash incremental sort James Coleman 18:23
Re: fixing old_snapshot_threshold's time->xid mapping Andres Freund 20:17
Re: Poll: are people okay with function/operator table redesign? 📎 Tom Lane 20:36
Re: WAL usage calculation patch Justin Pryzby 20:41
Re: where should I stick that backup? Greg Stark 22:37

April 19, 2020

Thread Author Time
Re: relocating the server's backup manifest code Michael Paquier 00:12
Re: DETACH PARTITION and FOR EACH ROW triggers on partitioned tables 📎 Justin Pryzby 00:22
Re: DETACH PARTITION and FOR EACH ROW triggers on partitioned tables 📎 Justin Pryzby 01:28
Re: [PATCH] Incremental sort (was: PoC: Partial sort) 📎 Justin Pryzby 02:36
Re: Implementation DISTINCT for window aggregate function: SUM David Rowley 03:07
Re: Poll: are people okay with function/operator table redesign? Pavel Stehule 03:40
Re: PG compilation error with Visual Studio 2015/2017/2019 📎 Juan José Santamaría Flecha 10:16
Re: Poll: are people okay with function/operator table redesign? Peter Eisentraut 10:29
Re: Poll: are people okay with function/operator table redesign? Peter Eisentraut 10:36
Re: Poll: are people okay with function/operator table redesign? Peter Eisentraut 10:46
Re: WIP: WAL prefetch (another approach) Dmitry Dolgov 11:48
Re: PG compilation error with Visual Studio 2015/2017/2019 📎 Ranier Vilela 11:56
HEAPDEBUGALL is broken Peter Eisentraut 12:50
Re: Poll: are people okay with function/operator table redesign? Tom Lane 13:23
Re: HEAPDEBUGALL is broken Tom Lane 13:37
Re: [PATCH] Incremental sort (was: PoC: Partial sort) 📎 James Coleman 13:46
Re: WAL usage calculation patch 📎 Julien Rouhaud 14:22
[PATCH] Small optimization across postgres (remove strlen duplicate usage) 📎 Ranier Vilela 14:24
Re: PG compilation error with Visual Studio 2015/2017/2019 Juan José Santamaría Flecha 15:33
Re: Incremental sorts and EXEC_FLAG_REWIND 📎 James Coleman 16:14
Re: Poll: are people okay with function/operator table redesign? Isaac Morland 16:39
Re: Poll: are people okay with function/operator table redesign? Tom Lane 16:59
proposal - psql - use pager for \watch command 📎 Pavel Stehule 17:27
Re: PG compilation error with Visual Studio 2015/2017/2019 📎 Ranier Vilela 18:59
Re: DETACH PARTITION and FOR EACH ROW triggers on partitioned tables Alvaro Herrera 19:13
Re: DETACH PARTITION and FOR EACH ROW triggers on partitioned tables Justin Pryzby 19:18
Re: [PATCH] Small optimization across postgres (remove strlen duplicate usage) Tomas Vondra 19:33
Re: HEAPDEBUGALL is broken Alexander Lakhin 20:00
Re: [PATCH] Small optimization across postgres (remove strlen duplicate usage) Ranier Vilela 20:29
Re: DETACH PARTITION and FOR EACH ROW triggers on partitioned tables Alvaro Herrera 20:38
Re: DETACH PARTITION and FOR EACH ROW triggers on partitioned tables 📎 Justin Pryzby 20:49
Re: [PATCH] Small optimization across postgres (remove strlen duplicate usage) Tomas Vondra 21:18
Re: [PATCH] Small optimization across postgres (remove strlen duplicate usage) Andreas Karlsson 21:20
Re: [PATCH] Small optimization across postgres (remove strlen duplicate usage) Tom Lane 21:38
Re: [PATCH] Small optimization across postgres (remove strlen duplicate usage) David Rowley 22:00
v13: Performance regression related to FORTIFY_SOURCE 📎 Jeff Davis 22:07
Re: Adding missing object access hook invocations Michael Paquier 22:55
Re: Parallel Append can break run-time partition pruning David Rowley 23:00
Re: PG compilation error with Visual Studio 2015/2017/2019 Michael Paquier 23:02
Re: v13: Performance regression related to FORTIFY_SOURCE Peter Geoghegan 23:19
Re: [PATCH] Small optimization across postgres (remove strlen duplicate usage) Ranier Vilela 23:23
Re: [PATCH] Small optimization across postgres (remove strlen duplicate usage) Ranier Vilela 23:36
Re: Adding missing object access hook invocations Mark Dilger 23:43
Re: sqlsmith crash incremental sort Tomas Vondra 23:47

Browse Archives

Prev | Next