pgsql-hackers since 2020-08-16 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

Aug. 16, 2020

Thread Author Time
Re: Improving connection scalability: GetSnapshotData() Andres Freund 18:16
Re: Improving connection scalability: GetSnapshotData() Tom Lane 18:30
Re: Improving connection scalability: GetSnapshotData() Andres Freund 19:00
Re: range_agg 📎 Paul A Jungwirth 19:55
Re: Improving connection scalability: GetSnapshotData() 📎 Tom Lane 20:17
Re: Improving connection scalability: GetSnapshotData() Andres Freund 20:31
Re: Improving connection scalability: GetSnapshotData() Andres Freund 20:52
Re: Improving connection scalability: GetSnapshotData() Andres Freund 21:11
Re: Improving connection scalability: GetSnapshotData() Andres Freund 21:26
Re: Improving connection scalability: GetSnapshotData() Peter Geoghegan 21:28
Re: Improving connection scalability: GetSnapshotData() Tom Lane 21:28
Re: Improving connection scalability: GetSnapshotData() Andres Freund 21:30

Aug. 17, 2020

Thread Author Time
One-off failure in "cluster" test Thomas Munro 01:03
Re: One-off failure in "cluster" test Tom Lane 01:20
Re: One-off failure in "cluster" test Thomas Munro 01:27
Re: Fix an old description in high-availability.sgml Michael Paquier 01:32
Re: One-off failure in "cluster" test 📎 Thomas Munro 02:51
Re: OpenSSL 3.0.0 compatibility Michael Paquier 04:12
Re: Parallel copy Greg Nancarrow 04:14
Re: new heapcheck contrib module Amul Sul 04:37
Re: tab completion of IMPORT FOREIGN SCHEMA Michael Paquier 05:15
Re: Fix an old description in high-availability.sgml Masahiko Sawada 05:29
Re: Display individual query in pg_stat_activity 📎 Drouvot, Bertrand 05:49
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma 06:05
Re: display offset along with block number in vacuum errors Masahiko Sawada 06:07
Re: Autovacuum on partitioned table (autoanalyze) 📎 yuzuko 06:11
proposal: enhancing plpgsql debug API - returns text value of variable content Pavel Stehule 06:40
proposal - reference to plpgsql_check from plpgsql doc Pavel Stehule 06:46
Re: More tests with USING INDEX replident and dropped indexes 📎 Michael Paquier 06:59
Re: Commit/abort WAL records with dropped rels missing XLR_SPECIAL_REL_UPDATE Michael Paquier 07:00
Re: Newline after --progress report Heikki Linnakangas 07:14
Re: Commit/abort WAL records with dropped rels missing XLR_SPECIAL_REL_UPDATE Heikki Linnakangas 07:55
Making the function range_union_internal available to other extensions Esteban Zimanyi 08:14
Re: proposal - reference to plpgsql_check from plpgsql doc Magnus Hagander 08:36
Re: proposal - reference to plpgsql_check from plpgsql doc Pavel Stehule 09:03
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits Hamid Akhtar 09:18
Re: track_planning causing performance regression Fujii Masao 09:21
Re: track_planning causing performance regression Hamid Akhtar 09:34
Re: EDB builds Postgres 13 with an obsolete ICU version Magnus Hagander 10:19
Optimising compactify_tuples() 📎 Thomas Munro 11:00
Re: Corruption during WAL replay Heikki Linnakangas 11:05
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits 📎 Ibrar Ahmed 11:26
Re: EDB builds Postgres 13 with an obsolete ICU version Dave Page 11:44
BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails PG Bug reporting form 12:02
Re: Creating a function for exposing memory usage of backend process Fujii Masao 12:14
Re: Creating a function for exposing memory usage of backend process Fujii Masao 12:19
Re: track_planning causing performance regression Fujii Masao 12:30
Re: Add header support to text format and matching feature 📎 vignesh C 12:49
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎 Dilip Kumar 12:58
Re: Terminate the idle sessions Bharath Rupireddy 13:58
Re: Newline after --progress report Tom Lane 13:59
Re: Is it useful to record whether plans are generic or custom? Fujii Masao 14:00
Re: jsonb, collection & postgres_fdw Bharath Rupireddy 14:02
Re: Parallel bitmap index scan Bharath Rupireddy 14:11
Re: Improve planner cost estimations for alternative subplans 📎 Andy Fan 14:12
Re: Parallel bitmap index scan Dilip Kumar 14:18
Re: Newline after --progress report Heikki Linnakangas 14:20
Re: One-off failure in "cluster" test Tom Lane 14:50
Re: EDB builds Postgres 13 with an obsolete ICU version Magnus Hagander 15:14
Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails Tom Lane 15:26
Re: Add information to rm_redo_error_callback() Drouvot, Bertrand 15:47
Re: EDB builds Postgres 13 with an obsolete ICU version Dave Page 15:55
Re: [PATCH] Covering SPGiST index 📎 Pavel Borisov 16:04
RE: Is it useful to record whether plans are generic or custom? legrand legrand 16:35
Re: Add information to rm_redo_error_callback() Alvaro Herrera 17:39
Re: Include access method in listTables output 📎 vignesh C 17:40
Re: run pgindent on a regular basis / scripted manner Bruce Momjian 17:54
Re: run pgindent on a regular basis / scripted manner Andres Freund 18:05
Re: run pgindent on a regular basis / scripted manner Tom Lane 18:05
Re: run pgindent on a regular basis / scripted manner Andres Freund 18:11
Re: Corruption during WAL replay Andres Freund 18:22
Re: EDB builds Postgres 13 with an obsolete ICU version Bruce Momjian 18:23
Re: Optimising compactify_tuples() Peter Geoghegan 18:52
Re: [BUG] Error in BRIN summarization Alvaro Herrera 19:07
Re: run pgindent on a regular basis / scripted manner Tom Lane 19:25
Re: Improving connection scalability: GetSnapshotData() Alvaro Herrera 20:09
Re: [BUG] Error in BRIN summarization 📎 Alvaro Herrera 20:21
Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails 📎 Tom Lane 22:37
Re: doc examples for pghandler 📎 Mark Wong 23:30
Re: psql: add \si, \sm, \st and \sr functions to show CREATE commands for indexes, matviews, triggers and tables 📎 a.pervushina 23:54
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits Alvaro Herrera 23:54
Re: use pg_get_functiondef() in pg_dump Corey Huinker 23:54

