pgsql-hackers since 2020-03-01 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 1, 2020

Thread Author Time
Re: TRUNCATE on foreign tables 📎 Kohei KaiGai 02:24
Re: Auxiliary Processes and MyAuxProc 📎 Mike Palmiotto 02:51
[BUG?] postgres_fdw incorrectly updates remote table if it has inherited children. Kohei KaiGai 02:59
Re: [BUG?] postgres_fdw incorrectly updates remote table if it has inherited children. Amit Langote 03:38
Re: [PATCH] Add schema and table names to partition error Amit Langote 04:40
Re: [BUG?] postgres_fdw incorrectly updates remote table if it has inherited children. Kohei KaiGai 04:46
Re: bool_plperl transform Andrew Dunstan 04:57
Re: [PATCH] distinct aggregates within a window function WIP 📎 Krasiyan Andreev 06:32
Re[2]: bool_plperl transform 📎 Wao 08:02
Improving connection scalability: GetSnapshotData() 📎 Andres Freund 08:36
Re: Improving connection scalability: GetSnapshotData() 📎 Andres Freund 08:46
proposal - reglanguage type 📎 Pavel Stehule 10:07
Re: Yet another fast GiST build Darafei Komяpa Praliaskouski 10:09
Re: Improving connection scalability: GetSnapshotData() Amit Kapila 10:55
Re: [PATCH] Add schema and table names to partition error Amit Kapila 11:14
Re[2]: bool_plperl transform Ivan Panchenko 11:14
Re: proposal \gcsv 📎 Pavel Stehule 12:29
Re: proposal \gcsv Pavel Stehule 12:34
Re: Broken resetting of subplan hash tables Ranier Vilela 12:52
Re: Planning counters in pg_stat_statements (using pgss_store) Julien Rouhaud 14:05
Re: d25ea01275 and partitionwise join 📎 Amit Langote 14:21
Re: proposal \gcsv Vik Fearing 14:49
Re: Planning counters in pg_stat_statements (using pgss_store) legrand legrand 14:55
Re: explain HashAggregate to report bucket and memory stats 📎 Justin Pryzby 15:45
Re: proposal - reglanguage type Tom Lane 18:31
Re: proposal - reglanguage type Pavel Stehule 18:38
Re: [PATCH] Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT Tom Lane 18:39
Re: [HACKERS] Cached plans and statement generalization Tom Lane 19:26
Re: Delaying/avoiding BTreeTupleGetNAtts() call within _bt_compare() Tom Lane 19:41
Re: partition routing layering in nodeModifyTable.c Tom Lane 19:42
Re: Some improvements to numeric sqrt() and ln() 📎 Dean Rasheed 19:47
Re: [HACKERS] WAL logging problem in 9.4.3? 📎 Noah Misch 19:56
RE: Delaying/avoiding BTreeTupleGetNAtts() call within _bt_compare() 📎 Floris Van Nee 20:15
Re: [PATCH] Erase the distinctClause if the result is unique by definition Tom Lane 20:46
Commitfest 2020-03 Now in Progress David Steele 21:10
Re: Re[2]: bool_plperl transform Tom Lane 21:13
Re: pgbench: option delaying queries till connections establishment? 📎 Fabien COELHO 21:16
Re: Commitfest 2020-03 Now in Progress Tom Lane 21:16
Re: bool_plperl transform Dagfinn Ilmari Mannsåker 22:09
Re: Allow to_date() and to_timestamp() to accept localized names 📎 Tom Lane 22:25
Re: Remove win32ver.rc from version_stamp.pl Tom Lane 22:51
Re[2]: bool_plperl transform Ivan Panchenko 23:30
Re: [PATCH v1] Allow COPY "text" to output a header and add header matching mode to COPY FROM Rémi Lapeyre 23:45
Re: [PATCH] Add schema and table names to partition error 📎 Chris Bandy 23:51

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

Browse Archives

Prev | Next