pgsql-hackers since 2020-10-30 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

Oct. 30, 2020

Thread Author Time
Re: Consistent error reporting for encryption/decryption in pgcrypto Michael Paquier 00:31
Re: Deleting older versions in unique indexes to avoid page splits Peter Geoghegan 00:32
Re: psql \df choose functions by their arguments Greg Sabino Mullane 00:35
Re: Parallel INSERT (INTO ... SELECT ...) 📎 Greg Nancarrow 00:38
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits Tomas Vondra 00:42
MINUS SIGN (U+2212) in EUC-JP encoding is mapped to FULLWIDTH HYPHEN-MINUS (U+FF0D) in UTF-8 Ashutosh Sharma 00:43
Re: Add Information during standby recovery conflicts Masahiko Sawada 01:29
Re: Boundary value check in lazy_tid_reaped() 📎 Masahiko Sawada 01:43
Re: Online checksums verification in the backend Julien Rouhaud 02:01
Re: Online verification of checksums 📎 Michael Paquier 02:30
Re: [patch] Fix checksum verification in base backups for zero page headers Michael Paquier 02:33
Re: contrib/sslinfo cleanup and OpenSSL errorhandling Michael Paquier 02:47
Re: Add statistics to pg_stat_wal view for wal related parameter tuning Fujii Masao 02:50
Re: Online checksums verification in the backend Andres Freund 02:58
Re: Add statistics to pg_stat_wal view for wal related parameter tuning Fujii Masao 03:00
Re: MINUS SIGN (U+2212) in EUC-JP encoding is mapped to FULLWIDTH HYPHEN-MINUS (U+FF0D) in UTF-8 Amit Langote 03:08
Re: MINUS SIGN (U+2212) in EUC-JP encoding is mapped to FULLWIDTH HYPHEN-MINUS (U+FF0D) in UTF-8 Kyotaro Horiguchi 03:19
Re: MINUS SIGN (U+2212) in EUC-JP encoding is mapped to FULLWIDTH HYPHEN-MINUS (U+FF0D) in UTF-8 Tom Lane 03:24
Re: Add Information during standby recovery conflicts Fujii Masao 03:25
Re: MINUS SIGN (U+2212) in EUC-JP encoding is mapped to FULLWIDTH HYPHEN-MINUS (U+FF0D) in UTF-8 Kyotaro Horiguchi 03:28
Re: Enumize logical replication message actions Amit Kapila 03:47
Re: document pg_settings view doesn't display custom options Fujii Masao 03:50
Re: Online checksums verification in the backend Julien Rouhaud 03:58
Re: MINUS SIGN (U+2212) in EUC-JP encoding is mapped to FULLWIDTH HYPHEN-MINUS (U+FF0D) in UTF-8 Tatsuo Ishii 04:06
Re: MINUS SIGN (U+2212) in EUC-JP encoding is mapped to FULLWIDTH HYPHEN-MINUS (U+FF0D) in UTF-8 Tatsuo Ishii 04:17
empty table blocks hash antijoin Pavel Stehule 04:19
Re: Disable WAL logging to speed up data loading Masahiko Sawada 04:32
Re: MINUS SIGN (U+2212) in EUC-JP encoding is mapped to FULLWIDTH HYPHEN-MINUS (U+FF0D) in UTF-8 Ashutosh Sharma 04:34
Re: MINUS SIGN (U+2212) in EUC-JP encoding is mapped to FULLWIDTH HYPHEN-MINUS (U+FF0D) in UTF-8 Kyotaro Horiguchi 04:47
Re: should INSERT SELECT use a BulkInsertState? 📎 Justin Pryzby 04:51
Re: Enumize logical replication message actions Peter Smith 05:07
Re: Online checksums verification in the backend Andres Freund 05:08
Re: MINUS SIGN (U+2212) in EUC-JP encoding is mapped to FULLWIDTH HYPHEN-MINUS (U+FF0D) in UTF-8 Amit Langote 05:38
Re: [PoC] Non-volatile WAL buffer Takashi Menjo 05:57
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 06:00
Re: partition routing layering in nodeModifyTable.c Amit Langote 06:06
Re: ModifyTable overheads in generic plans 📎 Amit Langote 06:13
Re: Enumize logical replication message actions Amit Kapila 06:20
Re: Add important info about ANALYZE after create Functional Index 📎 Michael Paquier 06:22
Re: MINUS SIGN (U+2212) in EUC-JP encoding is mapped to FULLWIDTH HYPHEN-MINUS (U+FF0D) in UTF-8 Kyotaro Horiguchi 07:33
Re: MINUS SIGN (U+2212) in EUC-JP encoding is mapped to FULLWIDTH HYPHEN-MINUS (U+FF0D) in UTF-8 Kyotaro Horiguchi 07:56
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith 08:26
Re: Add Information during standby recovery conflicts 📎 Drouvot, Bertrand 09:02
Re: [HACKERS] logical decoding of two-phase transactions 📎 Ajin Cherian 09:16
Re: Enumize logical replication message actions Amit Kapila 09:30
Re: problem with RETURNING and update row movement 📎 Amit Langote 10:00
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila 10:51
Re: Additional Chapter for Tutorial 📎 Jürgen Purtz 10:57
Re: Enumize logical replication message actions 📎 Ashutosh Bapat 11:35
Re: Enumize logical replication message actions Ashutosh Bapat 11:36
Re: Enumize logical replication message actions Amit Kapila 12:08
Re: Enumize logical replication message actions 📎 Ashutosh Bapat 12:22
Re: Disable WAL logging to speed up data loading Laurenz Albe 12:28
Re: Log message for GSS connection is missing once connection authorization is successful. 📎 vignesh C 12:43
Re: Log message for GSS connection is missing once connection authorization is successful. vignesh C 12:52
Re: Log message for GSS connection is missing once connection authorization is successful. Euler Taveira 13:05
[PATCH] Clarify wording for convalidated in pg_constraint. 📎 Jimmy Angelakos 13:47
Re: [PATCH] Clarify wording for convalidated in pg_constraint. Tom Lane 14:39
Re: shared-memory based stats collector Georgios Kokolatos 15:00
Re: Autovacuum worker doesn't immediately exit on postmaster death Stephen Frost 15:07
Re: cutting down the TODO list thread John Naylor 15:37
Re: Consistent error reporting for encryption/decryption in pgcrypto Georgios Kokolatos 15:54
Re: document pg_settings view doesn't display custom options John Naylor 16:01
Re: Extending range type operators to cope with elements Georgios Kokolatos 16:01
Re: document pg_settings view doesn't display custom options Tom Lane 16:07
Re: pg_upgrade analyze script Georgios Kokolatos 16:09
Re: Error on failed COMMIT Georgios Kokolatos 16:13
Re: BUG #15383: Join Filter cost estimation problem in 10.5 Anastasia Lubennikova 16:15
Re: BUG #15383: Join Filter cost estimation problem in 10.5 Tom Lane 16:29
Re: BUG #15383: Join Filter cost estimation problem in 10.5 David G. Johnston 16:33
Re: Corruption during WAL replay Anastasia Lubennikova 16:34
Re: document pg_settings view doesn't display custom options 📎 John Naylor 16:35
Re: Parallel copy Heikki Linnakangas 16:36
Re: Parallel copy Heikki Linnakangas 16:41
Re: Additional Chapter for Tutorial 📎 Erik Rijkers 16:45
Re: document pg_settings view doesn't display custom options Tom Lane 16:48
Re: Parallel copy 📎 Heikki Linnakangas 16:52
Re: document pg_settings view doesn't display custom options 📎 John Naylor 17:06
Re: enable_incremental_sort changes query behavior James Coleman 17:26
document deviation from standard on REVOKE ROLE 📎 John Naylor 18:03
Re: Yet another fast GiST build 📎 Andrey Borodin 18:20
Re: Assertion failure when ATTACH partition followed by CREATE PARTITION. Justin Pryzby 20:01
Re: making update/delete of inheritance trees scale better Heikki Linnakangas 20:35
Re: Parallel copy Tomas Vondra 20:37
Re: Parallel copy Tomas Vondra 20:56
Re: Assertion failure when ATTACH partition followed by CREATE PARTITION. Tom Lane 21:01
Re: libpq compression Andres Freund 21:03
Re: enable_incremental_sort changes query behavior Tomas Vondra 21:03
Re: making update/delete of inheritance trees scale better Tom Lane 21:10
Re: making update/delete of inheritance trees scale better Heikki Linnakangas 21:55
Re: Extending range type operators to cope with elements 📎 Tomas Vondra 22:08
Re: Parallel copy Heikki Linnakangas 22:09
Re: making update/delete of inheritance trees scale better Tom Lane 22:12
Re: contrib/sslinfo cleanup and OpenSSL errorhandling Daniel Gustafsson 22:20
Re: Consistent error reporting for encryption/decryption in pgcrypto Daniel Gustafsson 22:23
Re: making update/delete of inheritance trees scale better Heikki Linnakangas 22:26
Re: enable_incremental_sort changes query behavior 📎 James Coleman 23:37
Re: Should the function get_variable_numdistinct consider the case when stanullfrac is 1.0? Tomas Vondra 23:40
Re: A couple questions about ordered-set aggregates Tomas Vondra 23:49