Aug. 18, 2020

Thread Author Time
Re: EDB builds Postgres 13 with an obsolete ICU version Michael Paquier 00:44
Re: EDB builds Postgres 13 with an obsolete ICU version Bruce Momjian 00:47
Re: Terminate the idle sessions Kyotaro Horiguchi 01:19
Re: Terminate the idle sessions Li Japin 02:12
Re: doc examples for pghandler Michael Paquier 02:14
Re: display offset along with block number in vacuum errors 📎 Amit Kapila 04:06
pgsql: snapshot scalability: cache snapshots using a xact completion co Andres Freund 04:30
Re: pgsql: snapshot scalability: cache snapshots using a xact completion co Michael Paquier 04:52
Re: pgsql: snapshot scalability: cache snapshots using a xact completion co Tom Lane 04:55
Re: pgsql: snapshot scalability: cache snapshots using a xact completion co Andres Freund 05:02
Re: pgsql: snapshot scalability: cache snapshots using a xact completion co Andres Freund 05:18
Re: pgsql: snapshot scalability: cache snapshots using a xact completion co Tom Lane 05:21
Print logical WAL message content 📎 Ashutosh Bapat 05:45
Re: [Patch] Optimize dropping of relation buffers using dlist Amit Kapila 06:04
Re: Display individual query in pg_stat_activity Masahiro Ikeda 06:54
New statistics for tuning WAL buffer size Masahiro Ikeda 07:21
Re: Display individual query in pg_stat_activity Pavel Stehule 07:35
RE: New statistics for tuning WAL buffer size [email protected] 07:35
Re: Is it worth accepting multiple CRLs? Kyotaro Horiguchi 07:43
Re: INSERT INTO SELECT, Why Parallelism is not selected? Bharath Rupireddy 08:06
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma 08:16
Re: EDB builds Postgres 13 with an obsolete ICU version Dave Page 09:24
Re: EDB builds Postgres 13 with an obsolete ICU version Magnus Hagander 09:38
Re: Creating a function for exposing memory usage of backend process 📎 torikoshia 09:41
Re: Hybrid Hash/Nested Loop joins and caching results from subplans David Rowley 09:42
Re: Implementing Incremental View Maintenance 📎 Yugo NAGATA 09:52
Re: EDB builds Postgres 13 with an obsolete ICU version Thomas Kellerer 09:54
Re: EDB builds Postgres 13 with an obsolete ICU version Julien Rouhaud 09:58
Re: [HACKERS] make async slave to wait for lsn to be replayed 📎 Anna Akenteva 10:12
Re: recovering from "found xmin ... from before relfrozenxid ..." 📎 Ashutosh Sharma 11:21
Re: recovering from "found xmin ... from before relfrozenxid ..." Chris Travers 11:29
Re: Libpq support to connect to standby server as priority 📎 Greg Nancarrow 11:32
Re: jsonb, collection & postgres_fdw Ashutosh Bapat 12:06
Re: recovering from "found xmin ... from before relfrozenxid ..." Rajkumar Raghuwanshi 12:18
Documentation patch for backup manifests in protocol.sgml 📎 Bernd Helmle 12:41
Re: use pg_get_functiondef() in pg_dump Stephen Frost 13:18
Re: INSERT INTO SELECT, Why Parallelism is not selected? Amit Kapila 13:38
Re: Creating a function for exposing memory usage of backend process Fujii Masao 13:54
Re: psql: add \si, \sm, \st and \sr functions to show CREATE commands for indexes, matviews, triggers and tables Tom Lane 14:25
Re: EDB builds Postgres 13 with an obsolete ICU version Bruce Momjian 15:13
Re: [patch] demote 📎 Jehan-Guillaume de Rorthais 15:41
Re: track_planning causing performance regression 📎 Fujii Masao 15:43
Re: track_planning causing performance regression Hamid Akhtar 15:44
Re: Yet another fast GiST build Pavel Borisov 15:57
Re: recovering from "found xmin ... from before relfrozenxid ..." Alvaro Herrera 16:14
Re: Nicer error when connecting to standby with hot_standby=off Fujii Masao 16:25
Re: use pg_get_functiondef() in pg_dump Tom Lane 17:03
Re: doc review for v13 📎 Justin Pryzby 17:17
Re: proposal: enhancing plpgsql debug API - returns text value of variable content 📎 Pavel Stehule 18:04
Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails 📎 Tom Lane 20:09
Re: pgsql: snapshot scalability: cache snapshots using a xact completion co Andres Freund 20:28
Re: Print logical WAL message content Alvaro Herrera 21:51
please update ps display for recovery checkpoint 📎 Justin Pryzby 22:52
Re: pgsql: snapshot scalability: cache snapshots using a xact completion co Andres Freund 23:45

