pgsql-hackers before 2020-08-22 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

Aug. 18, 2020

Thread	Author	Time
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
Re: remove spurious CREATE INDEX CONCURRENTLY wait 📎	Alvaro Herrera	18:16
Re: Problem with accessing TOAST data in stored procedures 📎	Pavel Stehule	18:50
Re: Problem with accessing TOAST data in stored procedures	Konstantin Knizhnik	18:59
Re: Problem with accessing TOAST data in stored procedures	Pavel Stehule	19:20
"ccold" left by reindex concurrently are droppable?	Alvaro Herrera	21:13
Re: Hybrid Hash/Nested Loop joins and caching results from subplans	David Rowley	21:59
Re: Hybrid Hash/Nested Loop joins and caching results from subplans	David Rowley	22:04
Re: pgsql: snapshot scalability: cache snapshots using a xact completion co	Alvaro Herrera	22:37
Re: Creating a function for exposing memory usage of backend process	Andres Freund	22:53
Re: Hybrid Hash/Nested Loop joins and caching results from subplans	Alvaro Herrera	22:58
Re: Optimising compactify_tuples() 📎	Thomas Munro	23:27
Re: [PG13] Planning (time + buffers) data structure in explain plan (format text)	David Rowley	23:33
Re: Hybrid Hash/Nested Loop joins and caching results from subplans	David Rowley	23:56

Aug. 20, 2020

Thread	Author	Time
RE: Implement UNLOGGED clause for COPY FROM	[email protected]	00:18
Re: Creating a function for exposing memory usage of backend process	Tom Lane	01:29
Re: Libpq support to connect to standby server as priority	Peter Smith	01:36
Re: Creating a function for exposing memory usage of backend process	Andres Freund	01:43
Re: Creating foreign key on partitioned table is too slow	Amit Langote	01:50
Re: proposal - function string_to_table 📎	Peter Smith	02:06
Re: Creating a function for exposing memory usage of backend process	Fujii Masao	02:09
Re: Creating a function for exposing memory usage of backend process	Fujii Masao	02:17
Re: extension patch of CREATE OR REPLACE TRIGGER	Peter Smith	02:18
Re: SyncRepLock acquired exclusively in default configuration	Kyotaro Horiguchi	02:29
Re: new heapcheck contrib module 📎	Mark Dilger	02:30
The number of logical replication slot or wal sender recommend	胡常齐	02:49
Re: Creating a function for exposing memory usage of backend process	Kasahara Tatsuhito	02:59
Re: SyncRepLock acquired exclusively in default configuration	Kyotaro Horiguchi	03:12
Re: Hybrid Hash/Nested Loop joins and caching results from subplans	Pavel Stehule	03:54
Re: [PG13] Planning (time + buffers) data structure in explain plan (format text)	David Rowley	04:00
Re: Asynchronous Append on postgres_fdw nodes.	Justin Pryzby	04:25
Re: Include access method in listTables output	Justin Pryzby	04:31
Re: display offset along with block number in vacuum errors	Amit Kapila	05:01
Re: "ccold" left by reindex concurrently are droppable?	Michael Paquier	05:17
Re: recovering from "found xmin ... from before relfrozenxid ..."	Masahiko Sawada	05:33
Re: remove spurious CREATE INDEX CONCURRENTLY wait	Michael Paquier	06:11
Re: recovering from "found xmin ... from before relfrozenxid ..."	Ashutosh Sharma	06:13
Re: Implement UNLOGGED clause for COPY FROM	Kyotaro Horiguchi	06:24
Re: display offset along with block number in vacuum errors	Masahiko Sawada	06:47
Re: display offset along with block number in vacuum errors	Amit Kapila	07:02
Re: Asynchronous Append on postgres_fdw nodes. 📎	Kyotaro Horiguchi	07:36
Re: [PG13] Planning (time + buffers) data structure in explain plan (format text) 📎	Fujii Masao	07:58
Re: [PG13] Planning (time + buffers) data structure in explain plan (format text)	Pierre Giraud	08:03
Re: [PG13] Planning (time + buffers) data structure in explain plan (format text)	Fujii Masao	08:07
Re: please update ps display for recovery checkpoint	Michael Paquier	08:09
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Dilip Kumar	08:10
Re: Include access method in listTables output 📎	Georgios	08:16
Re: "ccold" left by reindex concurrently are droppable?	Julien Rouhaud	08:18
Re: Refactor pg_rewind code and make it work against a standby	Kyotaro Horiguchi	08:32
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Amit Kapila	08:59
Small doubt on update a partition when some rows need to move among partition 📎	[email protected]	09:23
Fix a couple of typos in JIT 📎	David Rowley	10:19
Re: [PG13] Planning (time + buffers) data structure in explain plan (format text)	David Rowley	10:28
Re: Fix a couple of typos in JIT	Abhijit Menon-Sen	10:29
Re: Fix a couple of typos in JIT	David Rowley	10:51
Re: New statistics for tuning WAL buffer size	Fujii Masao	11:01
Re: New statistics for tuning WAL buffer size	Fujii Masao	11:19
Re: Fix a couple of typos in JIT	Abhijit Menon-Sen	11:26
Re: new heapcheck contrib module	Amul Sul	11:47
Re: display offset along with block number in vacuum errors 📎	Amit Kapila	12:12
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎	Dilip Kumar	12:12
Re: Small doubt on update a partition when some rows need to move among partition	Ashutosh Bapat	12:57
Re: [PG13] Planning (time + buffers) data structure in explain plan (format text)	Julien Rouhaud	13:34
Re: Fix a couple of typos in JIT	Andres Freund	14:25
Re: Transactions involving multiple postgres foreign servers, take 2	Fujii Masao	15:36
Re: [PG13] Planning (time + buffers) data structure in explain plan (format text)	Fujii Masao	15:41
ReplicationSlotsComputeRequiredXmin seems pretty questionable	Tom Lane	16:58
Re: "ccold" left by reindex concurrently are droppable?	Alvaro Herrera	17:54
Re: language cleanups in code and docs	Ashwin Agrawal	18:34
Re: proposal - function string_to_table 📎	Pavel Stehule	19:21
Re: deb repo doesn't have latest. or possible to update web page?	Roger Pack	20:38
Re: Fix a couple of typos in JIT	David Rowley	21:38
XMAX_LOCK_ONLY and XMAX_COMMITTED (fk/multixact code)	Jeremy Schneider	23:30
Problems with the FSM, heap fillfactor, and temporal locality	Peter Geoghegan	23:47

