pgsql-hackers since 2019-11-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)
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

Nov. 16, 2019

Thread Author Time
Re: [HACKERS] [WIP] Effective storage of duplicates in B-tree index. Peter Geoghegan 00:04
Re: dropdb --force vignesh C 00:10
Partial path row estimates 📎 Thomas Munro 01:02
Re: [HACKERS] [WIP] Effective storage of duplicates in B-tree index. Peter Geoghegan 01:02
Re: JIT performance bug/regression & JIT EXPLAIN Maciek Sakrejda 01:04
Re: Ordering of header file inclusion 📎 vignesh C 01:31
Re: [HACKERS] [WIP] Effective storage of duplicates in B-tree index. Mark Dilger 01:43
Re: [HACKERS] [WIP] Effective storage of duplicates in B-tree index. Peter Geoghegan 02:03
Re: [HACKERS] [PROPOSAL] Effective storage of duplicates in B-tree index. Peter Geoghegan 02:18
Re: SKIP_LOCKED test causes random buildfarm failures Michael Paquier 06:24
Re: dropdb --force 📎 Pavel Stehule 07:54
Postgres on IBM z/OS 2.2.0 and 2.3.0 parveen mehta 11:31
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎 Amit Kapila 13:14
Re: BUG #16079: Question Regarding the BUG #16064 Magnus Hagander 13:29
Re: [HACKERS] [WIP] Effective storage of duplicates in B-tree index. Te 13:46
Re: Postgres on IBM z/OS 2.2.0 and 2.3.0 Tom Lane 15:33
Copyright information in source files 📎 vignesh C 17:36
Re: Ought to use heap_multi_insert() for pg_attribute/depend insertions? 📎 Daniel Gustafsson 23:01

Nov. 17, 2019

Thread Author Time
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly Steve Singer 00:53
Re: could not stat promote trigger file leads to shutdown Alvaro Herrera 01:59
Re: Attempt to consolidate reading of XLOG page Alvaro Herrera 04:22
Re: Append with naive multiplexing of FDWs Thomas Munro 08:54
Re: SQL/JSON: JSON_TABLE Pavel Stehule 10:35
Re: SimpleLruTruncate() mutual exclusion Dmitry Dolgov 11:56
Re: global / super barriers (for checksums) Magnus Hagander 13:38
Re: Connections hang indefinitely while taking a gin index's LWLock buffer_content lock(PG10.7) 📎 Alexander Korotkov 18:18
Reverse collations (initially for making keyset pagination cover more cases) 📎 David Fetter 18:24
Re: Reverse collations (initially for making keyset pagination cover more cases) Tom Lane 19:30
Re: Reverse collations (initially for making keyset pagination cover more cases) Andrew Gierth 19:56
Re: could not stat promote trigger file leads to shutdown Tom Lane 20:05
Re: Invisible PROMPT2 📎 Thomas Munro 21:11
Re: Reverse collations (initially for making keyset pagination cover more cases) David Fetter 21:54
Re: Reverse collations (initially for making keyset pagination cover more cases) 📎 Andrew Gierth 23:23

Nov. 18, 2019