Oct. 31, 2020

Thread Author Time
Re: Should the function get_variable_numdistinct consider the case when stanullfrac is 1.0? Tom Lane 00:50
Re: Consistent error reporting for encryption/decryption in pgcrypto Michael Paquier 01:03
Re: Should the function get_variable_numdistinct consider the case when stanullfrac is 1.0? Tom Lane 01:04
Re: [PATCH] Add extra statistics to explain for Nested Loop 📎 Tomas Vondra 01:20
Re: Stats collector's idx_blks_hit value is highly misleading in practice Tomas Vondra 01:46
Re: bulk typos 📎 Justin Pryzby 02:08
Re: Collation versioning 📎 Thomas Munro 02:27
Re: Add important info about ANALYZE after create Functional Index Justin Pryzby 03:30
Re: Log message for GSS connection is missing once connection authorization is successful. Bharath Rupireddy 03:34
Re: Log message for GSS connection is missing once connection authorization is successful. Bharath Rupireddy 03:49
Re: Log message for GSS connection is missing once connection authorization is successful. Bharath Rupireddy 04:48
CREATE INDEX CONCURRENTLY on partitioned index 📎 Justin Pryzby 06:31
Re: Removing unneeded self joins 📎 Andrey V. Lepikhov 09:26
Re: A new function to wait for the backend exit after termination 📎 Bharath Rupireddy 10:58
Re: Log message for GSS connection is missing once connection authorization is successful. 📎 vignesh C 11:10
Re: Parallel copy Tomas Vondra 13:39
Dereference before NULL check (src/backend/storage/ipc/latch.c) 📎 Ranier Vilela 14:40
Explicit NULL dereference (src/backend/utils/adt/ruleutils.c) 📎 Ranier Vilela 14:49
Re: public schema default ACL Noah Misch 16:35
Re: Stats collector's idx_blks_hit value is highly misleading in practice Peter Geoghegan 17:16
Re: libpq compression Andrey Borodin 17:25
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly 📎 Justin Pryzby 18:36
Re: libpq compression Konstantin Knizhnik 19:08
Re: Consistent error reporting for encryption/decryption in pgcrypto 📎 Daniel Gustafsson 20:40
Re: Additional Chapter for Tutorial 📎 Justin Pryzby 21:34
Re: Log message for GSS connection is missing once connection authorization is successful. Euler Taveira 22:03
Re: Add important info about ANALYZE after create Functional Index 📎 Fabrízio de Royes Mello 22:56
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch 📎 Tom Lane 23:57