Aug. 21, 2020

Thread	Author	Time
Re: SyncRepLock acquired exclusively in default configuration	Masahiko Sawada	01:20
Fix typo in procarrary.c 📎	Masahiko Sawada	01:58
Re: Fix typo in procarrary.c	Fujii Masao	02:17
Re: Creating foreign key on partitioned table is too slow 📎	Amit Langote	02:20
RE: New statistics for tuning WAL buffer size	[email protected]	02:53
RE: New statistics for tuning WAL buffer size	[email protected]	03:08
Re: New statistics for tuning WAL buffer size	Fujii Masao	03:22
Re: Fix typo in procarrary.c	Masahiko Sawada	03:29
Re: Fix typo in procarrary.c	Fujii Masao	03:39
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Amit Kapila	03:44
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Amit Kapila	03:58
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Amit Kapila	04:49
Re: Libpq support to connect to standby server as priority 📎	Greg Nancarrow	04:53
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Dilip Kumar	05:03
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Dilip Kumar	05:04
Re: Libpq support to connect to standby server as priority	Peter Smith	05:24
Re: [PG13] Planning (time + buffers) data structure in explain plan (format text)	Pierre Giraud	05:54
Re: Asymmetric partition-wise JOIN 📎	Andrey V. Lepikhov	06:02
Re: Fix typo in procarrary.c	Masahiko Sawada	06:16
Re: Transactions involving multiple postgres foreign servers, take 2 📎	Masahiko Sawada	06:25
Re: display offset along with block number in vacuum errors	Masahiko Sawada	07:00
Re: proposal - function string_to_table	Peter Smith	07:43
[POC]Enable tuple change partition caused by BEFORE TRIGGER 📎	[email protected]	07:57
Re: Implementing Incremental View Maintenance 📎	Yugo NAGATA	08:23
Re: proposal - function string_to_table	Pavel Stehule	09:08
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎	Amit Kapila	09:43
Re: proposal - function string_to_table 📎	Pavel Stehule	09:45
Re: Problems with the FSM, heap fillfactor, and temporal locality	John Naylor	10:09
Re: Bogus documentation for bogus geometric operators 📎	Emre Hasegeli	11:00
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Dilip Kumar	11:39
Re: [POC]Enable tuple change partition caused by BEFORE TRIGGER	Ashutosh Bapat	11:47
Re: [PG13] Planning (time + buffers) data structure in explain plan (format text)	Fujii Masao	11:52
Re: [POC] Fast COPY FROM command for the table with foreign partitions 📎	Andrey Lepikhov	12:19
Re: Implementing Incremental View Maintenance	Tatsuo Ishii	12:40
Re: recovering from "found xmin ... from before relfrozenxid ..." 📎	Ashutosh Sharma	13:24
Re: Creating a function for exposing memory usage of backend process 📎	torikoshia	14:27
Re: [PG13] Planning (time + buffers) data structure in explain plan (format text)	Tom Lane	14:53
Re: [PG13] Planning (time + buffers) data structure in explain plan (format text) 📎	Fujii Masao	16:04
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits	Ibrar Ahmed	16:43
Re: run pgindent on a regular basis / scripted manner	Magnus Hagander	16:50
Re: [PG13] Planning (time + buffers) data structure in explain plan (format text)	Fujii Masao	16:54
Re: deb repo doesn't have latest. or possible to update web page?	Magnus Hagander	17:12
Re: Problems with the FSM, heap fillfactor, and temporal locality	Peter Geoghegan	17:52
Re: Documentation patch for backup manifests in protocol.sgml	Bruce Momjian	22:03

Browse Archives

Prev | Next