pgsql-hackers since 2020-08-03 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 31

Aug. 3, 2020

Thread Author Time
Re: LDAP check flapping on crake due to race 📎 Thomas Munro 00:12
dblnk_is_busy returns 1 for dead connecitons Merlin Moncure 00:18
Re: Comment simplehash/dynahash trade-offs Thomas Munro 00:24
Re: LDAP check flapping on crake due to race Noah Misch 00:28
Re: LDAP check flapping on crake due to race Thomas Munro 00:52
Re: psql - improve test coverage from 41% to 88% Michael Paquier 02:06
Re: display offset along with block number in vacuum errors Masahiko Sawada 02:42
Re: dblnk_is_busy returns 1 for dead connecitons Merlin Moncure 02:55
Document "59.2. Built-in Operator Classes" have a clerical error? osdba 03:17
Re: new heapcheck contrib module Mark Dilger 03:17
Re: Document "59.2. Built-in Operator Classes" have a clerical error? David G. Johnston 03:43
Re: new heapcheck contrib module Peter Geoghegan 03:59
Re: new heapcheck contrib module Peter Geoghegan 04:13
Re: expose parallel leader in CSV and log_line_prefix Michael Paquier 04:41
[PATCH v1] elog.c: Remove special case which avoided %*s format strings.. 📎 Justin Pryzby 04:59
Reduce/eliminate the impact of FPW Daniel Wood 05:53
Re: problem with RETURNING and update row movement 📎 Amit Langote 05:54
Re: public schema default ACL Noah Misch 06:30
Re: Add MAIN_RELATION_CLEANUP and SECONDARY_RELATION_CLEANUP options to VACUUM Michael Paquier 06:47
Re: Make autovacuum sort tables in descending order of xid_age Michael Paquier 06:53
Replace remaining StrNCpy() by strlcpy() 📎 Peter Eisentraut 06:59
Re: Parallel copy 📎 Bharath Rupireddy 07:03
Re: [Proposal] Global temporary tables [email protected] 07:09
Re: Is it worth accepting multiple CRLs? Kyotaro Horiguchi 07:19
Re: Is it worth accepting multiple CRLs? Kyotaro Horiguchi 07:20
Re:Re: Document "59.2. Built-in Operator Classes" have a clerical error? osdba 07:35
Re: problem with RETURNING and update row movement Amit Langote 07:39
Re: Keep elog(ERROR) and ereport(ERROR) calls in the cold path Michael Paquier 07:54
Re: SQL/JSON: JSON_TABLE Michael Paquier 07:55
Re: Confusing behavior of create table like Peter Eisentraut 08:00
Re: Replace remaining StrNCpy() by strlcpy() David Rowley 09:01
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma 09:05
Re: Keep elog(ERROR) and ereport(ERROR) calls in the cold path David Rowley 09:05
Re: Is it worth accepting multiple CRLs? Kyotaro Horiguchi 09:17
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits 📎 Anastasia Lubennikova 09:29
Re: Replication & recovery_min_apply_delay Daniel Gustafsson 09:31
Re: [PATCH] - Provide robust alternatives for replace_string Asim Praveen 09:34
Re: deferred primary key and logical replication Ajin Cherian 09:46
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit Bharath Rupireddy 11:11
Re: [PATCH] Add section headings to index types doc Dagfinn Ilmari Mannsåker 11:32
Re: Replace remaining StrNCpy() by strlcpy() Tom Lane 11:38
Re: [POC] Fast COPY FROM command for the table with foreign partitions Amit Langote 11:38
Re: [PATCH] Add section headings to index types doc Magnus Hagander 11:56
Re: Replace remaining StrNCpy() by strlcpy() Tom Lane 12:12
Re: [PATCH] Add section headings to index types doc Tom Lane 12:16
Re: Confusing behavior of create table like Konstantin Knizhnik 12:58
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas 13:35
Re: public schema default ACL Robert Haas 13:46
Re: Allow ERROR from heap_prepare_freeze_tuple to be downgraded to WARNING Robert Haas 14:20
Re: new heapcheck contrib module Mark Dilger 14:42
Re: new heapcheck contrib module Mark Dilger 15:02
Re: [PATCH] - Provide robust alternatives for replace_string Alvaro Herrera 15:06
Re: new heapcheck contrib module Robert Haas 15:09
Re: new heapcheck contrib module Robert Haas 15:10
Re: public schema default ACL Bruce Momjian 15:22
Re: public schema default ACL Stephen Frost 15:26
Re: Reduce/eliminate the impact of FPW Robert Haas 15:26
Re: Confusing behavior of create table like Robert Haas 15:33
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) Robert Haas 15:41
Re: WIP: WAL prefetch (another approach) Tomas Vondra 15:46
Re: Can a background worker exist without shared memory access for EXEC_BACKEND cases? Robert Haas 15:49
Re: Cache relation sizes? Konstantin Knizhnik 15:54
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) Justin Pryzby 16:11
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma 16:13
Re: [PATCH] Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT Wolfgang Walther 16:31
Re: Confusing behavior of create table like Peter Eisentraut 16:35
Re: Support for NSS as a libpq TLS backend 📎 Andrew Dunstan 16:46
Re: Cache relation sizes? Pavel Stehule 17:11
Re: new heapcheck contrib module Peter Geoghegan 17:15
Re: Replace remaining StrNCpy() by strlcpy() Peter Eisentraut 17:27
Re: Replace remaining StrNCpy() by strlcpy() Tom Lane 17:39
Re: Allow an alias to be attached directly to a JOIN ... USING Wolfgang Walther 17:44
Re: public schema default ACL Peter Eisentraut 17:46
Re: Reduce/eliminate the impact of FPW Daniel Wood 18:06
Re: avoid bitmapOR-ing indexes with scan condition inconsistent with partition constraint 📎 Justin Pryzby 18:12
Re: PG 13 release notes, first draft Peter Geoghegan 18:35
Re: dblnk_is_busy returns 1 for dead connecitons 📎 Merlin Moncure 18:42
EDB builds Postgres 13 with an obsolete ICU version Daniel Verite 18:56
Re: Support for NSS as a libpq TLS backend 📎 Andrew Dunstan 19:18
Re: extension patch of CREATE OR REPLACE TRIGGER Wolfgang Walther 19:25
Re: psql - improve test coverage from 41% to 88% Fabien COELHO 19:34
Re: Reduce/eliminate the impact of FPW SATYANARAYANA NARLAPURAM 20:07
Re: PG 13 release notes, first draft Bruce Momjian 21:02
Re: Hybrid Hash/Nested Loop joins and caching results from subplans 📎 David Rowley 22:05
Re: psql - improve test coverage from 41% to 88% Andrew Dunstan 22:44
Re: Amcheck: do rightlink verification with lock coupling Peter Geoghegan 22:44
Re: [PATCH] Btree BackwardScan race condition on Standby during VACUUM Peter Geoghegan 22:55
Re: [PATCH] Keeps tracking the uniqueness with UniqueKey Andy Fan 22:59
ALTER TABLE .. DETACH PARTITION CONCURRENTLY 📎 Alvaro Herrera 23:48
Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY Alvaro Herrera 23:51
Re: Document "59.2. Built-in Operator Classes" have a clerical error? Bruce Momjian 23:51

