pgsql-hackers since 2019-09-28 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

Sept. 28, 2019

Thread Author Time
max_parallel_workers question Jeff Davis 00:07
Re: [PATCH] Incremental sort (was: PoC: Partial sort) 📎 James Coleman 00:31
Re: SQL/JSON: functions 📎 Nikita Glukhov 01:42
Re: SQL/JSON: JSON_TABLE 📎 Nikita Glukhov 01:50
Re: [HACKERS] [WIP] Effective storage of duplicates in B-tree index. Peter Geoghegan 02:02
Re: Change atoi to strtol in same place Joe Nelson 02:35
Re: ECPG installcheck tests fail if PGDATABASE is set Peter Geoghegan 03:18
contrib/bloom Valgrind error Peter Geoghegan 04:02
Re: max_parallel_workers question Robert Haas 04:10
Re: Consider low startup cost in add_partial_path Robert Haas 04:16
Re: pgbench - allow to create partitioned tables Amit Kapila 05:19
Re: contrib/bloom Valgrind error Michael Paquier 06:00
Re: Don't codegen deform code for virtual tuples in expr eval for scan fetch 📎 Soumyadeep Chakraborty 06:01
Re: Change atoi to strtol in same place Michael Paquier 06:06
Re: pgbench - allow to create partitioned tables 📎 Fabien COELHO 06:11
Re: Cleanup code related to OpenSSL <= 0.9.6 in fe/be-secure-openssl.c Michael Paquier 06:28
Re: Instability of partition_prune regression test results Amit Langote 07:20
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Amit Kapila 08:06
Re: Attempt to consolidate reading of XLOG page Antonin Houska 08:14
Re: Attempt to consolidate reading of XLOG page Antonin Houska 08:15
Re: pglz performance 📎 Andrey Borodin 08:29
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Amit Kapila 12:03
Re: Modest proposal for making bpchar less inconsistent Bruce Momjian 12:22
Re: Attempt to consolidate reading of XLOG page Antonin Houska 13:00
Re: Hooks for session start and end, take two Fabrízio de Royes Mello 13:43
Re: Standby accepts recovery_target_timeline setting? 📎 Fujii Masao 14:54
Re: Document recovery_target_action behavior? Fujii Masao 15:14
default partitions can be partitioned and have default partitions? Justin Pryzby 15:18
Possible bug: SQL function parameter in window frame definition Alastair McKinley 15:33
Re: Standby accepts recovery_target_timeline setting? David Steele 15:51
Re: Possible bug: SQL function parameter in window frame definition Andrew Gierth 15:59
Re: Document recovery_target_action behavior? David Steele 16:00
Re: [DOC] Document concurrent index builds waiting on each other Bruce Momjian 16:18
Re: Document recovery_target_action behavior? Jonathan S. Katz 17:03
Re: Standby accepts recovery_target_timeline setting? Fujii Masao 17:26
Re: Instability of partition_prune regression test results Tom Lane 17:34
Re: Unstable select_parallel regression output in 12rc1 Tom Lane 17:36
Re: max_parallel_workers question Jeff Davis 17:36
Re: Standby accepts recovery_target_timeline setting? Tom Lane 17:45
Re: Standby accepts recovery_target_timeline setting? David Steele 17:49
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎 Tomas Vondra 19:09
Re: Usage of the system truststore for SSL certificate validation Bruce Momjian 19:59
Re: Possible bug: SQL function parameter in window frame definition Tom Lane 20:37
Re: PostgreSQL12 and older versions of OpenSSL Peter Eisentraut 20:52
Re: Standby accepts recovery_target_timeline setting? Peter Eisentraut 21:07
Re: Possible bug: SQL function parameter in window frame definition 📎 Andrew Gierth 21:30
Re: Memory Accounting Tomas Vondra 22:12
Re: Memory Accounting Tomas Vondra 22:22
Re: Consider low startup cost in add_partial_path Tomas Vondra 22:37
Re: [PATCH] Incremental sort (was: PoC: Partial sort) Tomas Vondra 22:55
Re: [PATCH] Incremental sort (was: PoC: Partial sort) Tomas Vondra 23:00
Re: Possible bug: SQL function parameter in window frame definition Tom Lane 23:10
Re: Consider low startup cost in add_partial_path James Coleman 23:21

Sept. 29, 2019

