pgsql-hackers since 2019-11-19 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. 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
Re: an OID >= 8000 in master Peter Geoghegan 02:10
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Amit Khandekar 03:24
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Dilip Kumar 03:32
Re: Internal function returning pg_statistic Kyotaro Horiguchi 03:32
Re: [HACKERS] Block level parallel vacuum Amit Kapila 03:45
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Amit Kapila 04:02
Re: [HACKERS] Block level parallel vacuum Dilip Kumar 04:25
Rework manipulation and structure of attribute mappings 📎 Michael Paquier 04:25
Re: an OID >= 8000 in master Kyotaro Horiguchi 04:33
Re: an OID >= 8000 in master Peter Geoghegan 04:44
Re: an OID >= 8000 in master Tom Lane 04:45
RE: Proposal: Make use of C99 designated initialisers for nulls/values arrays Smith, Peter 04:50
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Amit Kapila 04:56
Re: [HACKERS] Block level parallel vacuum Dilip Kumar 05:16
Re: [PATCH] Do not use StdRdOptions in Access Methods Michael Paquier 05:22
Re: [HACKERS] Block level parallel vacuum Dilip Kumar 05:32
Re: dropdb --force vignesh C 05:33
Re: an OID >= 8000 in master Kyotaro Horiguchi 06:02
Re: [HACKERS] Block level parallel vacuum Masahiko Sawada 06:50
Re: [HACKERS] WAL logging problem in 9.4.3? 📎 Kyotaro Horiguchi 07:01
Re: [HACKERS] WAL logging problem in 9.4.3? Kyotaro Horiguchi 07:11
Re: Attempt to consolidate reading of XLOG page Michael Paquier 08:05
Re: [HACKERS] Block level parallel vacuum Masahiko Sawada 08:21
Re: function calls optimization Andrzej Barszcz 08:37
Re: Ordering of header file inclusion 📎 Amit Kapila 08:40
Re: [HACKERS] Block level parallel vacuum Masahiko Sawada 08:45
Re: pg_upgrade fails with non-standard ACL Michael Paquier 08:53
Re: backup manifests Jeevan Chalke 09:03
Re: range_agg Pavel Stehule 09:06
Re: [HACKERS] Block level parallel vacuum Dilip Kumar 09:15
Re: backup manifests Jeevan Chalke 09:21
Re: Why overhead of SPI is so large? 📎 Konstantin Knizhnik 09:31
Re: fix "Success" error messages Peter Eisentraut 09:40
Re: CVE-2017-7484-induced bugs, or, btree cmp functions are not leakproof? 📎 Amit Langote 09:42
Re: [HACKERS] Block level parallel vacuum Dilip Kumar 09:55
Re: why doesn't optimizer can pull up where a > ( ... ) Tomas Vondra 10:11
Re: tableam vs. TOAST Peter Eisentraut 10:37
Re: [HACKERS] Block level parallel vacuum Amit Kapila 10:37
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Amit Kapila 10:44
Re: [proposal] recovery_target "latest" Peter Eisentraut 10:46
Re: [HACKERS] WAL logging problem in 9.4.3? 📎 Kyotaro Horiguchi 10:48
Re: Allow CREATE OR REPLACE VIEW to rename the columns Fujii Masao 10:58
Re: Recovery performance of DROP DATABASE with many tablespaces Fujii Masao 12:12
Re: pause recovery if pitr target not reached Peter Eisentraut 12:34
Re: pause recovery if pitr target not reached 📎 Leif Gunnar Erlandsen 12:50
Re: Conflict handling for COPY FROM Alexey Kondratov 13:22
Re: TAP tests aren't using the magic words for Windows file access Andrew Dunstan 14:35
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Juan José Santamaría Flecha 15:02
Re: an OID >= 8000 in master Tom Lane 15:35
Re: why doesn't optimizer can pull up where a > ( ... ) Andy Fan 15:57
Re: SQL/JSON: JSON_TABLE Nikita Glukhov 16:28
Re: SQL/JSON: JSON_TABLE Pavel Stehule 16:51
Re: why doesn't optimizer can pull up where a > ( ... ) Tomas Vondra 17:15
Re: Remove configure --disable-float4-byval and --disable-float8-byval Peter Eisentraut 18:20
Re: dropdb --force 📎 Pavel Stehule 18:39
Re: [PATCH] Do not use StdRdOptions in Access Methods Nikolay Shaplov 18:39
Re: Why overhead of SPI is so large? Pavel Stehule 18:47
obsolete example Pavel Stehule 18:58
Re: TAP tests aren't using the magic words for Windows file access 📎 Juan José Santamaría Flecha 19:09
Re: Why overhead of SPI is so large? Tom Lane 19:44
Re: range_agg Paul Jungwirth 20:15
Re: Copyright information in source files Thomas Munro 20:28
Re: Copyright information in source files Tom Lane 20:42
Re: obsolete example Euler Taveira 23:19
Re: [PATCH] Implement INSERT SET syntax 📎 Gareth Palmer 23:24

Nov. 22, 2019

Thread Author Time
Re: obsolete example 📎 Michael Paquier 00:13
Re: obsolete example Tom Lane 00:39
Re: Attempt to consolidate reading of XLOG page Michael Paquier 00:49
Re: [PATCH] Do not use StdRdOptions in Access Methods Amit Langote 02:01
Assertion failing in master, predicate.c 📎 Mark Dilger 02:20
Re: Assertion failing in master, predicate.c 📎 Mark Dilger 02:36
Re: fix "Success" error messages TAKATSUKA Haruka 03:23
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Amit Kapila 03:37
Re: Attempt to consolidate reading of XLOG page Alvaro Herrera 03:49
Re: Assertion failing in master, predicate.c Tom Lane 04:03
Re: Ordering of header file inclusion vignesh C 04:14
Re: pause recovery if pitr target not reached Kyotaro Horiguchi 04:26
Re: an OID >= 8000 in master Kyotaro Horiguchi 04:47
Re: obsolete example Pavel Stehule 05:11
Re: Why overhead of SPI is so large? Pavel Stehule 05:15
Re: checkpointer: PANIC: could not fsync file: No such file or directory Craig Ringer 05:17

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