Nov. 1, 2020

Thread Author Time
Re: cleanup temporary files after crash Euler Taveira 00:01
Re: Add important info about ANALYZE after create Functional Index Michael Paquier 00:23
Re: Add important info about ANALYZE after create Functional Index Michael Paquier 01:11
Re: Add important info about ANALYZE after create Functional Index Justin Pryzby 01:15
Re: cleanup temporary files after crash Michael Paquier 01:25
Re: Log message for GSS connection is missing once connection authorization is successful. Bharath Rupireddy 06:42
Re: libpq compression Daniil Zakhlystov 09:37
Re: libpq compression 📎 Konstantin Knizhnik 10:01
Re: libpq compression Daniil Zakhlystov 10:11
Re: Consistent error reporting for encryption/decryption in pgcrypto Michael Paquier 10:23
Re: Add important info about ANALYZE after create Functional Index Michael Paquier 12:29
how to replicate test results in cf-bot on travis Dave Cramer 12:58
Re: Support for NSS as a libpq TLS backend Andrew Dunstan 13:13
Re: Additional Chapter for Tutorial 📎 Jürgen Purtz 15:38
Re: psql \df choose functions by their arguments 📎 Greg Sabino Mullane 16:40
Re: Add important info about ANALYZE after create Functional Index Fabrízio de Royes Mello 16:53
Re: psql \df choose functions by their arguments David Christensen 17:05
Re: how to replicate test results in cf-bot on travis Thomas Munro 18:41
Re: how to replicate test results in cf-bot on travis Dave Cramer 18:46
Getting Gen_fmgrtab.pl to generate macros for all pg_proc entries 📎 Tom Lane 19:19
Getting rid of aggregate_dummy() 📎 Tom Lane 20:47
Re: Support for NSS as a libpq TLS backend 📎 Daniel Gustafsson 22:04
Re: how to replicate test results in cf-bot on travis Dave Cramer 23:02
Re: how to replicate test results in cf-bot on travis Tom Lane 23:15