Thread Author Time
Re: [DOC] Document concurrent index builds waiting on each other Alvaro Herrera 01:22
Re: Wrong results using initcap() with non normalized string Alvaro Herrera 01:38
Re: PostgreSQL12 and older versions of OpenSSL Michael Paquier 01:47
Re: [DOC] Document concurrent index builds waiting on each other James Coleman 01:54
Re: [DOC] Document concurrent index builds waiting on each other Bruce Momjian 01:56
Re: [DOC] Document concurrent index builds waiting on each other James Coleman 02:08
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎 Dilip Kumar 04:34
Re: Possible bug: SQL function parameter in window frame definition Andrew Gierth 04:43
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Amit Kapila 05:54
Re:Re: could not access status of transaction chenhj 07:20
Connections hang indefinitely while taking a gin index's LWLock buffer_content lock(PG10.7) chenhj 08:16
Re: Possible bug: SQL function parameter in window frame definition 📎 Andrew Gierth 10:46
Re: pgsql: Implement jsonpath .datetime() method Alexander Korotkov 14:29
Re: Connections hang indefinitely while taking a gin index's LWLock buffer_content lock(PG10.7) Alexander Korotkov 14:38
Re: Connections hang indefinitely while taking a gin index's LWLock buffer_content lock(PG10.7) Alexander Korotkov 15:12
Re: [DOC] Document concurrent index builds waiting on each other Alvaro Herrera 15:27
recovery_min_apply_delay in archive recovery causes assertion failure in latch 📎 Fujii Masao 15:49
Re: Connections hang indefinitely while taking a gin index's LWLock buffer_content lock(PG10.7) 📎 Alexander Korotkov 16:27
Re: Standby accepts recovery_target_timeline setting? 📎 Fujii Masao 16:36
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Alvaro Herrera 17:30
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Tomas Vondra 17:56
Re: Possible bug: SQL function parameter in window frame definition Tom Lane 18:15
Re: Unstable select_parallel regression output in 12rc1 Christoph Berg 19:31
Re: Connections hang indefinitely while taking a gin index's LWLock buffer_content lock(PG10.7) Peter Geoghegan 19:52
python detection v windows Andrew Dunstan 20:16
Windows v readline Andrew Dunstan 20:55
Re: Standby accepts recovery_target_timeline setting? Peter Eisentraut 21:11
Re: v12 relnotes: alter system tables Peter Eisentraut 21:30
Re: Standby accepts recovery_target_timeline setting? Peter Eisentraut 21:59
typo: postGER Justin Pryzby 22:43
Re: JIT performance bug/regression & JIT EXPLAIN Andres Freund 23:30

Sept. 30, 2019