Aug. 4, 2020

Thread Author Time
Re: Document "59.2. Built-in Operator Classes" have a clerical error? Bruce Momjian 00:01
Re: EDB builds Postgres 13 with an obsolete ICU version Bruce Momjian 00:04
Re: public schema default ACL David G. Johnston 00:29
Re: 13dev failed assert: comparetup_index_btree(): ItemPointer values should never be equal Peter Geoghegan 00:37
Making JIT more granular 📎 David Rowley 02:01
Re: Cache relation sizes? Thomas Munro 02:21
SSL TAP test fails due to default client certs. 📎 Kyotaro Horiguchi 03:00
Clarifying the ImportForeignSchema API David Fetter 03:07
Rewrite view? Hao Wu 03:55
Re: Clarifying the ImportForeignSchema API Ian Lawrence Barwick 04:39
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Amit Kapila 04:42
Re: SSL TAP test fails due to default client certs. Michael Paquier 05:43
Re: Handing off SLRU fsyncs to the checkpointer 📎 Thomas Munro 06:02
Re: [HACKERS][PATCH] Applying PMDK to WAL operations for persistent memory 📎 Takashi Menjo 06:11
Re: ModifyTable overheads in generic plans 📎 Amit Langote 06:15
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎 Dilip Kumar 07:11
Re: [PATCH v1] elog.c: Remove special case which avoided %*s format strings.. Michael Paquier 07:35
Re: EDB builds Postgres 13 with an obsolete ICU version Dave Page 08:06
LSM tree for Postgres Konstantin Knizhnik 08:22
Re: Is it worth accepting multiple CRLs? 📎 Kyotaro Horiguchi 08:37
Re: SSL TAP test fails due to default client certs. Kyotaro Horiguchi 08:41
Re: [PATCH v1] elog.c: Remove special case which avoided %*s format strings.. David Rowley 09:06
Re: [PATCH] - Provide robust alternatives for replace_string Asim Praveen 09:22
Re: EDB builds Postgres 13 with an obsolete ICU version Thomas Kellerer 09:24
Re: EDB builds Postgres 13 with an obsolete ICU version Magnus Hagander 09:28
Re: EDB builds Postgres 13 with an obsolete ICU version Dave Page 09:41
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) 📎 Amit Langote 11:12
Re: Can a background worker exist without shared memory access for EXEC_BACKEND cases? 📎 Bharath Rupireddy 11:27
Re: problem with RETURNING and update row movement Etsuro Fujita 12:25
Yet another issue with step generation in partition pruning 📎 Etsuro Fujita 12:45
Re: Reduce/eliminate the impact of FPW Stephen Frost 13:05
Re: Replace remaining StrNCpy() by strlcpy() 📎 Peter Eisentraut 13:31
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch 📎 Peter Eisentraut 14:08
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch Pavel Stehule 14:21
Re: Concurrency bug in amcheck 📎 Alexander Korotkov 14:27
Re: WIP: BRIN multi-range indexes Alexander Korotkov 14:36
Re: new heapcheck contrib module Robert Haas 14:59
Re: LSM tree for Postgres Alexander Korotkov 15:04
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) Justin Pryzby 15:11
Re: LSM tree for Postgres Tomas Vondra 15:11
Re: WIP: BRIN multi-range indexes Tomas Vondra 15:17
Re: LSM tree for Postgres Stephen Frost 15:18
Re: LSM tree for Postgres Alexander Korotkov 15:24
Add information to rm_redo_error_callback() 📎 Drouvot, Bertrand 15:37
Re: new heapcheck contrib module Peter Geoghegan 16:00
Re: new heapcheck contrib module Robert Haas 16:07
Re: Error on failed COMMIT 📎 Dave Cramer 16:19
Re: Parallel copy Tomas Vondra 16:21
Re: Amcheck: do rightlink verification with lock coupling 📎 Andrey M. Borodin 16:32
Re: new heapcheck contrib module Robert Haas 16:44
Re: Can a background worker exist without shared memory access for EXEC_BACKEND cases? Robert Haas 16:50
Re: Confusing behavior of create table like Robert Haas 16:53
Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY Alvaro Herrera 16:56
Re: LSM tree for Postgres Konstantin Knizhnik 16:56
Re: LSM tree for Postgres Konstantin Knizhnik 17:18
Re: LSM tree for Postgres Konstantin Knizhnik 17:21
Re: Yet another fast GiST build (typo) 📎 Andrey M. Borodin 17:28
Re: Confusing behavior of create table like Konstantin Knizhnik 17:36
Re: LSM tree for Postgres Tomas Vondra 17:44
Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY Robert Haas 17:53
Re: LSM tree for Postgres Konstantin Knizhnik 18:55
For standby pg_ctl doesn't wait for PM_STATUS_READY in presence of promote_trigger_file Ashwin Agrawal 19:01
Re: display offset along with block number in vacuum errors 📎 Mahendra Singh Thalor 19:16
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) Robert Haas 19:48
Re: 13dev failed assert: comparetup_index_btree(): ItemPointer values should never be equal Tom Lane 20:31
Re: Support for NSS as a libpq TLS backend Daniel Gustafsson 21:42
Re: 13dev failed assert: comparetup_index_btree(): ItemPointer values should never be equal Peter Geoghegan 21:49
Re: Confusing behavior of create table like Peter Eisentraut 21:50
Re: 13dev failed assert: comparetup_index_btree(): ItemPointer values should never be equal Tom Lane 22:00
Re: [patch] demote 📎 Jehan-Guillaume de Rorthais 22:04
Re: Confusing behavior of create table like Tom Lane 22:27
Re: Concurrency bug in amcheck Peter Geoghegan 22:58
Re: Concurrency bug in amcheck Alexander Korotkov 23:17
Re: Concurrency bug in amcheck Peter Geoghegan 23:19
Re: LSM tree for Postgres Alexander Korotkov 23:59

