pgsql-hackers since 2020-12-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)
Advanced Search

Browse Archives

Prev | Next

Dec. 30, 2020

Thread Author Time
Re: Lazy JIT IR code generation to increase JIT speed with partitions Andres Freund 01:57
Re: [PATCH] LWLock self-deadlock detection Andres Freund 02:11
RE: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW Hou, Zhijie 02:33
lwlock optimization opportunities Andres Freund 02:42
Re: Cleanup some -I$(libpq_srcdir) in makefiles Michael Paquier 03:46
Re: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW 📎 Bharath Rupireddy 03:49
Re: Parallel Inserts in CREATE TABLE AS 📎 Bharath Rupireddy 03:55
Re: WIP: WAL prefetch (another approach) Andres Freund 03:57
Re: Cache relation sizes? Andres Freund 04:35
Re: pglz compression performance, take two Justin Pryzby 04:39
Re: Cache relation sizes? Thomas Munro 04:39
Re: Re: Re: Cache relation sizes? 📎 Thomas Munro 04:52
Re: Re: Re: Cache relation sizes? Thomas Munro 04:53
Re: Parallel Inserts in CREATE TABLE AS Dilip Kumar 05:01
Re: Parallel Inserts in CREATE TABLE AS Bharath Rupireddy 05:17
Re: Parallel Inserts in CREATE TABLE AS Dilip Kumar 05:19
RE: [Patch] Optimize dropping of relation buffers using dlist Tang, Haiying 05:57
Re: Single transaction in the tablesync worker? 📎 Peter Smith 06:08
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit 📎 Bharath Rupireddy 06:10
Re: Single transaction in the tablesync worker? Peter Smith 06:15
Re: Single transaction in the tablesync worker? Peter Smith 06:21
Re: [POC] Fast COPY FROM command for the table with foreign partitions 📎 Andrey Lepikhov 07:16
Re: Weird failure in explain.out with OpenBSD Michael Paquier 07:17
Re: [PATCH] Simplify permission checking logic in user.c Michael Paquier 07:53
Re: PoC Refactor AM analyse API Denis Smirnov 09:12
Re: Parallel Inserts in CREATE TABLE AS Dilip Kumar 09:34
popcount 📎 David Fetter 10:55
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit 📎 Alexey Kondratov 11:50
Re: Parallel Inserts in CREATE TABLE AS vignesh C 11:56
Re: [Patch] Optimize dropping of relation buffers using dlist Amit Kapila 11:58
Re: Parallel Inserts in CREATE TABLE AS vignesh C 11:58
Re: Dump public schema ownership & seclabels Noah Misch 11:59
Re: Commitfest 2021-01 Masahiko Sawada 12:11
Re: pglz compression performance, take two 📎 Andrey Borodin 12:22
Re: create table like: ACCESS METHOD Simon Riggs 12:33
Re: Allow CURRENT_ROLE in GRANTED BY Simon Riggs 12:43
Re: Fail Fast In CTAS/CMV If Relation Already Exists To Avoid Unnecessary Rewrite, Planning Costs Michael Paquier 12:55
Re: Disable WAL logging to speed up data loading Michael Paquier 13:04
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila 13:19
Re: Lazy JIT IR code generation to increase JIT speed with partitions 📎 Luc Vlaming 13:23
Re: Added missing copy related data structures to typedefs.list Amit Kapila 13:42
Re: [HACKERS] [PATCH] Generic type subscripting Dmitry Dolgov 13:45
Re: [HACKERS] [PATCH] Generic type subscripting 📎 Dmitry Dolgov 13:47
Re: Disable WAL logging to speed up data loading Simon Riggs 13:53
Re: allow partial union-all and improve parallel subquery costing 📎 Luc Vlaming 13:54
Re: adding partitioned tables to publications 📎 赵锐 14:15
Re: Parallel Inserts in CREATE TABLE AS Bharath Rupireddy 14:16
Re: dynamic result sets support in extended query protocol 📎 Peter Eisentraut 14:33
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit Bharath Rupireddy 14:59
Re: Multi Inserts in CREATE TABLE AS - revived patch Simon Riggs 15:04
Re: [PATCH] Simplify permission checking logic in user.c Stephen Frost 15:26
Re: [PATCH] Simplify permission checking logic in user.c Stephen Frost 15:39
Re: popcount Daniel Verite 16:27
Re: popcount 📎 David Fetter 16:41
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit Alexey Kondratov 17:41
Re: psql \df choose functions by their arguments 📎 Greg Sabino Mullane 18:00
Re: [PATCH] Simplify permission checking logic in user.c Andrey Borodin 18:28
Re: [HACKERS] [PATCH] Generic type subscripting Pavel Stehule 18:48
Re: Let people set host(no)ssl settings from initdb David Fetter 19:24
Re: Let people set host(no)ssl settings from initdb 📎 David Fetter 19:29
Re: Implement <null treatment> for window functions 📎 Krasiyan Andreev 19:32
Re: [PATCH] Simplify permission checking logic in user.c Paul Martinez 19:37
Re: Implement <null treatment> for window functions 📎 David Fetter 19:50
Re: Let people set host(no)ssl settings from initdb Tom Lane 20:00
Re: [HACKERS] [PATCH] Generic type subscripting Dmitry Dolgov 20:01
Re: Implement <null treatment> for window functions Krasiyan Andreev 20:16
Re: Let people set host(no)ssl settings from initdb Isaac Morland 20:17
Buildfarm's cross-version-upgrade tests Tom Lane 20:42
crash recovery vs partially written WAL Andres Freund 20:52
Re: [PATCH] Allow queries in WHEN expression of FOR EACH STATEMENT triggers 📎 Joe Wildish 21:01
Re: Let people set host(no)ssl settings from initdb David Fetter 21:07
Re: Reloptions for table access methods Simon Riggs 21:23
Re: Buildfarm's cross-version-upgrade tests Andrew Dunstan 21:28
Re: [PATCH] Simplify permission checking logic in user.c Stephen Frost 21:38
Re: Proposed patch for key management Bruce Momjian 23:47
Re: Proposed patch for key managment Stephen Frost 23:49