Thread Author Time
Re: Invisible PROMPT2 Alvaro Herrera 00:49
Re: Invisible PROMPT2 Thomas Munro 01:40
Re: Reverse collations (initially for making keyset pagination cover more cases) 📎 David Fetter 02:29
Re: dropdb --force vignesh C 03:43
Re: [HACKERS] WAL logging problem in 9.4.3? 📎 Noah Misch 04:54
Re: dropdb --force Pavel Stehule 05:02
Re: dropdb --force 📎 Amit Kapila 05:24
Re: dropdb --force Pavel Stehule 05:28
Re: [HACKERS] Block level parallel vacuum Masahiko Sawada 06:06
Re: SimpleLruTruncate() mutual exclusion Noah Misch 06:14
Re: [HACKERS] Block level parallel vacuum Amit Kapila 06:34
Re: dropdb --force Amit Kapila 06:36
Re: [HACKERS] Block level parallel vacuum Masahiko Sawada 06:38
Re: dropdb --force Pavel Stehule 06:39
Re: cost based vacuum (parallel) Masahiko Sawada 06:40
Re: Conflict handling for COPY FROM 📎 Surafel Temesgen 06:42
Planner chose a much slower plan in hashjoin, using a large table as the inner table. Jinbao Chen 06:48
Re: SegFault on 9.6.14 📎 Amit Kapila 08:52
Re: adding partitioned tables to publications 📎 Amit Langote 08:53
PITR on DROP DATABASE, deleting of the database directory despite the recovery_target_time set before. Nicolas Lutic 10:48
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Dilip Kumar 11:32
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Amit Kapila 11:50
Re: segfault in geqo on experimental gcc animal Martin Liška 12:17
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Amit Khandekar 12:20
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Amit Kapila 12:22
Re: Attempt to consolidate reading of XLOG page Michael Paquier 12:29
Re: [HACKERS] pg_shmem_allocations view Michael Paquier 12:49
Re: Getting Recordset through returning refcursor Michael Paquier 12:52
Re: 'Invalid lp' during heap_xlog_delete Michael Paquier 12:58
Re: dropdb --force 📎 Pavel Stehule 12:59
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Amit Khandekar 12:59
Re: function calls optimization Andrzej Barszcz 14:20
Re: Role membership and DROP 📎 Laurenz Albe 14:40
Re: Invisible PROMPT2 Tom Lane 17:21
Re: [PATCH][BUG FIX] Unsafe access pointers. Alvaro Herrera 17:42
Re: Reverse collations (initially for making keyset pagination cover more cases) Tom Lane 17:49
Re: [HACKERS] pg_shmem_allocations view Andres Freund 18:01
Re: Postgres on IBM z/OS 2.2.0 and 2.3.0 parveen mehta 18:24
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 18:47
Re: 'Invalid lp' during heap_xlog_delete Daniel Wood 18:49
Re: segfault in geqo on experimental gcc animal Fabien COELHO 20:08
Re: Invisible PROMPT2 📎 Thomas Munro 21:07
physical slot xmin dependency on logical slot? Jeremy Finzel 21:36
Re: Reverse collations (initially for making keyset pagination cover more cases) Andrew Gierth 21:48
Re: physical slot xmin dependency on logical slot? Andres Freund 22:12
Re: Invisible PROMPT2 Tom Lane 23:09
Re: Duplicate Workers entries in some EXPLAIN plans 📎 Maciek Sakrejda 23:39
Re: Postgres on IBM z/OS 2.2.0 and 2.3.0 Tom Lane 23:58

Nov. 19, 2019