Aug. 5, 2020

Thread Author Time
RE: Creating foreign key on partitioned table is too slow [email protected] 00:43
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) Amit Langote 00:53
Re: Add MAIN_RELATION_CLEANUP and SECONDARY_RELATION_CLEANUP options to VACUUM Bossart, Nathan 00:56
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) Justin Pryzby 01:04
Re: new heapcheck contrib module Peter Geoghegan 01:06
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) Amit Langote 01:12
pg13dev: explain partial, parallel hashagg, and memory use Justin Pryzby 01:21
Re: pg13dev: explain partial, parallel hashagg, and memory use David Rowley 01:44
Re: pg13dev: explain partial, parallel hashagg, and memory use James Coleman 02:01
Re: [DOC] Document concurrent index builds waiting on each other 📎 Alvaro Herrera 02:11
Re: pg13dev: explain partial, parallel hashagg, and memory use Justin Pryzby 02:13
Re: [DOC] Document concurrent index builds waiting on each other Alvaro Herrera 02:14
Re: pg13dev: explain partial, parallel hashagg, and memory use David Rowley 02:27
Re: Keep elog(ERROR) and ereport(ERROR) calls in the cold path 📎 David Rowley 03:00
Re: LSM tree for Postgres Peter Geoghegan 03:12
Re: pg13dev: explain partial, parallel hashagg, and memory use 📎 David Rowley 05:25
Re: For standby pg_ctl doesn't wait for PM_STATUS_READY in presence of promote_trigger_file Kyotaro Horiguchi 05:46
Re: Handing off SLRU fsyncs to the checkpointer Thomas Munro 06:00
Reg. Postgres 13 Joel Mariadasan (jomariad) 06:08
Re: LSM tree for Postgres Konstantin Knizhnik 06:13
Re: [PATCH] - Provide robust alternatives for replace_string 📎 Asim Praveen 07:08
Re: LSM tree for Postgres Konstantin Knizhnik 07:08
Re: Reg. Postgres 13 Magnus Hagander 07:29
Re: Yet another issue with step generation in partition pruning Amit Langote 08:12
Re: [PATCH v1] elog.c: Remove special case which avoided %*s format strings.. Michael Paquier 08:22
Re: Add MAIN_RELATION_CLEANUP and SECONDARY_RELATION_CLEANUP options to VACUUM Masahiko Sawada 09:56
Re: LSM tree for Postgres Dmitry Dolgov 11:09
Re: display offset along with block number in vacuum errors Robert Haas 11:19
Re: Can a background worker exist without shared memory access for EXEC_BACKEND cases? Bharath Rupireddy 11:24
Re: Can a background worker exist without shared memory access for EXEC_BACKEND cases? Robert Haas 11:45
Re: Which SET TYPE don't actually require a rewrite Magnus Hagander 12:52
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎 Amit Kapila 12:55
Re: Can a background worker exist without shared memory access for EXEC_BACKEND cases? Bharath Rupireddy 13:02
Re: Can a background worker exist without shared memory access for EXEC_BACKEND cases? Robert Haas 13:14

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 31