Dec. 31, 2020

Thread Author Time
Re: HOT chain bug in latestRemovedXid calculation Peter Geoghegan 00:33
Moving other hex functions to /common 📎 Bruce Momjian 00:35
Re: Moving other hex functions to /common 📎 Bruce Momjian 01:22
Re: Proposed patch for key managment Bruce Momjian 01:35
Re: Deleting older versions in unique indexes to avoid page splits 📎 Peter Geoghegan 02:54
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit Bharath Rupireddy 02:59
WIP: document the hook system 📎 David Fetter 03:28
Re: [HACKERS] logical decoding of two-phase transactions 📎 Amit Kapila 05:18
Re: Parallel Inserts in CREATE TABLE AS Dilip Kumar 05:23
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila 05:26
Re: Moving other hex functions to /common Michael Paquier 06:10
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian 07:01
Re: Buildfarm's cross-version-upgrade tests Noah Misch 07:45
Re: Proposed patch for key management Fabien COELHO 10:11
Re: Asynchronous Append on postgres_fdw nodes. 📎 Etsuro Fujita 10:15
Re: Proposed patch for key managment Fabien COELHO 10:21
Re: Proposed patch for key managment Fabien COELHO 10:31
Re: Dependency isn't created between extension and schema Masahiko Sawada 11:05
[PATCH] New default role allowing to change per-role/database settings 📎 Michael Banck 13:15
support for MERGE 📎 Alvaro Herrera 13:47
Re: Deleting older versions in unique indexes to avoid page splits Victor Yegorov 13:50
Re: Proposed patch for key managment Stephen Frost 14:18
Re: Zedstore - compressed in-core columnar storage Simon Riggs 14:22
Re: [HACKERS] [PATCH] Generic type subscripting 📎 Dmitry Dolgov 14:28
Re: Proposed patch for key management Stephen Frost 14:36
Re: Proposed patch for key managment Stephen Frost 14:40
Re: [Doc Patch] Clarify that CREATEROLE roles can GRANT default roles Michael Banck 15:05
Re: Proposed patch for key management Bruce Momjian 16:44
Re: Proposed patch for key management Stephen Frost 17:05
Re: Proposed patch for key management Bruce Momjian 17:21
Re: Buildfarm's cross-version-upgrade tests Andrew Dunstan 17:54
Re: Proposed patch for key management Joshua Drake 18:41
Re: Proposed patch for key management Joshua Drake 18:46
Re: Deleting older versions in unique indexes to avoid page splits Zhihong Yu 19:02
Re: pgbench: option delaying queries till connections establishment? Thomas Munro 19:10
Re: crash recovery vs partially written WAL Bruce Momjian 19:13
Re: Deleting older versions in unique indexes to avoid page splits Victor Yegorov 19:14
Re: [HACKERS] [PATCH] Generic type subscripting Pavel Stehule 19:21
Re: crash recovery vs partially written WAL Stephen Frost 19:27
Re: new heapcheck contrib module Thomas Munro 19:31
Re: Table AM modifications to accept column projection lists 📎 Soumyadeep Chakraborty 21:02
Re: crash recovery vs partially written WAL Bruce Momjian 23:11

