pgsql-hackers before 2020-08-18 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. 13, 2020

Thread	Author	Time
Re: run pgindent on a regular basis / scripted manner	Magnus Hagander	07:47
Re: recovering from "found xmin ... from before relfrozenxid ..."	Ashutosh Sharma	07:52
Re: Switch to multi-inserts for pg_depend	Alvaro Herrera	09:35
Re: Collation versioning 📎	Julien Rouhaud	09:52
Re: Switch to multi-inserts for pg_depend	Michael Paquier	10:02
Re: [BUG] Error in BRIN summarization	Anastasia Lubennikova	10:06
Re: security_context_t marked as deprecated in libselinux 3.1	Joe Conway	10:54
Re: Re: [HACKERS] Custom compression methods 📎	Dilip Kumar	11:48
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Amit Kapila	13:17
jsonb, collection & postgres_fdw	Konstantin Knizhnik	15:24
Re: Switch to multi-inserts for pg_depend	Alvaro Herrera	15:45
Re: run pgindent on a regular basis / scripted manner	Stephen Frost	16:30
Re: Parallel query hangs after a smart shutdown is issued 📎	Tom Lane	16:45
Re: run pgindent on a regular basis / scripted manner	Tom Lane	16:50
Re: run pgindent on a regular basis / scripted manner	Magnus Hagander	16:58
Re: jsonb, collection & postgres_fdw	Tom Lane	17:00
Re: jsonb, collection & postgres_fdw	Konstantin Knizhnik	17:46
Re: jsonb, collection & postgres_fdw	Tom Lane	18:04
Re: recovering from "found xmin ... from before relfrozenxid ..."	Robert Haas	19:03
Re: run pgindent on a regular basis / scripted manner	Robert Haas	19:36
Re: run pgindent on a regular basis / scripted manner	Robert Haas	19:39
Re: run pgindent on a regular basis / scripted manner	Tom Lane	19:47
Re: Libpq support to connect to standby server as priority	Robert Haas	19:48
Re: run pgindent on a regular basis / scripted manner	Robert Haas	19:50
Re: run pgindent on a regular basis / scripted manner	Andres Freund	20:06
Re: run pgindent on a regular basis / scripted manner	Stephen Frost	20:16
Re: proposal: possibility to read dumped table's name from file	Justin Pryzby	21:41
Re: [BUG] Error in BRIN summarization	Alvaro Herrera	21:53
pg_dump from v13 is slow	Justin Pryzby	22:48
Re: pg_dump from v13 is slow	Alvaro Herrera	23:28
Re: pg_dump from v13 is slow	Andres Freund	23:30

Aug. 14, 2020