Thread Author Time
Re: physical slot xmin dependency on logical slot? Craig Ringer 00:23
Re: PITR on DROP DATABASE, deleting of the database directory despite the recovery_target_time set before. Craig Ringer 00:40
Re: [HACKERS] [WIP] Effective storage of duplicates in B-tree index. 📎 Peter Geoghegan 01:26
Re: progress report for ANALYZE Amit Langote 01:57
Re: [PATCH] Implement INSERT SET syntax Gareth Palmer 02:34
Re: Invisible PROMPT2 Thomas Munro 03:02
Re: [PATCH] Implement INSERT SET syntax Gareth Palmer 04:05
Re: Hypothetical indexes using BRIN broken since pg10 📎 Michael Paquier 05:40
RE: Recovery performance of DROP DATABASE with many tablespaces k.jamison@fujitsu.com 06:39
Re: Hypothetical indexes using BRIN broken since pg10 Julien Rouhaud 07:37
Re: Planner chose a much slower plan in hashjoin, using a large table as the inner table. Thomas Munro 07:46
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Amit Kapila 08:37
Re: range_agg Pavel Stehule 09:16
Re: Planner chose a much slower plan in hashjoin, using a large table as the inner table. Jinbao Chen 09:56
Re: backup manifests 📎 Rushabh Lathia 10:00
Re: fix for BUG #3720: wrong results at using ltree Benjie Gillam 10:27
Re: Protect syscache from bloating with negative cache entries 📎 Kyotaro Horiguchi 10:48
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Amit Khandekar 11:28
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Thomas Munro 11:49
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Amit Kapila 11:53
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Amit Kapila 11:55
checkpointer: PANIC: could not fsync file: No such file or directory Justin Pryzby 11:57
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Juan José Santamaría Flecha 12:14
Re: Hypothetical indexes using BRIN broken since pg10 Michael Paquier 12:48
Re: backup manifests Andrew Dunstan 13:49
Re: physical slot xmin dependency on logical slot? Jeremy Finzel 14:13
Re: Planning counters in pg_stat_statements (using pgss_store) Julien Rouhaud 14:27
initdb SegFault 📎 vignesh C 14:34
Re: PITR on DROP DATABASE, deleting of the database directory despite the recovery_target_time set before. Nicolas Lutic 15:15
Re: initdb SegFault Tom Lane 15:16
Re: initdb SegFault Andres Freund 16:10
Re: initdb SegFault Tom Lane 17:06
Re: Role membership and DROP 📎 Tom Lane 18:21
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Thomas Munro 18:58
planner support functions: handle GROUP BY estimates ? Justin Pryzby 19:34
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Thomas Munro 19:34
Re: checkpointer: PANIC: could not fsync file: No such file or directory Thomas Munro 20:26
Re: Connections hang indefinitely while taking a gin index's LWLock buffer_content lock(PG10.7) Alexander Korotkov 21:20
Re: backup manifests David Steele 21:34
Re: Invisible PROMPT2 📎 David Fetter 21:37
Proposal- GUC for max dead rows before autovacuum Michael Lewis 22:35
Re: checkpointer: PANIC: could not fsync file: No such file or directory Justin Pryzby 22:49
Re: Proposal- GUC for max dead rows before autovacuum Laurenz Albe 23:01
Re: Role membership and DROP Laurenz Albe 23:05

Nov. 20, 2019