Nov. 2, 2020

Thread Author Time
RE: Disable WAL logging to speed up data loading [email protected] 00:27
Re: Dereference before NULL check (src/backend/storage/ipc/latch.c) Kyotaro Horiguchi 00:49
Re: Parallel Append can break run-time partition pruning David Rowley 00:50
Re: Online checksums verification in the backend Michael Paquier 01:05
Re: Explicit NULL dereference (src/backend/utils/adt/ruleutils.c) 📎 Kyotaro Horiguchi 01:36
Re: Online checksums verification in the backend Andres Freund 01:39
Re: Online checksums verification in the backend Michael Paquier 01:45
Re: Online checksums verification in the backend Andres Freund 01:50
Re: Parallel Append can break run-time partition pruning Amit Langote 01:58
Re: Explicit NULL dereference (src/backend/utils/adt/ruleutils.c) Tom Lane 02:05
Re: Explicit NULL dereference (src/backend/utils/adt/ruleutils.c) 📎 Kyotaro Horiguchi 02:19
[PATCH] Support negative indexes in split_part 📎 Nikhil Benesch 02:39
Re: [PATCH] Support negative indexes in split_part Tom Lane 02:56
Re: Dereference before NULL check (src/backend/storage/ipc/latch.c) Thomas Munro 03:22
Re: [PATCH] Support negative indexes in split_part Nikhil Benesch 03:48
Re: Explicit NULL dereference (src/backend/utils/adt/ruleutils.c) 📎 Kyotaro Horiguchi 04:36
Re: enable pg_stat_statements to track rows processed by REFRESH MATERIALIZED VIEW Yuki Seino 05:02
Re: Dereference before NULL check (src/backend/storage/ipc/latch.c) 📎 Kyotaro Horiguchi 05:33
Re: extension patch of CREATE OR REPLACE TRIGGER Peter Smith 05:38
Re: Parallel copy Amit Kapila 06:14
Re: Additional Chapter for Tutorial Erik Rijkers 06:15
Re: bulk typos Michael Paquier 06:22
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 06:39
Re: should INSERT SELECT use a BulkInsertState? Luc Vlaming 06:53
Re: Collation versioning Julien Rouhaud 06:59
reindex partitioned indexes: refactor ReindexRelationConcurrently ? 📎 Justin Pryzby 07:00
Re: Parallel copy Heikki Linnakangas 07:10
Re: Online checksums verification in the backend Michael Paquier 07:29
Reduce the number of special cases to build contrib modules on windows 📎 David Rowley 07:34
hash_array_extended() needs to pass down collation 📎 Peter Eisentraut 07:40
Re: making update/delete of inheritance trees scale better Amit Langote 07:40
Re: Hybrid Hash/Nested Loop joins and caching results from subplans 📎 David Rowley 07:43
Re: Parallel copy Heikki Linnakangas 07:50
Re: Collation versioning 📎 Thomas Munro 07:55
Fix a typo in verify_heapam.c 📎 Masahiko Sawada 08:05
Re: Fix a typo in verify_heapam.c Heikki Linnakangas 08:10
Re: reindex partitioned indexes: refactor ReindexRelationConcurrently ? Michael Paquier 08:18
Re: Dereference before NULL check (src/backend/storage/ipc/latch.c) Kyotaro Horiguchi 08:25
Re: Additional Chapter for Tutorial Jürgen Purtz 08:26
Re: Additional Chapter for Tutorial Erik Rijkers 08:44
Re: Enumize logical replication message actions Amit Kapila 08:45
Re: Enumize logical replication message actions Ashutosh Bapat 08:53
Split copy.c 📎 Heikki Linnakangas 09:03
Add table AM 'tid_visible' Jinbao Chen 09:16
Re: Collation versioning Julien Rouhaud 09:28
Re: Split copy.c Erik Rijkers 09:36
Re: Commitfest 2020-11 Anastasia Lubennikova 10:20
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila 10:41
Re: public schema default ACL Peter Eisentraut 10:51

Browse Archives

Prev | Next