Thread	Author	Time
Re: security_context_t marked as deprecated in libselinux 3.1	Michael Paquier	00:10
RE: Libpq support to connect to standby server as priority	[email protected]	00:16
Re: 回复：how to create index concurrently on partitioned table	Michael Paquier	00:29
Re: security_context_t marked as deprecated in libselinux 3.1	Michael Paquier	00:43
Re: pg_dump from v13 is slow	Justin Pryzby	00:47
Re: security_context_t marked as deprecated in libselinux 3.1	Tom Lane	00:47
Re: fixing old_snapshot_threshold's time->xid mapping 📎	Thomas Munro	00:52
Re: pg_dump from v13 is slow	Alvaro Herrera	00:53
Re: pg_dump from v13 is slow	Justin Pryzby	00:59
Re: fixing old_snapshot_threshold's time->xid mapping 📎	Thomas Munro	01:04
Re: pg_dump from v13 is slow	Tom Lane	01:04
Re: security_context_t marked as deprecated in libselinux 3.1	Michael Paquier	01:05
Re: Asynchronous Append on postgres_fdw nodes.	Thomas Munro	01:29
Re: Collation versioning	Thomas Munro	02:21
Re: massive FPI_FOR_HINT load after promote	Masahiko Sawada	02:33
Re: recovering from "found xmin ... from before relfrozenxid ..."	Masahiko Sawada	04:36
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Thomas Munro	04:40
Re: doc examples for pghandler 📎	Michael Paquier	05:25
Re: Inconsistent behavior of smart shutdown handling for queries with and without parallel workers	Bharath Rupireddy	05:32
Re: Parallel query hangs after a smart shutdown is issued	Thomas Munro	06:03
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Amit Kapila	06:14
Re: Terminate the idle sessions	Bharath Rupireddy	06:15
Re: jsonb, collection & postgres_fdw	Bharath Rupireddy	06:40
Re: jsonb, collection & postgres_fdw	Konstantin Knizhnik	07:16
Re: Collation versioning	Michael Paquier	07:37
Fix an old description in high-availability.sgml 📎	Masahiko Sawada	07:53
Re: massive FPI_FOR_HINT load after promote	Simon Riggs	07:55
Newline after --progress report 📎	Heikki Linnakangas	07:57
Re: Terminate the idle sessions	Li Japin	08:02
Re: Switch to multi-inserts for pg_depend	Michael Paquier	08:06
Re: Fix an old description in high-availability.sgml	Michael Paquier	08:15
Commit/abort WAL records with dropped rels missing XLR_SPECIAL_REL_UPDATE 📎	Heikki Linnakangas	08:47
Re: Collation versioning 📎	Julien Rouhaud	09:02
Re: Yet another fast GiST build (typo)	Pavel Borisov	09:21
Re: display offset along with block number in vacuum errors 📎	Amit Kapila	10:36
Re: display offset along with block number in vacuum errors	Amit Kapila	10:38
Re: display offset along with block number in vacuum errors	Amit Kapila	10:41
Re: Autonomous database is coming to Postgres?	Bruce Momjian	12:55
Re: EDB builds Postgres 13 with an obsolete ICU version	Bruce Momjian	13:00
Re: EDB builds Postgres 13 with an obsolete ICU version	Michael Paquier	13:23
Re: Newline after --progress report	Tom Lane	13:51
Re: Autonomous database is coming to Postgres?	Dmitry Dolgov	13:56
Re: Parallel query hangs after a smart shutdown is issued	Tom Lane	14:32
Re: Inconsistent behavior of smart shutdown handling for queries with and without parallel workers	Tom Lane	14:40
Re: jsonb, collection & postgres_fdw	Tom Lane	14:54
Re: Parallel query hangs after a smart shutdown is issued	Arseny Sher	15:31
Re: Parallel copy 📎	vignesh C	15:48
Implement a new data type	mohand oubelkacem makhoukhene	15:48
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits	Ibrar Ahmed	15:52
Re: Implement a new data type	Tom Lane	16:09
Re: EDB builds Postgres 13 with an obsolete ICU version	Bruce Momjian	16:42
Re: Parallel query hangs after a smart shutdown is issued	Tom Lane	17:29
Re: Dependencies for partitioned indexes are still a mess 📎	Alvaro Herrera	17:30
Re: Switch to multi-inserts for pg_depend	Alvaro Herrera	18:23
Loose ends after CVE-2020-14350 (extension installation hazards)	Tom Lane	18:50
Re: Loose ends after CVE-2020-14350 (extension installation hazards)	Chapman Flack	19:07
Re: Loose ends after CVE-2020-14350 (extension installation hazards)	Tom Lane	19:38
Re: [bug+patch] Inserting DEFAULT into generated columns from VALUES RTE 📎	Mikhail Titov	19:57
Re: Loose ends after CVE-2020-14350 (extension installation hazards)	Chapman Flack	20:19
Re: run pgindent on a regular basis / scripted manner	Alvaro Herrera	20:22
Re: run pgindent on a regular basis / scripted manner	Alvaro Herrera	20:26
Re: Dependencies for partitioned indexes are still a mess	Alvaro Herrera	21:35
Re: fixing old_snapshot_threshold's time->xid mapping 📎	Thomas Munro	22:09
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Thomas Munro	22:43
Re: LSM tree for Postgres	AJG	23:14

Aug. 15, 2020

Thread	Author	Time
Re: Switch to multi-inserts for pg_depend	Michael Paquier	01:50
Re: display offset along with block number in vacuum errors	Amit Kapila	03:19
Re: run pgindent on a regular basis / scripted manner	Amit Kapila	03:34
Re: Asynchronous Append on postgres_fdw nodes.	Etsuro Fujita	04:40
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Amit Kapila	04:49
Re: Commit/abort WAL records with dropped rels missing XLR_SPECIAL_REL_UPDATE	Amit Kapila	05:35
Re: remove some ancient port hacks	Peter Eisentraut	09:39
Re: remove some ancient port hacks	Peter Eisentraut	09:41
Re: use pg_get_functiondef() in pg_dump	Peter Eisentraut	09:49
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎	Dilip Kumar	10:02
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Dilip Kumar	10:02
Re: run pgindent on a regular basis / scripted manner	Peter Eisentraut	11:47
Re: Index Skip Scan (new UniqueKeys) 📎	Dmitry Dolgov	14:12
Re: use pg_get_functiondef() in pg_dump	Tom Lane	14:23
Re: use pg_get_functiondef() in pg_dump	Tom Lane	14:36
Re: [BUG] Error in BRIN summarization	Tom Lane	14:54
Re: Improving connection scalability: GetSnapshotData()	Tom Lane	15:10
Re: Improving connection scalability: GetSnapshotData()	Andres Freund	16:42
Re: run pgindent on a regular basis / scripted manner	Andres Freund	16:59
Re: Is it worth accepting multiple CRLs?	Stephen Frost	17:18
Re: use pg_get_functiondef() in pg_dump	Stephen Frost	17:39
Re: run pgindent on a regular basis / scripted manner	Tom Lane	17:44

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

Browse Archives

Prev | Next