Thread Author Time
RE: Planning counters in pg_stat_statements (using pgss_store) imai.yoshikazu@fujitsu.com 01:06
Re: checkpointer: PANIC: could not fsync file: No such file or directory Justin Pryzby 01:22
Re: initdb SegFault Kyotaro Horiguchi 02:11
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Amit Khandekar 03:54
Re: Allow CREATE OR REPLACE VIEW to rename the columns btkimurayuzk 04:11
RE: Should we add xid_current() or a int8->xid cast? imai.yoshikazu@fujitsu.com 04:43
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Amit Kapila 04:44
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Thomas Munro 04:48
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Amit Kapila 05:16
Re: backup manifests Rushabh Lathia 05:28
Re: [HACKERS] Block level parallel vacuum 📎 Masahiko Sawada 05:30
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Thomas Munro 05:33
Re: backup manifests 📎 Suraj Kharage 05:35
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Dilip Kumar 05:45
Re: range_agg Paul A Jungwirth 05:49
Re: [HACKERS] WAL logging problem in 9.4.3? Kyotaro Horiguchi 06:05
Re: pg_waldump and PREPARE 📎 btkimurayuzk 07:16
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Amit Kapila 07:40
Re: [PATCH] Do not use StdRdOptions in Access Methods 📎 Michael Paquier 07:44
Re: adding partitioned tables to publications Peter Eisentraut 07:55
Re: adding partitioned tables to publications Peter Eisentraut 07:58
Re: [HACKERS] Block level parallel vacuum Amit Kapila 08:02
Re: could not stat promote trigger file leads to shutdown Peter Eisentraut 08:12
Re: [HACKERS] WAL logging problem in 9.4.3? Kyotaro Horiguchi 08:31
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Amit Khandekar 08:32
Re: Attempt to consolidate reading of XLOG page Michael Paquier 08:38
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Amit Khandekar 08:48
Re: pg_waldump and PREPARE Michael Paquier 08:50
Internal function returning pg_statistic Konstantin Knizhnik 09:59
Re: Internal function returning pg_statistic Pavel Stehule 10:26
Re: [HACKERS] Block level parallel vacuum Masahiko Sawada 10:34
Re: Should we add xid_current() or a int8->xid cast? Thomas Munro 10:51
Re: [HACKERS] Block level parallel vacuum Amit Kapila 11:36
Re: dropdb --force Amit Kapila 11:40
Re: SegFault on 9.6.14 Amit Kapila 11:42
Re: dropdb --force Pavel Stehule 11:55
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Juan José Santamaría Flecha 12:11
why doesn't optimizer can pull up where a > ( ... ) Andy Fan 12:15
Re: why doesn't optimizer can pull up where a > ( ... ) Andy Fan 12:16
Re: why doesn't optimizer can pull up where a > ( ... ) Daniel Gustafsson 13:19
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Alvaro Herrera 13:54
Re: Attempt to consolidate reading of XLOG page 📎 Antonin Houska 14:50
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎 Dilip Kumar 14:52
Re: could not stat promote trigger file leads to shutdown Tom Lane 15:21
Re: why doesn't optimizer can pull up where a > ( ... ) Tom Lane 16:12
Re: Global temporary tables 📎 Konstantin Knizhnik 16:32
Re: Planning counters in pg_stat_statements (using pgss_store) Julien Rouhaud 16:54
Re: why doesn't optimizer can pull up where a > ( ... ) Tomas Vondra 17:20
Re: why doesn't optimizer can pull up where a > ( ... ) Tomas Vondra 17:25
Re: Role membership and DROP Tom Lane 17:27
Re: why doesn't optimizer can pull up where a > ( ... ) Tom Lane 17:36
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly 📎 Alexey Kondratov 18:16
Re: why doesn't optimizer can pull up where a > ( ... ) Tomas Vondra 19:18
Re: add a MAC check for TRUNCATE 📎 Joe Conway 19:30
Re: range_agg 📎 Paul A Jungwirth 19:32
Re: Why overhead of SPI is so large? Tom Lane 20:18
Re: why doesn't optimizer can pull up where a > ( ... ) Xun Cheng 20:34
Re: TAP tests aren't using the magic words for Windows file access Thomas Munro 20:40
error context for vacuum to include block number 📎 Justin Pryzby 21:06
Re: add a MAC check for TRUNCATE 📎 Joe Conway 21:19
Re: why doesn't optimizer can pull up where a > ( ... ) Tomas Vondra 21:28
Re: CVE-2017-7484-induced bugs, or, btree cmp functions are not leakproof? Tom Lane 21:34
Why is get_actual_variable_range()'s use of SnapshotNonVacuumable safe during recovery? Peter Geoghegan 21:43
BufFileRead() error signalling Thomas Munro 21:50
Re: BufFileRead() error signalling Thomas Munro 21:52
Re: BufFileRead() error signalling Tom Lane 22:31

Nov. 21, 2019

Thread Author Time
Re: why doesn't optimizer can pull up where a > ( ... ) Andy Fan 00:30
Re: function calls optimization Andy Fan 01:05
Re: checkpointer: PANIC: could not fsync file: No such file or directory Justin Pryzby 01:07
Re: [HACKERS] Block level parallel vacuum Masahiko Sawada 01:23
Re: Hypothetical indexes using BRIN broken since pg10 Michael Paquier 01:33
Re: fix "Success" error messages TAKATSUKA Haruka 01:42
an OID >= 8000 in master 📎 Kyotaro Horiguchi 01:44
Re: an OID >= 8000 in master Michael Paquier 02:06
Re: an OID >= 8000 in master Peter Geoghegan 02:07

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