Aug. 19, 2020

Thread Author Time
RE: please update ps display for recovery checkpoint [email protected] 00:20
Re: Creating a function for exposing memory usage of backend process 📎 torikoshia 00:43
Re: Implementing Incremental View Maintenance Tatsuo Ishii 01:02
prepared transaction isolation tests 📎 Andres Freund 01:22
Re: prepared transaction isolation tests Tom Lane 02:24
Re: prepared transaction isolation tests Andres Freund 02:34
Re: Hybrid Hash/Nested Loop joins and caching results from subplans 📎 David Rowley 02:45
Re: [PG13] Planning (time + buffers) data structure in explain plan (format text) Justin Pryzby 03:27
RE: [PATCH]Fix ja.po error Lu, Chenyang 03:32
Re: Hybrid Hash/Nested Loop joins and caching results from subplans David Rowley 03:48
Re: recovering from "found xmin ... from before relfrozenxid ..." Masahiko Sawada 03:56
Re: Hybrid Hash/Nested Loop joins and caching results from subplans Pavel Stehule 04:17
Re: Hybrid Hash/Nested Loop joins and caching results from subplans Tom Lane 04:23
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma 04:27
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Amit Kapila 04:40
RE: New statistics for tuning WAL buffer size Masahiro Ikeda 04:41
RE: New statistics for tuning WAL buffer size [email protected] 04:49
Re: Creating foreign key on partitioned table is too slow Amit Langote 05:02
RE: New statistics for tuning WAL buffer size Masahiro Ikeda 05:10
Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails Jiří Fejfar 05:39
Re: Display individual query in pg_stat_activity Drouvot, Bertrand 05:48
Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails Tom Lane 05:53
Re: Pulling up direct-correlated ANY_SUBLINK Andy Fan 05:55
Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails Jiří Fejfar 06:08
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma 06:09
Re: Parallel copy 📎 vignesh C 06:21
Re: Creating a function for exposing memory usage of backend process Fujii Masao 06:48
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Amit Kapila 06:49
Re: Binary search in ScalarArrayOpExpr for OR'd constant arrays Heikki Linnakangas 07:16
Re: [PG13] Planning (time + buffers) data structure in explain plan (format text) 📎 Julien Rouhaud 07:21
Re: display offset along with block number in vacuum errors 📎 Masahiko Sawada 07:23
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Dilip Kumar 08:04
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Dilip Kumar 08:05
Re: [PATCH] - Provide robust alternatives for replace_string 📎 Georgios 08:07
Re: Creating a function for exposing memory usage of backend process torikoshia 08:40
Re: [PG13] Planning (time + buffers) data structure in explain plan (format text) David Rowley 08:49
Re: [PG13] Planning (time + buffers) data structure in explain plan (format text) Julien Rouhaud 09:04
Re: Creating a function for exposing memory usage of backend process Fujii Masao 09:12
Re: recovering from "found xmin ... from before relfrozenxid ..." Masahiko Sawada 10:25
Re: [Patch] ALTER SYSTEM READ ONLY 📎 Amul Sul 10:28
Re: [PG13] Planning (time + buffers) data structure in explain plan (format text) David Rowley 10:39
Re: [PG13] Planning (time + buffers) data structure in explain plan (format text) 📎 David Rowley 11:24
Re: Optimising compactify_tuples() 📎 Thomas Munro 11:41
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma 11:45
Re: More tests with USING INDEX replident and dropped indexes Rahila Syed 12:03
Re: SyncRepLock acquired exclusively in default configuration Fujii Masao 12:41
Re: track_planning causing performance regression Hamid Akhtar 12:45
Refactor pg_rewind code and make it work against a standby 📎 Heikki Linnakangas 12:50
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits 📎 Anastasia Lubennikova 13:15
Re: SyncRepLock acquired exclusively in default configuration Asim Praveen 13:20
Re: More tests with USING INDEX replident and dropped indexes Michael Paquier 13:24
Re: Print logical WAL message content 📎 Ashutosh Bapat 13:29
Re: prepared transaction isolation tests Michael Paquier 13:38
Re: prepared transaction isolation tests Andrew Dunstan 13:38
Re: Creating a function for exposing memory usage of backend process Michael Paquier 13:55
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? 📎 Julien Rouhaud 14:19
Re: Creating a function for exposing memory usage of backend process Tom Lane 15:01
Re: Performing partition pruning using row value ahsan hadi 15:12
Re: [PG13] Planning (time + buffers) data structure in explain plan (format text) 📎 Fujii Masao 15:31
Re: stress test for parallel workers Tom Lane 16:14
deb repo doesn't have latest. or possible to update web page? Roger Pack 17:04
Problem with accessing TOAST data in stored procedures Konstantin Knizhnik 17:22
Re: deb repo doesn't have latest. or possible to update web page? Magnus Hagander 17:23
Re: Creating foreign key on partitioned table is too slow Alvaro Herrera 18:06

Browse Archives

Prev | Next