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

March 2, 2020

Thread	Author	Time
Re[4]: bool_plperl transform 📎	Ivan Panchenko	00:01
Re: Ought to use heap_multi_insert() for pg_attribute/depend insertions?	Michael Paquier	02:06
Re: ALTER tbl rewrite loses CLUSTER ON index	Michael Paquier	03:28
Re: logical replication empty transactions	Dilip Kumar	03:30
Re: [PATCH] Add schema and table names to partition error	Amit Langote	04:09
Re: [Patch] pg_rewind: options to use restore_command from recovery.conf or command line	Michael Paquier	04:53
Re: partition routing layering in nodeModifyTable.c 📎	Amit Langote	05:08
effective_io_concurrency's steampunk spindle maths	Thomas Munro	05:28
Re: [PATCH v1] Allow COPY "text" to output a header and add header matching mode to COPY FROM	Surafel Temesgen	05:39
Re: WIP: WAL prefetch (another approach) 📎	Thomas Munro	05:43
Re: ERROR: subtransaction logged without previous top-level txn record	Amit Kapila	06:26
Re: BUG #16108: Colorization to the output of command-line has unproperly behaviors at Windows platform	Michael Paquier	06:48
Re: ERROR: subtransaction logged without previous top-level txn record	Arseny Sher	07:41
Re: more ALTER .. DEPENDS ON EXTENSION fixes	Ahsan Hadi	07:45
Re: [BUG?] postgres_fdw incorrectly updates remote table if it has inherited children.	Etsuro Fujita	07:49
Re: [HACKERS] WAL logging problem in 9.4.3?	Kyotaro Horiguchi	07:53
Re: Cleanup - Removal of apply_typmod function in #if 0	Peter Eisentraut	07:57
Re: Trying to pull up EXPR SubLinks	Richard Guo	08:21
Re: pg_stat_progress_basebackup - progress reporting for pg_basebackup, in the server side 📎	Fujii Masao	08:29
Re: Planning counters in pg_stat_statements (using pgss_store)	Julien Rouhaud	08:54
Re: BUG #16108: Colorization to the output of command-line has unproperly behaviors at Windows platform	Juan José Santamaría Flecha	09:01
Re: Allow to_date() and to_timestamp() to accept localized names	Juan José Santamaría Flecha	09:10
Re: Cleanup - Removal of apply_typmod function in #if 0	vignesh C	09:18
Re: ERROR: subtransaction logged without previous top-level txn record	Amit Kapila	10:14
Re: pg_stat_progress_basebackup - progress reporting for pg_basebackup, in the server side	Sergei Kornilov	10:27
Re: [PATCH] Add schema and table names to partition error	Amit Kapila	11:00
Re: logical replication empty transactions	Amit Kapila	11:26
Re: Crash by targetted recovery	Fujii Masao	11:54
Re: color by default	Juan José Santamaría Flecha	12:00
Re: Planning counters in pg_stat_statements (using pgss_store)	legrand legrand	12:01
Re: Planning counters in pg_stat_statements (using pgss_store)	Julien Rouhaud	12:14
Re: [BUG?] postgres_fdw incorrectly updates remote table if it has inherited children.	Kohei KaiGai	12:25
Re: Change atoi to strtol in same place	Daniel Gustafsson	12:32
Re: Do we need to handle orphaned prepared transactions in the server? 📎	Hamid Akhtar	12:42
Re: Minor issues in .pgpass	Fujii Masao	13:07
Silence compiler warnings with Python 3.9 📎	Peter Eisentraut	13:22
Re: Psql patch to show access methods info	David Steele	13:33
Re: ERROR: subtransaction logged without previous top-level txn record	Arseny Sher	13:37
Re: doc: vacuum full, fillfactor, and "extra space"	David Steele	13:40
Re: Berserk Autovacuum (let's save next Mandrill)	Laurenz Albe	13:57
Re: Fastpath while arranging the changes in LSN order in logical decoding	David Steele	13:57
Re: [Proposal] Global temporary tables	tushar	14:47
Re: Auxiliary Processes and MyAuxProc 📎	Mike Palmiotto	14:53
Re: [PATCH] Replica sends an incorrect epoch in its hot standby feedback to the Master	Juan José Santamaría Flecha	15:33
Re: Portal->commandTag as an enum	Alvaro Herrera	16:12
Re: Portal->commandTag as an enum	Mark Dilger	16:19
Re: Portal->commandTag as an enum	Alvaro Herrera	16:33
Re: Portal->commandTag as an enum 📎	Alvaro Herrera	16:53
Re: Portal->commandTag as an enum	Alvaro Herrera	17:08
Re: Portal->commandTag as an enum	Mark Dilger	17:17
Re: [PATCH] Erase the distinctClause if the result is unique by definition	Andy Fan	17:24
Re: [Patch] pg_rewind: options to use restore_command from recovery.conf or command line	Alexey Kondratov	17:59
[PATCH] Documentation bug related to client authentication using TLS certificate 📎	Cary Huang	19:06
Re: Allowing ALTER TYPE to change storage strategy 📎	Tom Lane	19:11
Re: [PATCH] Erase the distinctClause if the result is unique by definition	Andy Fan	20:25
Re: Use compiler intrinsics for bit ops in hash 📎	Jesse Zhang	20:45
Re: [PATCH] kNN for btree 📎	Alexander Korotkov	21:26
Re: Portal->commandTag as an enum	Alvaro Herrera	21:57
Re: Allowing ALTER TYPE to change storage strategy	Tomas Vondra	22:05
Re: Portal->commandTag as an enum	Mark Dilger	22:30
Re: SQL/JSON: functions 📎	Nikita Glukhov	22:33
Symbolic names for the values of typalign and typstorage 📎	Tom Lane	22:52
Re: SQL/JSON: functions	Erik Rijkers	23:12
Re: SQL/JSON: functions 📎	Nikita Glukhov	23:24
Re: Improving connection scalability: GetSnapshotData() 📎	Andres Freund	23:24
Re: Internal key management system	Cary Huang	23:48

March 3, 2020

Thread	Author	Time
Re: Improve search for missing parent downlinks in amcheck	Peter Geoghegan	00:03
Re: Some improvements to numeric sqrt() and ln() 📎	Tels	00:17
Re: pg_stat_progress_basebackup - progress reporting for pg_basebackup, in the server side	Kyotaro Horiguchi	00:27
Re: ALTER tbl rewrite loses CLUSTER ON index	Michael Paquier	01:14
Re: Delaying/avoiding BTreeTupleGetNAtts() call within _bt_compare() 📎	Peter Geoghegan	01:29
Re: Symbolic names for the values of typalign and typstorage	Alvaro Herrera	01:31
Re: ALTER tbl rewrite loses CLUSTER ON index	Justin Pryzby	01:31
Re: ALTER tbl rewrite loses CLUSTER ON index 📎	Justin Pryzby	01:36
Re: SQL/JSON: functions	Erik Rijkers	01:48
Re: Add LogicalTapeSetExtend() to logtape.c	Adam Lee	01:49
Re: pg_stat_progress_basebackup - progress reporting for pg_basebackup, in the server side	Fujii Masao	03:08
Re: pg_stat_progress_basebackup - progress reporting for pg_basebackup, in the server side	Fujii Masao	03:09
Re: Fastpath while arranging the changes in LSN order in logical decoding	Dilip Kumar	03:12
Re: Symbolic names for the values of typalign and typstorage	Tom Lane	03:22
Re: [PATCH] Documentation bug related to client authentication using TLS certificate	Chris Bandy	03:23
Re: First WAL segment file that initdb creates	Fujii Masao	03:29
Re: logical replication empty transactions	Dilip Kumar	04:05
Re: [PATCH] Add schema and table names to partition error 📎	Chris Bandy	04:35
Re: Fastpath while arranging the changes in LSN order in logical decoding 📎	Dilip Kumar	05:11
Re: Fastpath while arranging the changes in LSN order in logical decoding	Dilip Kumar	05:11
Re: color by default	Michael Paquier	05:31
RE: pg_stat_progress_basebackup - progress reporting for pg_basebackup, in the server side 📎	Shinoda, Noriyoshi (PN Japan A&PS Delivery)	05:37
Re: Parallel copy	vignesh C	05:55
Re: pg_stat_progress_basebackup - progress reporting for pg_basebackup, in the server side	Fujii Masao	06:03
Re: Parallel copy	vignesh C	06:14
Re: reindex concurrently and two toast indexes 📎	Michael Paquier	08:06
Re: logical replication empty transactions	Amit Kapila	08:24
Re: [Proposal] Global temporary tables	曾文旌 (义从)	08:40
Re: logical replication empty transactions	Dilip Kumar	08:47
Re: Internal key management system 📎	Masahiko Sawada	08:58
Re: reindex concurrently and two toast indexes 📎	Michael Paquier	09:25
Re: logical replication empty transactions	Amit Kapila	10:04
[GSoC 2020] Questions About Performance Farm Benchmarks and Website	Kalvin Eng	10:07
Re: ERROR: subtransaction logged without previous top-level txn record	Amit Kapila	10:26
Re: backup manifests	tushar	10:34
Re: Minor issues in .pgpass	Hamid Akhtar	12:38
Re: [PATCH] Replica sends an incorrect epoch in its hot standby feedback to the Master	David Steele	13:02
Re: error context for vacuum to include block number	Masahiko Sawada	13:05
Re: Minor issues in .pgpass	Hamid Akhtar	13:07
Re: Some improvements to numeric sqrt() and ln()	Dean Rasheed	13:42
Re: Identifying user-created objects	vignesh C	14:33
Re: backup manifests	tushar	14:49
Re: Symbolic names for the values of typalign and typstorage	Tom Lane	15:11
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? 📎	Julien Rouhaud	15:24
Re: Berserk Autovacuum (let's save next Mandrill) 📎	Laurenz Albe	15:28
Re: Minor issues in .pgpass	Fujii Masao	15:57
Re: [PATCH] Add schema and table names to partition error	Alvaro Herrera	16:08
Re: Allow to_date() and to_timestamp() to accept localized names	Tom Lane	16:09
Re: Add LogicalTapeSetExtend() to logtape.c	Jeff Davis	16:46
Re: [HACKERS] advanced partition matching algorithm for partition-wise join 📎	Ashutosh Bapat	16:48
Re: [GSoC 2020] Questions About Performance Farm Benchmarks and Website	Mark Wong	16:54
Is it time to retire type "opaque"?	Tom Lane	17:10
Re: [PATCH] Incremental sort	David Steele	17:17
Re: row filtering for logical replication	David Steele	17:39
Setting ACL	Vik Fearing	17:48
Re: [HACKERS] [PATCH] Generic type subscripting	David Steele	17:55
Re: Setting ACL	Tom Lane	18:02
PG14 target version?	David Steele	18:10
Re: Setting ACL	Vik Fearing	18:13
Re: Setting ACL	Tom Lane	18:25
Re: Symbolic names for the values of typalign and typstorage	Alvaro Herrera	18:29
Re: WIP: System Versioned Temporal Table	David Steele	18:33
Re: Symbolic names for the values of typalign and typstorage	Tom Lane	18:35
Re: [PATCH] Incremental sort	Tomas Vondra	18:43
Re: WIP: System Versioned Temporal Table	Vik Fearing	18:45
Re: Option to dump foreign data in pg_dump	David Steele	19:11
Re: error context for vacuum to include block number 📎	Justin Pryzby	19:32
Re: [PATCH] Documentation bug related to client authentication using TLS certificate	Cary Huang	19:36
Re: error context for vacuum to include block number	Alvaro Herrera	19:49
Re: [PATCH v1] pg_ls_tmpdir to show directories	David Steele	19:51
Re: [PATCH v1] pg_ls_tmpdir to show directories	Justin Pryzby	20:01
Re: WIP: expression evaluation improvements 📎	Soumyadeep Chakraborty	20:21
Re: [PATCH v1] pg_ls_tmpdir to show directories	Alvaro Herrera	20:23
Re: [PATCH v1] pg_ls_tmpdir to show directories	Bossart, Nathan	20:35
Re: Fastpath while arranging the changes in LSN order in logical decoding	David Zhang	21:32
Re: Symbolic names for the values of typalign and typstorage 📎	Tom Lane	21:45
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Tomas Vondra	21:46
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎	Tomas Vondra	21:59
Re: Index Skip Scan	David Rowley	22:32
Back-patching -Wno-format-truncation. 📎	Kyotaro Horiguchi	23:12
Re: Psql patch to show access methods info 📎	Alexander Korotkov	23:31
Cast to uint16 in pg_checksum_page() 📎	David Steele	23:37
Re: Is it time to retire type "opaque"? 📎	Tom Lane	23:39
Re: Back-patching -Wno-format-truncation.	Tom Lane	23:44

March 4, 2020

Thread	Author	Time
Re: Back-patching -Wno-format-truncation.	Kyotaro Horiguchi	00:12
Re: logical replication empty transactions	Euler Taveira	01:47
Re: [PATCH] kNN for btree	Peter Geoghegan	01:58
Re: Some problems of recovery conflict wait events	Fujii Masao	02:04
Re: range_agg 📎	Alvaro Herrera	02:28
Re: New SQL counter statistics view (pg_stat_sql)	Alvaro Herrera	02:50
Re: Psql patch to show access methods info	Alvaro Herrera	02:59
Re: Fastpath while arranging the changes in LSN order in logical decoding	Dilip Kumar	03:03
Re: Identifying user-created objects	Masahiko Sawada	03:31
Re: logical replication empty transactions	Amit Kapila	03:42
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Dilip Kumar	03:43
Re: Add LogicalTapeSetExtend() to logtape.c	Adam Lee	03:57
Re: Some problems of recovery conflict wait events	Masahiko Sawada	04:13
Re: logical replication empty transactions	Dilip Kumar	04:21
Re: Some problems of recovery conflict wait events	Michael Paquier	04:27
Re: Cast to uint16 in pg_checksum_page()	Michael Paquier	04:41
Re: Some problems of recovery conflict wait events	Fujii Masao	04:48
Re: Auxiliary Processes and MyAuxProc 📎	Mike Palmiotto	04:56
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Amit Kapila	04:58
Re: reindex concurrently and two toast indexes 📎	Michael Paquier	05:15
Re: [PATCH] Add schema and table names to partition error 📎	Chris Bandy	05:18
Re: logical replication empty transactions	Amit Kapila	05:19
Re: [PATCH] Add schema and table names to partition error	Amit Kapila	05:22
Re: Symbolic names for the values of typalign and typstorage	Michael Paquier	05:25
Re: PG14 target version?	Michael Paquier	05:28
Re: Some problems of recovery conflict wait events 📎	Masahiko Sawada	05:31
Re: Unicode escapes with any backend encoding	John Naylor	05:32
Re: logical replication empty transactions	Dilip Kumar	05:45
Re: Cast to uint16 in pg_checksum_page()	Tom Lane	06:05
Re: [HACKERS] Moving relation extension locks out of heavyweight lock manager 📎	Mahendra Singh Thalor	06:15
Re: Some problems of recovery conflict wait events	Fujii Masao	06:21
Re: Identifying user-created objects	vignesh C	06:28
Re: [HACKERS] Moving relation extension locks out of heavyweight lock manager	Dilip Kumar	06:32
Re: error context for vacuum to include block number	Masahiko Sawada	07:21
Re: [HACKERS] WAL logging problem in 9.4.3? 📎	Kyotaro Horiguchi	07:29
Re: Identifying user-created objects	Fujii Masao	07:43
Re: [HACKERS] WAL logging problem in 9.4.3?	Kyotaro Horiguchi	07:44
Re: [Patch] pg_rewind: options to use restore_command from recovery.conf or command line 📎	Michael Paquier	07:45
Re: [Proposal] Global temporary tables	Prabhat Sahu	07:49
PG_COLOR not mentioned in docs of vacuumlo, oid2name and pgbench 📎	Michael Paquier	07:54
Re: Identifying user-created objects	Masahiko Sawada	08:05
Re: reindex concurrently and two toast indexes	Julien Rouhaud	08:21
Re: [PATCH] Add object names to partition errors 📎	Chris Bandy	08:54
Re: Use compiler intrinsics for bit ops in hash	John Naylor	08:59
Re: Collation versioning 📎	Julien Rouhaud	09:01
Re: Identifying user-created objects	Fujii Masao	09:02
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Amit Kapila	09:03
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Dilip Kumar	09:10
Re: PG_COLOR not mentioned in docs of vacuumlo, oid2name and pgbench	Daniel Gustafsson	09:12
Re: PG14 target version?	Daniel Gustafsson	09:14

Browse Archives

Prev | Next