pgsql-hackers - January 2021

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

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	tsunakawa.takay@fujitsu.com	03:14
RE: Disable WAL logging to speed up data loading	tsunakawa.takay@fujitsu.com	03:27
RE: Disable WAL logging to speed up data loading	tsunakawa.takay@fujitsu.com	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	k.jamison@fujitsu.com	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
pg_waldump/heapdesc.c and struct field names	Peter Geoghegan	03:54
Re: pg_waldump/heapdesc.c and struct field names	Masahiko Sawada	04:57
Re: faster ETL / bulk data load for heap tables	Amit Kapila	05:05
Re: pg_waldump/heapdesc.c and struct field names	Abhijit Menon-Sen	05:21
Re: Get memory contexts of an arbitrary backend process 📎	torikoshia	05:34
Re: Test harness for regex code (to allow importing Tcl's test suite)	Mark Dilger	05:37
Re: Test harness for regex code (to allow importing Tcl's test suite)	Tom Lane	05:47
Re: adding wait_start column to pg_locks 📎	torikoshia	06:04
Re: zstd compression for pg_dump	Andrey Borodin	06:04
Re: [HACKERS] Custom compression methods	Dilip Kumar	06:52
Re: zstd compression for pg_dump	Justin Pryzby	07:06
Re: New Table Access Methods for Multi and Single Inserts	Luc Vlaming	07:59
Re: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW	Luc Vlaming	08:04
Re: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW	Luc Vlaming	08:04
Re: [HACKERS] logical decoding of two-phase transactions	Amit Kapila	08:18
Re: Single transaction in the tablesync worker?	Amit Kapila	09:08
Re: Single transaction in the tablesync worker? 📎	Peter Smith	09:28
Re: Single transaction in the tablesync worker?	Peter Smith	09:33
Re: Parallel Inserts in CREATE TABLE AS	Bharath Rupireddy	09:35
Re: Parallel Inserts in CREATE TABLE AS	Bharath Rupireddy	09:36
Re: A failure of standby to follow timeline switch	Fujii Masao	10:00
Re: zstd compression for pg_dump	Daniil Zakhlystov	10:17
Re: Parallel Inserts in CREATE TABLE AS	Luc Vlaming	10:52
Re: {CREATE INDEX, REINDEX} CONCURRENTLY improvements	Masahiko Sawada	10:55
Re: poc - possibility to write window function in PL languages 📎	Pavel Stehule	11:14
RE: Parallel Inserts in CREATE TABLE AS	Hou, Zhijie	11:16
Re: [HACKERS] Custom compression methods 📎	Dilip Kumar	11:27
Re: Single transaction in the tablesync worker?	Amit Kapila	11:50
Re: [PATCH] Feature improvement for CLOSE, FETCH, MOVE tab completion	Masahiko Sawada	11:56
Re: Deleting older versions in unique indexes to avoid page splits	Heikki Linnakangas	12:08
Re: Parallel Inserts in CREATE TABLE AS	Luc Vlaming	12:14
Re: pg_rewind restore_command issue in PG12	Heikki Linnakangas	12:42
Re: Parallel Inserts in CREATE TABLE AS 📎	Bharath Rupireddy	12:47
[Bug Fix] Logical replication on partition table is very slow and CPU is 99% 📎	赵锐	13:04
Re: pg_rewind restore_command issue in PG12	Amine Tengilimoglu	13:12
Re: Test harness for regex code (to allow importing Tcl's test suite)	Joel Jacobson	13:30
Re: Parallel Inserts in CREATE TABLE AS	Bharath Rupireddy	13:32
Re: row filtering for logical replication 📎	Önder Kalacı	13:37
Re: Parallel Inserts in CREATE TABLE AS	Bharath Rupireddy	13:53
Re: [HACKERS] [PATCH] Generic type subscripting 📎	Dmitry Dolgov	14:00
Re: WIP: System Versioned Temporal Table	Masahiko Sawada	14:23
Re: libpq debug log	Masahiko Sawada	14:35
Re: VACUUM (DISABLE_PAGE_SKIPPING on)	Masahiko Sawada	14:45
Re: Safety/validity of resetting permissions by updating system tables	Andrew Dunstan	15:12
set_config() documentation clarification	Joel Jacobson	15:25
Re: PoC/WIP: Extended statistics on expressions	Dean Rasheed	15:34
Re: set_config() documentation clarification	Chapman Flack	15:41
Re: PoC/WIP: Extended statistics on expressions	Justin Pryzby	15:45
Re: Safety/validity of resetting permissions by updating system tables	Isaac Morland	16:15
Re: Deleting older versions in unique indexes to avoid page splits	Victor Yegorov	16:28
Re: set_config() documentation clarification	David G. Johnston	16:46
[PATCH]: Allow errors in parameter values to be reported during the BIND phase itself.. 📎	Justin Pryzby	17:09
Bug in numeric_power() if exponent is INT_MIN 📎	Dean Rasheed	17:24
Re: poc - possibility to write window function in PL languages	Zhihong Yu	17:38
Re: Proposed patch for key management	Bruce Momjian	17:54
Re: [HACKERS] [PATCH] Generic type subscripting	Pavel Stehule	17:56
Re: Proposed patch for key management	Bruce Momjian	17:56
Re: Bug in numeric_power() if exponent is INT_MIN	Tom Lane	17:59
data_checksums enabled by default (was: Move --data-checksums to common options in initdb --help)	Michael Banck	18:11
Re: Proposed patch for key management	Bruce Momjian	18:23
Context diffs	Bruce Momjian	19:07
Re: Context diffs	Tom Lane	19:42
Re: Context diffs	Peter Geoghegan	21:06
Re: pg_waldump/heapdesc.c and struct field names	Andres Freund	21:12
Re: pg_waldump/heapdesc.c and struct field names	Peter Geoghegan	21:56
Re: pg_waldump/heapdesc.c and struct field names	Peter Geoghegan	22:06
Re: Deleting older versions in unique indexes to avoid page splits 📎	Victor Yegorov	22:07
Re: Context diffs	Thomas Munro	22:21
Re: Handing off SLRU fsyncs to the checkpointer	Thomas Munro	22:44
Re: Online checksums patch - once again 📎	Daniel Gustafsson	23:18
Re: language cleanups in code and docs	Thomas Munro	23:42
Re: [PATCH] Simple progress reporting for COPY command	Tomas Vondra	23:45

Jan. 5, 2021

Thread	Author	Time
Fix typo in comment 📎	Peter Smith	00:06
Re: language cleanups in code and docs 📎	Dagfinn Ilmari Mannsåker	00:12
Re: language cleanups in code and docs	Thomas Munro	00:27
Adding new commitfest entry?	Peter Smith	00:33
Re: Adding new commitfest entry?	Tom Lane	00:36
Re: Adding new commitfest entry?	Peter Smith	00:40
Re: language cleanups in code and docs 📎	Dagfinn Ilmari Mannsåker	00:44
Re: PoC/WIP: Extended statistics on expressions	Tomas Vondra	00:45
Re: Adding new commitfest entry?	Tom Lane	00:45
fix typo in ReorderBufferProcessTXN 📎	Hou, Zhijie	00:54
Re: language cleanups in code and docs	Thomas Munro	01:01
Re: standby recovery fails (tablespace related) (tentative patch and discussion)	Kyotaro Horiguchi	01:07
Re: [PATCH] Simple progress reporting for COPY command 📎	Josef Šimánek	01:32
Re: New IndexAM API controlling index vacuum strategies 📎	Masahiko Sawada	01:35
Re: fix typo in ReorderBufferProcessTXN	Masahiko Sawada	01:42
Re: Adding new commitfest entry?	Masahiko Sawada	01:46
RE: Disable WAL logging to speed up data loading	osumi.takamichi@fujitsu.com	01:54
Re: fix typo in ReorderBufferProcessTXN	Amit Kapila	02:15
Re: Context diffs	Noah Misch	02:20
Re: Adding new commitfest entry?	Peter Smith	02:33
Re: Single transaction in the tablesync worker? 📎	Ajin Cherian	03:02
Re: fix typo in ReorderBufferProcessTXN	Amit Kapila	03:05
Re: Fix typo in comment	Amit Kapila	03:06
Re: Proposed patch for key management	Neil Chen	03:08
Re: pg_waldump/heapdesc.c and struct field names	Peter Geoghegan	03:46
Re: Moving other hex functions to /common 📎	Bruce Momjian	03:47
Re: macOS SIP, next try	Tom Lane	03:54
Cirrus CI (Windows help wanted)	Thomas Munro	03:58
Re: Parallel Inserts in CREATE TABLE AS 📎	Bharath Rupireddy	03:59
Re: macOS SIP, next try	Mark Dilger	04:03
Track replica origin progress for Rollback Prepared 📎	Amit Kapila	04:05
Re: list of extended statistics on psql 📎	Tatsuro Yamada	04:26
Re: Added missing copy related data structures to typedefs.list	vignesh C	04:29
Re: Parallel Inserts in CREATE TABLE AS	vignesh C	04:38
Re: Reducing WaitEventSet syscall churn 📎	Thomas Munro	05:10
RE: [PATCH] Feature improvement for CLOSE, FETCH, MOVE tab completion 📎	Shinya11.Kato	06:02
Re: [PATCH] LWLock self-deadlock detection	Craig Ringer	06:04
Re: [HACKERS] logical decoding of two-phase transactions	Amit Kapila	06:21
Re: Deadlock between backend and recovery may not be detected	Fujii Masao	06:26
Re: Moving other hex functions to /common	Michael Paquier	06:47
Re: Track replica origin progress for Rollback Prepared	Michael Paquier	07:02
Re: Parallel Inserts in CREATE TABLE AS	Luc Vlaming	07:13
Re: pg_rewind restore_command issue in PG12	Michael Paquier	07:17
Re: Parallel Inserts in CREATE TABLE AS	Luc Vlaming	07:30
Re: Moving other hex functions to /common	Thomas Munro	07:54
Re: Parallel Inserts in CREATE TABLE AS	Luc Vlaming	07:54

Browse Archives

Prev | Next