Jan. 1, 2021

Thread Author Time
Re: Deleting older versions in unique indexes to avoid page splits Peter Geoghegan 00:23
Re: Table AM modifications to accept column projection lists Zhihong Yu 00:34
[PATCH] Simple progress reporting for COPY command 📎 Josef Šimánek 01:25
Re: Tid scan improvements 📎 David Fetter 01:30
RE: Global snapshots [email protected] 03:14
RE: Disable WAL logging to speed up data loading [email protected] 03:27
RE: Disable WAL logging to speed up data loading [email protected] 03:51
Key management with tests Bruce Momjian 04:50
Safety/validity of resetting permissions by updating system tables Isaac Morland 05:51
Re: Key management with tests Bruce Momjian 06:07
Re: patch: reduce overhead of execution of CALL statement in no atomic mode from PL/pgSQL 📎 Pavel Stehule 08:15
Re: Asynchronous Append on postgres_fdw nodes. 📎 Etsuro Fujita 08:41
Re: proposal: schema variables 📎 Pavel Stehule 08:45
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit 📎 Bharath Rupireddy 10:03
Re: [PATCH] Simple progress reporting for COPY command Bharath Rupireddy 10:15
Re: [PATCH] Simplify permission checking logic in user.c Andrey Borodin 10:22
Re: poc - possibility to write window function in PL languages 📎 Pavel Stehule 11:28
Commitfest 2021-01 Now in Progress Masahiko Sawada 12:22
Re: [PATCH] Simple progress reporting for COPY command Josef Šimánek 13:00
Re: Let people set host(no)ssl settings from initdb Magnus Hagander 13:12
faster ETL / bulk data load for heap tables 📎 Luc Vlaming 14:06
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit Zhihong Yu 16:06
Re: Safety/validity of resetting permissions by updating system tables Tom Lane 16:44
Re: poc - possibility to write window function in PL languages Zhihong Yu 17:58
Re: Spurious "apparent wraparound" via SimpleLruTruncate() rounding Andrey Borodin 18:05
Re: Proposed patch for key management Alastair Turner 18:26
Re: faster ETL / bulk data load for heap tables Zhihong Yu 18:55
Move --data-checksums to common options in initdb --help 📎 Michael Banck 19:34
Re: Safety/validity of resetting permissions by updating system tables Isaac Morland 19:34
Re: Moving other hex functions to /common 📎 Bruce Momjian 20:06
Re: pgbench: option delaying queries till connections establishment? Fabien COELHO 20:15
Re: Spurious "apparent wraparound" via SimpleLruTruncate() rounding Noah Misch 20:35
Re: Implement <null treatment> for window functions 📎 Krasiyan Andreev 20:58
Re: Implement <null treatment> for window functions Zhihong Yu 21:21
Re: adding wait_start column to pg_locks Justin Pryzby 21:49