Thread Author Time
checking my understanding of TupleDesc Chapman Flack 00:13
Re: pg_wal/RECOVERYHISTORY file remains after archive recovery 📎 Michael Paquier 01:10
Re: [DOC] Document concurrent index builds waiting on each other Michael Paquier 01:24
documentation inconsistent re: alignment Chapman Flack 01:24
Re: Hooks for session start and end, take two Michael Paquier 01:29
Re: Standby accepts recovery_target_timeline setting? 📎 Fujii Masao 01:48
Re: default partitions can be partitioned and have default partitions? Amit Langote 01:54
Re: recovery_min_apply_delay in archive recovery causes assertion failure in latch Michael Paquier 03:42
Re: pg_wal/RECOVERYHISTORY file remains after archive recovery 📎 Masahiko Sawada 03:53
Re: Batch insert in CTAS/MatView code Paul Guo 04:01
Re: Batch insert in CTAS/MatView code Paul Guo 04:12
Re: Change atoi to strtol in same place 📎 Joe Nelson 04:51
Re: SSL tests failing for channel_binding with OpenSSL <= 1.0.1 Michael Paquier 05:35
Re: Possible bug: SQL function parameter in window frame definition Andrew Gierth 05:37
Re: Connections hang indefinitely while taking a gin index's LWLock buffer_content lock(PG10.7) Andrey Borodin 05:38
Re: pgbench - allow to create partitioned tables Amit Kapila 06:06
Re: Skip recovery/standby signal files in pg_basebackup Masahiko Sawada 07:05
Re: Two pg_rewind patches (auto generate recovery conf and ensure clean shutdown) 📎 Paul Guo 07:07
Re: Skip recovery/standby signal files in pg_basebackup Michael Paquier 07:21
Re: Batch insert in CTAS/MatView code Andres Freund 07:38
Inconsistent usage of BACKEND_* symbols 📎 Kyotaro Horiguchi 07:39
Re: Don't codegen deform code for virtual tuples in expr eval for scan fetch Andres Freund 08:00
Re: pg_wal/RECOVERYHISTORY file remains after archive recovery 📎 Michael Paquier 08:03
Re: pg_wal/RECOVERYHISTORY file remains after archive recovery Masahiko Sawada 08:07
Re: Removing unneeded self joins 📎 Konstantin Knizhnik 08:29
Re: Skip recovery/standby signal files in pg_basebackup Ashutosh Sharma 08:49
Re: recovery_min_apply_delay in archive recovery causes assertion failure in latch 📎 Fujii Masao 08:50
Re: Two pg_rewind patches (auto generate recovery conf and ensure clean shutdown) 📎 Alexey Kondratov 08:51
Re: pgbench - allow to create partitioned tables 📎 Fabien COELHO 08:56
Re: Usage of the system truststore for SSL certificate validation Magnus Hagander 09:13
Re: backup manifests Jeevan Chalke 09:31
Re: Parallel grouping sets 📎 Pengzhou Tang 09:41
Drop Trigger Mechanism with Detached partitions M Beena Emerson 09:58
Re: backup manifests 📎 Rushabh Lathia 10:07
Re: Zedstore - compressed in-core columnar storage Ashutosh Sharma 10:38
Re: pgbench - allow to create partitioned tables Amit Kapila 10:42
Re: Online checksums patch - once again 📎 Magnus Hagander 11:03
Re: Minimal logical decoding on standbys 📎 Amit Khandekar 11:34
Re: pgbench - allow to create partitioned tables 📎 Fabien COELHO 11:47
Re: [HACKERS] [PATCH] Generic type subscripting 📎 Dmitry Dolgov 11:57
Re: Online checksums patch - once again Tomas Vondra 12:49
Re: Implementing Incremental View Maintenance 📎 Yugo Nagata 13:34
Re: SSL tests failing for channel_binding with OpenSSL <= 1.0.1 Tom Lane 13:37
Re: add a MAC check for TRUNCATE Joe Conway 14:28
Re: add a MAC check for TRUNCATE Alvaro Herrera 14:38
Re: Commit fest 2019-09 Alvaro Herrera 14:50
Re: Online checksums patch - once again Bruce Momjian 14:53
Re: Online checksums patch - once again Magnus Hagander 14:57
Re: Online checksums patch - once again Bruce Momjian 14:58
Re: Online checksums patch - once again Magnus Hagander 14:59
Re: Optimize partial TOAST decompression Tomas Vondra 15:56
Re: SQL/JSON: JSON_TABLE 📎 Pavel Stehule 16:09
Re: Online checksums patch - once again Andres Freund 16:11
Re: Don't codegen deform code for virtual tuples in expr eval for scan fetch Soumyadeep Chakraborty 16:14
Re: Optimize partial TOAST decompression Andrey Borodin 16:20
Re: FETCH FIRST clause PERCENT option Ryan Lambert 16:47
Re: Building infrastructure for B-Tree deduplication that recognizes when opclass equality is also equivalence 📎 Anastasia Lubennikova 17:03
Re: Two pg_rewind patches (auto generate recovery conf and ensure clean shutdown) Alvaro Herrera 17:13
Re: Proposal: Add more compile-time asserts to expose inconsistencies. Andres Freund 17:14
Re: Two pg_rewind patches (auto generate recovery conf and ensure clean shutdown) Alvaro Herrera 17:15
Re: Proposal: Add more compile-time asserts to expose inconsistencies. Tom Lane 17:20
Re: Proposal: Add more compile-time asserts to expose inconsistencies. Andres Freund 17:28
Re: Optimize partial TOAST decompression Tomas Vondra 17:29
Re: Connections hang indefinitely while taking a gin index's LWLock buffer_content lock(PG10.7) Alexander Korotkov 17:37
Re: Hooks for session start and end, take two Fabrízio de Royes Mello 17:46
Partitioning versus autovacuum Greg Stark 17:48
Re: Connections hang indefinitely while taking a gin index's LWLock buffer_content lock(PG10.7) Alexander Korotkov 17:59
Re: SSL tests failing for channel_binding with OpenSSL <= 1.0.1 Jeff Davis 18:08
Re: Minimal logical decoding on standbys Robert Haas 18:08
Re: errbacktrace Peter Eisentraut 18:16
Re: Partitioning versus autovacuum Greg Stark 18:21
Re: Commit fest 2019-09 Alvaro Herrera 18:28
Re: Partitioning versus autovacuum Greg Stark 19:03
Re: Connections hang indefinitely while taking a gin index's LWLock buffer_content lock(PG10.7) Peter Geoghegan 19:07
Re: Commit fest 2019-09 Alvaro Herrera 19:12
Re: Auxiliary Processes and MyAuxProc 📎 Mike Palmiotto 19:13
Revert back to standard AC_STRUCT_TIMEZONE Autoconf macro 📎 Peter Eisentraut 19:17
Re: Commit fest 2019-09 Alvaro Herrera 19:24
Re: Connections hang indefinitely while taking a gin index's LWLock buffer_content lock(PG10.7) Peter Geoghegan 19:25
Re: Revert back to standard AC_STRUCT_TIMEZONE Autoconf macro Tom Lane 19:36
Re: Connections hang indefinitely while taking a gin index's LWLock buffer_content lock(PG10.7) Peter Geoghegan 19:54
Re: pgsql: Implement jsonpath .datetime() method Robert Haas 19:55
Re: Possible bug: SQL function parameter in window frame definition Tom Lane 20:25
Re: Memory Accounting 📎 Jeff Davis 20:34
msys2 is missing pexports 📎 Andrew Dunstan 21:06
Transparent Data Encryption (TDE) and encrypted files Bruce Momjian 21:26
Re: Commit fest 2019-09 David Fetter 21:26
Value of Transparent Data Encryption (TDE) Bruce Momjian 21:40
Re: Commit fest 2019-09 David Steele 22:20
PL/pgSQL — "commit" illegal in the executable section of a block statement that has an exception section Bryn Llewellyn 22:37
Re: Don't codegen deform code for virtual tuples in expr eval for scan fetch Andres Freund 23:07

