pgsql-hackers before 2020-12-31 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. 26, 2020

Thread	Author	Time
Re: SQL/JSON: JSON_TABLE	Zhihong Yu	22:16

Dec. 27, 2020

Thread	Author	Time
Re: pgsql: Add pg_alterckey utility to change the cluster key	Michael Paquier	01:11
Wrong comment in tuptable.h	Jeff Davis	02:00
Re: Wrong comment in tuptable.h	Andres Freund	03:43
Re: pgsql: Add pg_alterckey utility to change the cluster key	Bruce Momjian	04:17
possible replacement for llvm JIT	Pavel Stehule	05:54
Re: [HACKERS] Custom compression methods 📎	Andrey Borodin	07:10
Re: pg_stat_statements oddity with track = all 📎	Julien Rouhaud	08:38
Re: pgsql: Add pg_alterckey utility to change the cluster key	Michael Paquier	08:48
Re: Parallel Inserts in CREATE TABLE AS 📎	Bharath Rupireddy	08:50
Re: Parallel Inserts in CREATE TABLE AS	Bharath Rupireddy	08:57
Re: range_agg 📎	Alexander Korotkov	09:50
Re: Add table access method as an option to pgbench 📎	Fabien COELHO	13:14
Re: Add session statistics to pg_stat_database	Laurenz Albe	15:16
Re: PoC Refactor AM analyse API	Andrey Borodin	17:11
Re: Proposed patch for key managment	Bruce Momjian	17:25
Re: Add table access method as an option to pgbench	Justin Pryzby	17:39
Re: pgsql: Add pg_alterckey utility to change the cluster key	Bruce Momjian	17:44
Re: range_agg	Zhihong Yu	17:53
Re: range_agg	David Fetter	18:07
Re: pg_upgrade test for binary compatibility of core data types 📎	Justin Pryzby	19:07
Re: range_agg	Alexander Korotkov	19:31
Re: range_agg	Alexander Korotkov	19:38
Re: Parallel Inserts in CREATE TABLE AS	Zhihong Yu	19:47
hash_extension(text)	Joel Jacobson	20:02
vacuum_cost_page_miss default value and modern hardware	Peter Geoghegan	20:16
Re: doc review for v14 📎	Justin Pryzby	20:26
Re: Feature request: Connection string parsing for postgres_fdw	Eric Hanson	22:59
Re: Rethinking plpgsql's assignment implementation	Pavel Stehule	23:08
Re: Rethinking plpgsql's assignment implementation	Tom Lane	23:54

Dec. 28, 2020

Thread	Author	Time
Re: pgsql: Add pg_alterckey utility to change the cluster key	Bruce Momjian	02:43
Re: Cache relation sizes?	Andy Fan	04:24
Tying an object's ownership to datdba 📎	Noah Misch	04:31
Re: Parallel Inserts in CREATE TABLE AS	Dilip Kumar	05:15
Re: [HACKERS] Custom compression methods	Dilip Kumar	05:20
Re: Rethinking plpgsql's assignment implementation	Pavel Stehule	05:28
Re: Disable WAL logging to speed up data loading	Masahiko Sawada	05:28
Re: Parallel Inserts in CREATE TABLE AS	vignesh C	05:54
Re: [HACKERS] Custom compression methods	Andrey Borodin	06:14
Re: New IndexAM API controlling index vacuum strategies	Masahiko Sawada	06:54
RE: Disable WAL logging to speed up data loading	[email protected]	07:29
Re: New IndexAM API controlling index vacuum strategies	Peter Geoghegan	07:41
RE: [Patch] Optimize dropping of relation buffers using dlist	Tang, Haiying	08:15
Re: Add table AM 'tid_visible'	Masahiko Sawada	08:43
Lazy JIT IR code generation to increase JIT speed with partitions 📎	Luc Vlaming	08:44
Re: Parallel Full Hash Join	Masahiko Sawada	08:48
Re: [PATCH] TAP test showing that pg_replication_slot_advance() works on standby	Masahiko Sawada	08:53
RE: [HACKERS] logical decoding of two-phase transactions	[email protected]	08:57
Re: Parallel copy 📎	vignesh C	09:44
Re: pgsql: Fix memory leak in plpgsql's CALL processing.	Peter Eisentraut	09:47
Re: Disable WAL logging to speed up data loading	Masahiko Sawada	10:11
Re: PATCH: Report libpq version and configuration	Masahiko Sawada	10:14
Re: Table AM modifications to accept column projection lists	Masahiko Sawada	10:29
Re: doc review for v14	Magnus Hagander	10:42
Re: [doc] adding way to examine the plan type of prepared statements	Masahiko Sawada	10:47
Re: postgres_fdw - cached connection leaks if the associated user mapping/foreign server is dropped	Fujii Masao	11:05
Re: Disable WAL logging to speed up data loading	Simon Riggs	11:06
Re: Rename of triggers for partitioned tables	Masahiko Sawada	11:33
Re: [Doc Patch] Clarify that CREATEROLE roles can GRANT default roles	Masahiko Sawada	11:41
Re: OpenSSL connection setup debug callback issue	Masahiko Sawada	12:04
Re: [PATCH] Identify LWLocks in tracepoints	Masahiko Sawada	12:09
Re: Parallel Inserts in CREATE TABLE AS 📎	Bharath Rupireddy	12:12
Re: Parallel Inserts in CREATE TABLE AS	Bharath Rupireddy	12:14
Re: Parallel Inserts in CREATE TABLE AS	Bharath Rupireddy	12:15
Re: On login trigger: take three	Masahiko Sawada	12:15
Re: EXPLAIN/EXPLAIN ANALYZE REFRESH MATERIALIZED VIEW 📎	Bharath Rupireddy	12:26
Re: New Table Access Methods for Multi and Single Inserts	Bharath Rupireddy	12:48
Re: a misbehavior of partition row movement (?)	Arne Roland	13:01
Re: pgsql: Add pg_alterckey utility to change the cluster key	Andrew Dunstan	13:49
Re: pgsql: Add pg_alterckey utility to change the cluster key	Fabien COELHO	14:09
Re: Transactions involving multiple postgres foreign servers, take 2 📎	Masahiko Sawada	14:24
Re: pgsql: Fix memory leak in plpgsql's CALL processing.	Tom Lane	15:11
Re: pgsql: Add pg_alterckey utility to change the cluster key	Bruce Momjian	15:34
Re: pgsql: Add pg_alterckey utility to change the cluster key	Bruce Momjian	15:39
Re: pgsql: Fix memory leak in plpgsql's CALL processing.	Tom Lane	16:42
Re: Better client reporting for "immediate stop" shutdowns 📎	Tom Lane	18:25
Re: Better client reporting for "immediate stop" shutdowns	Andres Freund	19:14
Re: Better client reporting for "immediate stop" shutdowns	Tom Lane	20:01
trailing junk in numeric literals	Peter Eisentraut	20:22
Re: trailing junk in numeric literals	Tom Lane	20:54
Re: New IndexAM API controlling index vacuum strategies 📎	Peter Geoghegan	22:06
Re: Proposed patch for key managment	Fabien COELHO	22:15