Jan. 2, 2021

Thread Author Time
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit 📎 Bharath Rupireddy 05:23
Re: Moving other hex functions to /common 📎 Michael Paquier 05:25
Re: Move --data-checksums to common options in initdb --help Michael Paquier 05:27
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit 📎 Bharath Rupireddy 05:49
Re: WIP: BRIN multi-range indexes Thomas Munro 06:42
Re: psql \df choose functions by their arguments Thomas Munro 06:55
Re: Spurious "apparent wraparound" via SimpleLruTruncate() rounding Andrey Borodin 07:31
Re: faster ETL / bulk data load for heap tables Amit Kapila 07:36
Re: Asynchronous Append on postgres_fdw nodes. Etsuro Fujita 08:15
Re: Proposed patch for key management Fabien COELHO 09:50
Re: pgbench: option delaying queries till connections establishment? 📎 Thomas Munro 09:50
Re: Spurious "apparent wraparound" via SimpleLruTruncate() rounding Noah Misch 10:00
Re: faster ETL / bulk data load for heap tables Luc Vlaming 10:04
Re: faster ETL / bulk data load for heap tables Luc Vlaming 10:09
Re: Proposed patch for key management Alastair Turner 12:47
Re: [HACKERS] [PATCH] Generic type subscripting 📎 Dmitry Dolgov 14:14
RE: [Patch] Optimize dropping of relation buffers using dlist [email protected] 14:17
Re: Move --data-checksums to common options in initdb --help Stephen Frost 15:47
Why latestRemovedXid|cuteoff_xid are always sent? Michail Nikolaev 16:00
Re: archive status ".ready" files may be created too early Andrey Borodin 16:54
Re: Reloptions for table access methods Jeff Davis 18:44
Re: pgbench: option delaying queries till connections establishment? Fabien COELHO 20:49
Re: WIP: BRIN multi-range indexes Tomas Vondra 22:56
Re: Why latestRemovedXid|cuteoff_xid are always sent? Peter Geoghegan 23:22

Jan. 3, 2021

Thread Author Time
Re: doc review for v14 Michael Paquier 06:10
Re: doc review for v14 Justin Pryzby 06:33
Re: Lazy JIT IR code generation to increase JIT speed with partitions Luc Vlaming 10:05
Re: Safety/validity of resetting permissions by updating system tables Simon Riggs 10:57
Re: pg_upgrade fails with non-standard ACL Noah Misch 11:29
Re: doc review for v14 Michael Paquier 12:05
LET clause Joel Jacobson 12:12
Re: LET clause Pavel Stehule 13:12
Re: [Patch] Optimize dropping of relation buffers using dlist Amit Kapila 13:34
Why not report ERROR when "concurrent insert in progress within table"? Meng Qingzhong 13:49
Re: Handing off SLRU fsyncs to the checkpointer Tomas Vondra 14:35
Re: Rethinking plpgsql's assignment implementation Pavel Stehule 15:25
Re: Safety/validity of resetting permissions by updating system tables Isaac Morland 16:32
Re: Rethinking plpgsql's assignment implementation Tom Lane 18:06
pg_rewind restore_command issue in PG12 Amine Tengilimoglu 18:13
Re: Rethinking plpgsql's assignment implementation Pavel Stehule 18:16
Re: Implement <null treatment> for window functions David Fetter 19:04
Re: [HACKERS] [PATCH] Generic type subscripting Pavel Stehule 19:41

Jan. 4, 2021

Thread Author Time
Re: [HACKERS] Custom compression methods Justin Pryzby 01:22
Re: zstd compression for pg_dump 📎 Justin Pryzby 02:53
Re: A failure of standby to follow timeline switch 📎 Kyotaro Horiguchi 03:06
RE: [Patch] Optimize dropping of relation buffers using dlist Tang, Haiying 03:31
Test harness for regex code (to allow importing Tcl's test suite) 📎 Tom Lane 03:49

Browse Archives

Prev | Next