Oct. 1, 2019

Thread Author Time
Include RELKIND_TOASTVALUE in get_relkind_objtype 📎 Hsu, John 00:10
Re: SSL tests failing for channel_binding with OpenSSL <= 1.0.1 Michael Paquier 00:13
Re: Don't codegen deform code for virtual tuples in expr eval for scan fetch Soumyadeep Chakraborty 00:35
Re: subscriptionCheck failures on nightjar Tom Lane 01:40
Re: PL/pgSQL — "commit" illegal in the executable section of a block statement that has an exception section Christophe Pettus 01:40
Re: Two pg_rewind patches (auto generate recovery conf and ensure clean shutdown) Paul Guo 02:08
Re: Memory Accounting Tomas Vondra 02:11
Re: Commit fest 2019-09 Amit Kapila 02:33
Re: [HACKERS] [WIP] Effective storage of duplicates in B-tree index. 📎 Peter Geoghegan 02:39
Re: Connections hang indefinitely while taking a gin index's LWLock buffer_content lock(PG10.7) Alexander Korotkov 02:55
Re: Hooks for session start and end, take two Michael Paquier 03:17
Re: Attempt to consolidate reading of XLOG page Kyotaro Horiguchi 03:22
Re: A comment fix in xlogreader.c Kyotaro Horiguchi 03:24
Re: pgbench - allow to create partitioned tables 📎 Amit Kapila 04:50
Re: recovery_min_apply_delay in archive recovery causes assertion failure in latch Michael Paquier 05:06
Re: Building infrastructure for B-Tree deduplication that recognizes when opclass equality is also equivalence Antonin Houska 05:41
Re: Building infrastructure for B-Tree deduplication that recognizes when opclass equality is also equivalence Andrew Gierth 05:55
Re: Optimize partial TOAST decompression Andrey Borodin 06:20
Re: pgbench - allow to create partitioned tables Fabien COELHO 06:20
Re: Attempt to consolidate reading of XLOG page Antonin Houska 06:28
Re: Keep compiler silence (clang 10, implicit conversion from 'long' to 'double' ) Kyotaro Horiguchi 06:41
Re: Commit fest 2019-09 Michael Paquier 07:15
Re: Transparent Data Encryption (TDE) and encrypted files Tels 07:32
Declaring a strict function returns not null / eval speed Andres Freund 07:38
Proposal: Make use of C99 designated initialisers for nulls/values arrays 📎 Smith, Peter 07:55

Browse Archives

Prev | Next