Dec. 29, 2020

Thread	Author	Time
Re: doc review for v14	Michael Paquier	00:37
Re: doc review for v14	Thomas Munro	00:59
Re: Parallel Full Hash Join 📎	Thomas Munro	02:28
Let's start using setenv() 📎	Tom Lane	03:20
Re: Let's start using setenv()	Thomas Munro	04:32
Re: Let's start using setenv()	Tom Lane	05:21
Re: HOT chain bug in latestRemovedXid calculation 📎	Peter Geoghegan	05:49
Re: New IndexAM API controlling index vacuum strategies 📎	Masahiko Sawada	06:18
Re: New IndexAM API controlling index vacuum strategies	Masahiko Sawada	06:25
Re: New IndexAM API controlling index vacuum strategies	Peter Geoghegan	07:20
Re: Detecting File Damage & Inconsistencies	Masahiko Sawada	07:40
Re: VACUUM (DISABLE_PAGE_SKIPPING on)	Masahiko Sawada	07:42
Re: New IndexAM API controlling index vacuum strategies	Peter Geoghegan	07:51
Re: [HACKERS] logical decoding of two-phase transactions	Masahiko Sawada	07:53
Re: doc review for v14	Michael Paquier	07:57
Re: Double partition lock in bufmgr	Masahiko Sawada	07:59
Re: row filtering for logical replication	Masahiko Sawada	08:08
Re: OpenSSL connection setup debug callback issue	Daniel Gustafsson	09:18
Re: trailing junk in numeric literals	Peter Eisentraut	09:18
Re: doc review for v14	Michael Paquier	09:22
Weird failure in explain.out with OpenBSD	Michael Paquier	09:26
Re: [HACKERS] logical decoding of two-phase transactions 📎	Ajin Cherian	09:45
Re: trailing junk in numeric literals	Fabien COELHO	10:24
Re: doc review for v14	Magnus Hagander	10:37
RE: [POC] Fast COPY FROM command for the table with foreign partitions	Hou, Zhijie	11:20
Dump public schema ownership & seclabels 📎	Noah Misch	13:49
Re: doc review for v14	Tom Lane	14:36
回复：Re: Re: Cache relation sizes?	陈佳昕 (步真)	15:13
Re: Weird failure in explain.out with OpenBSD	Tom Lane	15:20
Re: Let's start using setenv() 📎	Tom Lane	16:45
Re: [HACKERS] Custom compression methods 📎	Andrey Borodin	17:48
[PATCH] Simplify permission checking logic in user.c 📎	Paul Martinez	20:26
Re: Let's start using setenv()	Thomas Munro	20:34
Re: Reduce the number of special cases to build contrib modules on windows 📎	David Rowley	21:03
Re: Reduce the number of special cases to build contrib modules on windows 📎	David Rowley	21:07
Re: Weird failure in explain.out with OpenBSD	Tom Lane	21:16
Re: Let's start using setenv()	Tom Lane	21:25
Re: Cleanup some -I$(libpq_srcdir) in makefiles	David Rowley	21:54
Re: Cleanup some -I$(libpq_srcdir) in makefiles	Tom Lane	22:06
Re: Better client reporting for "immediate stop" shutdowns	Tom Lane	23:05
Re: create table like: ACCESS METHOD 📎	Justin Pryzby	23:08
Re: Parallel Inserts in CREATE TABLE AS	Zhihong Yu	23:53

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

Browse Archives

Prev | Next