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

March 20, 2020

Thread Author Time
Re: nbtree: assertion failure in _bt_killitems() for posting tuple Peter Geoghegan 00:00
Re: improve transparency of bitmap-only heap scans James Coleman 00:04
Re: Add A Glossary 📎 Alvaro Herrera 00:11
Re: error context for vacuum to include block number 📎 Justin Pryzby 00:29
Re: nbtree: assertion failure in _bt_killitems() for posting tuple Peter Geoghegan 00:34
Re: Missing errcode() in ereport 📎 Tom Lane 01:03
Re: improve transparency of bitmap-only heap scans Justin Pryzby 01:26
Re: improve transparency of bitmap-only heap scans 📎 James Coleman 01:38
Re: Add A Glossary Corey Huinker 01:41
Re: Missing errcode() in ereport 📎 Andres Freund 01:59
Re: Berserk Autovacuum (let's save next Mandrill) 📎 David Rowley 02:05
Re: Missing errcode() in ereport Andres Freund 02:12
Re: color by default Bruce Momjian 02:15
Re: Berserk Autovacuum (let's save next Mandrill) Andres Freund 02:23
Re: Missing errcode() in ereport Tom Lane 02:32
Re: Missing errcode() in ereport Andres Freund 04:56
Re: Memory-Bounded Hash Aggregation Pengzhou Tang 05:20
Re: Improving connection scalability: GetSnapshotData() Thomas Munro 05:23
Re: range_agg 📎 Paul A Jungwirth 05:24
Re: Memory-Bounded Hash Aggregation Pengzhou Tang 05:26
Re: error context for vacuum to include block number Amit Kapila 05:54
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe 05:59
Re: Improving connection scalability: GetSnapshotData() Andres Freund 06:00
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe 06:17
Re: Internal key management system 📎 Masahiko Sawada 06:17
Re: Berserk Autovacuum (let's save next Mandrill) Andres Freund 06:20
Re: replay pause vs. standby promotion Atsushi Torikoshi 06:22
Re: Berserk Autovacuum (let's save next Mandrill) Andres Freund 06:44
Re: [PATCH] Add schema and table names to partition error Amit Kapila 06:50
Re: error context for vacuum to include block number 📎 Justin Pryzby 06:51
Re: [PATCH] Add schema and table names to partition error Amit Kapila 06:52
Re: Berserk Autovacuum (let's save next Mandrill) Masahiko Sawada 06:59
Re: proposal: schema variables 📎 Pavel Stehule 07:18
Re: proposal: schema variables 📎 Pavel Stehule 08:28
Re: explain HashAggregate to report bucket and memory stats 📎 Justin Pryzby 08:44
Re: plan cache overhead on plpgsql expression Pavel Stehule 09:46
Re: error context for vacuum to include block number 📎 Amit Kapila 11:28
Re: Why does [auto-]vacuum delay not report a wait event? Amit Kapila 11:31
Re: Why does [auto-]vacuum delay not report a wait event? Magnus Hagander 11:54
Re: Parallel grouping sets 📎 Pengzhou Tang 11:57
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe 13:43
Re: Collation versioning 📎 Julien Rouhaud 13:52
Re: Planning counters in pg_stat_statements (using pgss_store) Sergei Kornilov 14:09
Re: Missing errcode() in ereport Tom Lane 14:40
Re: Missing errcode() in ereport Alvaro Herrera 14:42
Re: range_agg Alvaro Herrera 14:48
Re: error context for vacuum to include block number Justin Pryzby 14:53
Re: Making psql error out on output failures Peter Eisentraut 15:14
where EXEC_BACKEND is defined 📎 Peter Eisentraut 15:24
Re: potential stuck lock in SaveSlotToPath() Peter Eisentraut 15:32
Re: potential stuck lock in SaveSlotToPath() Robert Haas 15:38
Re: Add A Glossary Corey Huinker 15:48
Issues with building cpp extensions on PostgreSQL 10+ 📎 Oleksii Kliukin 16:02
Correlated IN/Any Subquery Transformation 📎 Li, Zheng 16:05
Re: where EXEC_BACKEND is defined Tom Lane 16:36
Re: Correlated IN/Any Subquery Transformation Tom Lane 16:42
Re: Add A Glossary 📎 Alvaro Herrera 17:51
Re: Add A Glossary Roger Harkavy 18:08
Re: Add A Glossary Corey Huinker 18:16
Re: Planning counters in pg_stat_statements (using pgss_store) 📎 Julien Rouhaud 19:30
Re: SQL/JSON: functions Pavel Stehule 19:34
Re: Add A Glossary Justin Pryzby 19:58
Re: Internal key management system Bruce Momjian 20:30
Re: Add FOREIGN to ALTER TABLE in pg_dump Alvaro Herrera 20:35
GiST secondary split Peter Griggs 21:36
Re: Should we add xid_current() or a int8->xid cast? 📎 Thomas Munro 22:14
Re: Auxiliary Processes and MyAuxProc 📎 Mike Palmiotto 22:17
Re: backup manifests 📎 Robert Haas 22:29
Re: Add A Glossary Jürgen Purtz 22:32
Re: Add A Glossary Jürgen Purtz 22:32
Re: Add A Glossary Justin Pryzby 23:03

March 21, 2020

Thread Author Time
Re: [PATCH] Incremental sort (was: PoC: Partial sort) 📎 Tomas Vondra 00:56
Re: color by default Bruce Momjian 02:55
Re: color by default Tom Lane 03:15
Re: color by default Bruce Momjian 03:22
Re: Add A Glossary Corey Huinker 03:45
Re: Why does [auto-]vacuum delay not report a wait event? 📎 Justin Pryzby 04:07
Re: color by default Jonah H. Harris 04:25
Re: plan cache overhead on plpgsql expression 📎 Pavel Stehule 05:08
Re: Internal key management system 📎 Masahiko Sawada 05:12
Re: error context for vacuum to include block number 📎 Amit Kapila 07:30
Re: error context for vacuum to include block number Justin Pryzby 08:03
Re: SQL/JSON: functions 📎 Nikita Glukhov 10:07
Re: [HACKERS] make async slave to wait for lsn to be replayed Anna Akenteva 10:51
Re: GiST secondary split Alexander Korotkov 11:03
Re: [HACKERS] make async slave to wait for lsn to be replayed 📎 Kartyshov Ivan 11:16
Re: backup manifests Amit Kapila 12:26
Re: ssl passphrase callback Andrew Dunstan 13:15
Re: ssl passphrase callback Andrew Dunstan 13:18
Re: color by default Isaac Morland 13:30
Re: Internal key management system Bruce Momjian 14:01
Re: Add A Glossary Jürgen Purtz 14:08
Re: GSoC applicant proposal, Uday PB Chapman Flack 14:30
GSoC chat link not working Ananya Srivastava 14:33
Re: GSoC applicant proposal, Uday PB inout 14:36
Re: Internal key management system Bruce Momjian 14:50
Re: GSoC applicant proposal, Uday PB Chapman Flack 14:54
Re: Add A Glossary Justin Pryzby 15:15
Re: Auxiliary Processes and MyAuxProc Peter Eisentraut 17:40
Re: Ecpg dependency 📎 Bruce Momjian 18:14
Re: plan cache overhead on plpgsql expression 📎 Tom Lane 18:24
Re: Ecpg dependency Bruce Momjian 18:51
Re: [HACKERS] WAL logging problem in 9.4.3? Noah Misch 19:01
Re: [HACKERS] WAL logging problem in 9.4.3? Bruce Momjian 19:04
Re: Ecpg dependency 📎 Dagfinn Ilmari Mannsåker 19:30
Re: SQL/JSON: functions Pavel Stehule 19:38
Re: plan cache overhead on plpgsql expression Pavel Stehule 20:29
Re: Additional improvements to extended statistics 📎 Tomas Vondra 21:59
RE: Index Skip Scan 📎 Floris Van Nee 22:00
Re: Ecpg dependency 📎 Bruce Momjian 22:13
Re: [HACKERS] WAL logging problem in 9.4.3? 📎 Noah Misch 22:49
Re: Refactor compile-time assertion checks for C/C++ Tom Lane 23:22
Database recovery from tablespace only Phillip Black 23:48
Re: Why does [auto-]vacuum delay not report a wait event? Mahendra Singh Thalor 23:54

March 22, 2020

Thread Author Time
Re: ssl passphrase callback 📎 Andrew Dunstan 00:08
Re: Why does [auto-]vacuum delay not report a wait event? Andres Freund 00:24
Re: Additional size of hash table is alway zero for hash aggregates Jeff Davis 00:45
Re: Why does [auto-]vacuum delay not report a wait event? Peter Geoghegan 00:51
Re: Why does [auto-]vacuum delay not report a wait event? Andres Freund 00:53
Re: Why does [auto-]vacuum delay not report a wait event? Peter Geoghegan 00:59
Re: Additional size of hash table is alway zero for hash aggregates Andres Freund 01:26
doc review for parallel vacuum 📎 Justin Pryzby 02:18
Re: kill_prior_tuple and index scan costing Andres Freund 02:33
Re: BUG #16040: PL/PGSQL RETURN QUERY statement never uses a parallel plan 📎 Tom Lane 03:23
Re: kill_prior_tuple and index scan costing Justin Pryzby 04:53
Re: kill_prior_tuple and index scan costing Andres Freund 05:03
Re: BUG #16040: PL/PGSQL RETURN QUERY statement never uses a parallel plan Pavel Stehule 06:48
Re: proposal: schema variables 📎 Pavel Stehule 07:40
Re: Spurious "apparent wraparound" via SimpleLruTruncate() rounding Noah Misch 08:34
optimisation? collation "C" sorting for GroupAggregate for all deterministic collations Maxim Ivanov 09:11
Re: optimisation? collation "C" sorting for GroupAggregate for all deterministic collations Pavel Stehule 09:32
Re: [PATCH] Btree BackwardScan race condition on Standby during VACUUM Andrey M. Borodin 10:34
RE: Index Skip Scan 📎 Floris Van Nee 12:55
Re: Why does [auto-]vacuum delay not report a wait event? Justin Pryzby 14:38
Re: [HACKERS] [PATCH] Generic type subscripting Tom Lane 17:47
Re: Database recovery from tablespace only Justin Pryzby 18:25
Re: [HACKERS] [PATCH] Generic type subscripting 📎 Pavel Stehule 18:51
Re: Assert() failures during RI checks Tom Lane 19:00
Re: Database recovery from tablespace only David G. Johnston 19:17
Re: [HACKERS] [PATCH] Generic type subscripting Tom Lane 19:41
Re: Assert() failures during RI checks Andres Freund 21:18
Re: optimisation? collation "C" sorting for GroupAggregate for all deterministic collations James Coleman 21:28
Re: [PATCH] Incremental sort (was: PoC: Partial sort) Andreas Karlsson 22:02
Re: Some improvements to numeric sqrt() and ln() 📎 Tom Lane 22:16
Re: Index Skip Scan Thomas Munro 22:23
Re: Assert() failures during RI checks Tom Lane 22:30
Re: WAL usage calculation patch Kirill Bychik 22:32

March 23, 2020

Thread Author Time
Re: The flinfo->fn_extra question, from me this time. Dent John 00:13
Re: [PATCH] Incremental sort (was: PoC: Partial sort) James Coleman 00:33
Re: [PATCH] Incremental sort (was: PoC: Partial sort) Andreas Karlsson 00:54
Re: ssl passphrase callback Andreas Karlsson 00:58
Re: optimisation? collation "C" sorting for GroupAggregate for all deterministic collations Corey Huinker 01:00
Re: [PATCH] Incremental sort (was: PoC: Partial sort) James Coleman 02:05
Re: Improve errors when setting incorrect bounds for SSL protocols Michael Paquier 02:06
Re: [PATCH] Incremental sort (was: PoC: Partial sort) James Coleman 02:17
Re: [PATCH] Incremental sort (was: PoC: Partial sort) Tomas Vondra 02:38
Re: [PATCH] Add schema and table names to partition error Amit Kapila 02:52
ASLR support for Postgres12 📎 Joel Mariadasan (jomariad) 03:27
Re: Refactor compile-time assertion checks for C/C++ Michael Paquier 03:58
Re: Refactor compile-time assertion checks for C/C++ Tom Lane 04:22
Re: type of some table storage params on doc Michael Paquier 04:58
Re: Collation versions on Windows (help wanted, apply within) 📎 Thomas Munro 04:58
Re: adding partitioned tables to publications 📎 Amit Langote 05:02
Re: color by default Michael Paquier 05:04
Re: doc review for parallel vacuum Amit Kapila 05:04
Re: pgsql: Disk-based Hash Aggregation. Tom Lane 06:05
Re: [HACKERS] [PATCH] Generic type subscripting 📎 Pavel Stehule 06:30
Re: replay pause vs. standby promotion Fujii Masao 06:51
Re: Internal key management system Masahiko Sawada 06:55
Re: Wait event that should be reported while waiting for WAL archiving to finish Fujii Masao 06:56
Re: pg_stat_progress_basebackup - progress reporting for pg_basebackup, in the server side Fujii Masao 07:06
Re: type of some table storage params on doc Atsushi Torikoshi 07:28
Re: error context for vacuum to include block number Masahiko Sawada 07:39
Re: error context for vacuum to include block number Justin Pryzby 08:16
Re: shared-memory based stats collector Kyotaro Horiguchi 08:17
Re: [HACKERS] WAL logging problem in 9.4.3? 📎 Kyotaro Horiguchi 08:20
Re: Additional improvements to extended statistics Dean Rasheed 08:21
Re: color by default 📎 Peter Eisentraut 08:32
Re: error context for vacuum to include block number Amit Kapila 08:55
Re: Make mesage at end-of-recovery less scary. Peter Eisentraut 09:37
Re: error context for vacuum to include block number 📎 Amit Kapila 09:41
[PATCH] Keeps tracking the uniqueness with UniqueKey 📎 Andy Fan 10:21
Unqualified pg_catalog casts in pg_dump 📎 Daniel Gustafsson 10:23
Re: backup manifests 📎 Amit Kapila 11:04
Re: Index Skip Scan Andy Fan 11:17
Re: Created feature for to_date() conversion using patterns 'YYYY-WW', 'YYYY-WW-D', 'YYYY-MM-W' and 'YYYY-MM-W-D' Mark Lorenz 11:36
Re: WAL usage calculation patch Fujii Masao 12:01
is somewhere documented x LIKE ANY(ARRAY)? Pavel Stehule 12:43
Re: [Patch] pg_rewind: options to use restore_command from recovery.conf or command line Alexander Korotkov 12:47
Re: is somewhere documented x LIKE ANY(ARRAY)? Dagfinn Ilmari Mannsåker 12:54
Re: is somewhere documented x LIKE ANY(ARRAY)? Pavel Stehule 13:01
Negative cost is seen for plan node Richard Guo 13:13
Re: Berserk Autovacuum (let's save next Mandrill) 📎 Laurenz Albe 13:27
Re: [HACKERS] advanced partition matching algorithm for partition-wise join Ashutosh Bapat 13:41
Re: replay pause vs. standby promotion Sergei Kornilov 13:46
Re: WAL usage calculation patch Fujii Masao 14:24
Re: replay pause vs. standby promotion Fujii Masao 14:36
Re: is somewhere documented x LIKE ANY(ARRAY)? Tom Lane 14:38
Re: ASLR support for Postgres12 Tom Lane 14:45
Re: replay pause vs. standby promotion Robert Haas 14:55

Browse Archives

Prev | Next