pgsql-hackers since 2020-07-21 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

July 21, 2020

Thread	Author	Time
Re: Wrong results from in_range() tests with infinite offset	Tom Lane	02:06
RE: Parallel Seq Scan vs kernel read ahead	[email protected]	02:36
Re: Allow ERROR from heap_prepare_freeze_tuple to be downgraded to WARNING	Andrey M. Borodin	02:53
Re: Parallel Seq Scan vs kernel read ahead	Amit Kapila	03:18
Re: Added tab completion for the missing options in copy statement	Michael Paquier	03:21
Re: Allow ERROR from heap_prepare_freeze_tuple to be downgraded to WARNING	Dilip Kumar	03:26
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎	Ajin Cherian	03:37
Re: expose parallel leader in CSV and log_line_prefix 📎	Michael Paquier	03:51
Re: expose parallel leader in CSV and log_line_prefix	Justin Pryzby	04:12
Re: shared tempfile was not removed on statement_timeout	Justin Pryzby	04:32
Re: expose parallel leader in CSV and log_line_prefix	Michael Paquier	04:33
Re: expose parallel leader in CSV and log_line_prefix	Michael Paquier	04:38
Re: new heapcheck contrib module	Amul Sul	05:28
Re: Allow ERROR from heap_prepare_freeze_tuple to be downgraded to WARNING	Dilip Kumar	05:30
Re: OpenSSL 3.0.0 compatibility	Michael Paquier	05:32
Re: new heapcheck contrib module	Amul Sul	06:50
WAL segment switch on pg_start_backup()	@usernamedt	07:51
Re: Wrong results from in_range() tests with infinite offset	Dean Rasheed	08:06
RE: Performing partition pruning using row value 📎	[email protected]	08:24
Re: Auto-vectorization speeds up multiplication of large-precision numerics 📎	Amit Khandekar	09:16
RE: Parallel Seq Scan vs kernel read ahead	[email protected]	09:38
Re: Parallel copy	Amit Kapila	10:24
Re: Parallel Seq Scan vs kernel read ahead	Amit Kapila	10:32
Re: Allow ERROR from heap_prepare_freeze_tuple to be downgraded to WARNING 📎	Dilip Kumar	10:38
Re: Add A Glossary 📎	Jürgen Purtz	11:47
Re: Additional Chapter for Tutorial 📎	Jürgen Purtz	11:51
Re: Improving psql slash usage help message	Hamid Akhtar	11:51
Comment referencing incorrect algorithm 📎	Daniel Gustafsson	11:57
OpenSSL randomness seeding 📎	Daniel Gustafsson	12:13
Re: Postgres-native method to identify if a tuple is frozen	Amit Kapila	12:22
Re: Allow ERROR from heap_prepare_freeze_tuple to be downgraded to WARNING 📎	Dilip Kumar	13:21
Re: WIP: System Versioned Temporal Table 📎	Surafel Temesgen	14:32
Re: Improving psql slash usage help message	Tom Lane	15:10
Re: OpenSSL randomness seeding	David Steele	15:31
Re: Improve handling of pg_stat_statements handling of bind "IN" variables	Dmitry Dolgov	16:01
Re: pg_subscription.subslotname is wrongly marked NOT NULL	Tom Lane	16:42
Re: Add A Glossary	Alvaro Herrera	17:13
xl_heap_header alignment?	Antonin Houska	17:45
Re: xl_heap_header alignment?	Andres Freund	18:02
Re: xl_heap_header alignment?	Tom Lane	18:33
v13 planner ERROR: could not determine which collation to use for string comparison	Justin Pryzby	19:16
Re: v13 planner ERROR: could not determine which collation to use for string comparison	David G. Johnston	19:34
Re: OpenSSL randomness seeding	Daniel Gustafsson	19:44
Re: v13 planner ERROR: could not determine which collation to use for string comparison	Justin Pryzby	19:57
Re: OpenSSL randomness seeding	David Steele	20:00
Re: Default setting for enable_hashagg_disk	Bruce Momjian	20:30
Re: OpenSSL randomness seeding	Daniel Gustafsson	20:36
Re: Improving psql slash usage help message	Peter Eisentraut	20:38
Re: Which SET TYPE don't actually require a rewrite	Bruce Momjian	20:55
Re: Using Valgrind to detect faulty buffer accesses (no pin or buffer content lock held)	Peter Geoghegan	21:52
Re: Infinities in type numeric 📎	Tom Lane	22:18
Re: v13 planner ERROR: could not determine which collation to use for string comparison	Tom Lane	22:25
Re: Using Valgrind to detect faulty buffer accesses (no pin or buffer content lock held)	Peter Geoghegan	22:53
Re: Index Skip Scan (new UniqueKeys)	Peter Geoghegan	23:35
RE: Additional Chapter for Tutorial	PASCAL CROZET	23:49
Re: Parallel Seq Scan vs kernel read ahead	David Rowley	23:55

July 22, 2020

Thread	Author	Time
Re: Which SET TYPE don't actually require a rewrite	Michael Paquier	00:31
Re: v13 planner ERROR: could not determine which collation to use for string comparison	Michael Paquier	00:36
Re: v13 planner ERROR: could not determine which collation to use for string comparison	Tom Lane	00:43
Re: factorial function/phase out postfix operators? 📎	Mark Dilger	00:46
Re: new heapcheck contrib module 📎	Mark Dilger	00:47
Re: Comment referencing incorrect algorithm	Michael Paquier	01:19
Re: OpenSSL randomness seeding	Michael Paquier	01:45
Re: Stale external URL in doc?	Kyotaro Horiguchi	02:37
RE: archive status ".ready" files may be created too early	[email protected]	02:53
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Amit Kapila	03:48
Re: Parallel Seq Scan vs kernel read ahead	Amit Kapila	03:56
Re: Parallel Seq Scan vs kernel read ahead	Thomas Munro	04:32
RE: Parallel Seq Scan vs kernel read ahead	[email protected]	04:40
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎	Dilip Kumar	04:50
Re: xl_heap_header alignment?	Antonin Houska	04:58
Re: OpenSSL randomness seeding	Noah Misch	05:00
Re: Parallel Seq Scan vs kernel read ahead	David Rowley	05:20
Re: OpenSSL randomness seeding	Michael Paquier	05:35
RE: Implement UNLOGGED clause for COPY FROM	[email protected]	05:41
Re: problem with RETURNING and update row movement 📎	Amit Langote	06:16
RE: Parallel Seq Scan vs kernel read ahead	[email protected]	06:17
Re: Transactions involving multiple postgres foreign servers, take 2 📎	Masahiko Sawada	07:41
Re: Is it useful to record whether plans are generic or custom? 📎	torikoshia	07:49
Re: Using Valgrind to detect faulty buffer accesses (no pin or buffer content lock held)	Georgios	07:57
Re: Parallel Seq Scan vs kernel read ahead	David Rowley	08:18
Re: [POC] Fast COPY FROM command for the table with foreign partitions	Andrey V. Lepikhov	09:09
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Amit Kapila	10:50
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎	Dilip Kumar	11:24
Re: [Proposal] Global temporary tables	wenjing zeng	11:53
Re: expose parallel leader in CSV and log_line_prefix	Julien Rouhaud	12:25
Re: Parallel copy 📎	vignesh C	14:17
Re: Parallel copy	vignesh C	14:26
Re: [PATCH] fix GIN index search sometimes losing results	Tom Lane	15:10
Re: expose parallel leader in CSV and log_line_prefix	Alvaro Herrera	15:36
Re: Parallel Seq Scan vs kernel read ahead	Soumyadeep Chakraborty	18:00
Re: Parallel Seq Scan vs kernel read ahead	Soumyadeep Chakraborty	19:02
RE: [PATCH] Keeps tracking the uniqueness with UniqueKey	Floris Van Nee	19:22
Re: Default setting for enable_hashagg_disk	Robert Haas	19:42
Re: [PATCH] fix GIN index search sometimes losing results 📎	Pavel Borisov	20:09
Re: OpenSSL randomness seeding	Daniel Gustafsson	21:31
RE: Generic Index Skip Scan 📎	Floris Van Nee	21:38
Re: Infinities in type numeric	Dean Rasheed	21:54
Re: [Patch] ALTER SYSTEM READ ONLY	Soumyadeep Chakraborty	22:03
Re: [Patch] ALTER SYSTEM READ ONLY	SATYANARAYANA NARLAPURAM	23:03
Why it is not possible to create custom AM which behaves similar to btree?	Konstantin Knizhnik	23:15
Re: Infinities in type numeric	Tom Lane	23:20

July 23, 2020

Thread	Author	Time
Re: Why it is not possible to create custom AM which behaves similar to btree?	Tom Lane	00:11
Re: [Patch] ALTER SYSTEM READ ONLY	Soumyadeep Chakraborty	00:37
Re: expose parallel leader in CSV and log_line_prefix	Michael Paquier	00:52
Re: expose parallel leader in CSV and log_line_prefix	Tom Lane	00:59
Re: expose parallel leader in CSV and log_line_prefix	Michael Paquier	01:42
Re: Default setting for enable_hashagg_disk	Peter Geoghegan	02:54
Re: Parallel copy	Bharath Rupireddy	03:20
[PATCH] keep the message consistent in buffile.c 📎	Lu, Chenyang	03:23
Re: [PATCH] keep the message consistent in buffile.c	Thomas Munro	03:27
Re: Parallel copy	Amit Kapila	03:52
Re: Implement UNLOGGED clause for COPY FROM	Amit Kapila	04:24
RE: Global snapshots	[email protected]	04:46
Re: Parallel copy	Ashutosh Sharma	04:51
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Amit Kapila	06:01
Re: Global snapshots	Masahiko Sawada	06:13
Re: Resetting spilled txn statistics in pg_stat_replication 📎	Masahiko Sawada	06:16
Re: [POC] Fast COPY FROM command for the table with foreign partitions 📎	Andrey V. Lepikhov	06:23
Re: [Proposal] Global temporary tables	Pavel Stehule	06:54
Re: Parallel worker hangs while handling errors. 📎	vignesh C	07:24
Re: Transactions involving multiple postgres foreign servers, take 2	Ahsan Hadi	07:34
Re: Index Skip Scan (new UniqueKeys)	Dmitry Dolgov	09:53
Building 12.3 from source on Mac	Paul Förster	10:01
Re: Building 12.3 from source on Mac	Daniel Gustafsson	10:37
Re: [Patch] ALTER SYSTEM READ ONLY	Amul Sul	10:41
Re: [Patch] ALTER SYSTEM READ ONLY	Amul Sul	10:43
Re: Dumping/restoring fails on inherited generated column 📎	Masahiko Sawada	10:55
Re: [Patch] ALTER SYSTEM READ ONLY	Amul Sul	10:56
Re: Parallel Seq Scan vs kernel read ahead	Amit Kapila	11:00
Re: Compatible defaults for LEAD/LAG	Daniel Gustafsson	11:29
Re: explain HashAggregate to report bucket and memory stats	Daniel Gustafsson	11:35
RE: Index Skip Scan (new UniqueKeys)	Floris Van Nee	11:43
Re: Compatible defaults for LEAD/LAG	Pavel Stehule	11:55
Re: Why it is not possible to create custom AM which behaves similar to btree?	Konstantin Knizhnik	12:35
Re: Parallel copy	Bharath Rupireddy	12:37
Re: Add session statistics to pg_stat_database	Ahsan Hadi	13:16
Re: Building 12.3 from source on Mac	Paul Förster	13:24
Re: Building 12.3 from source on Mac	Tom Lane	13:42
Re: Transactions involving multiple postgres foreign servers, take 2	Muhammad Usama	13:50
Re: Building 12.3 from source on Mac	Paul Förster	13:56
Re: Building 12.3 from source on Mac	Tom Lane	14:03
Re: Open Item: Should non-text EXPLAIN always show properties?	Justin Pryzby	14:14
Re: Building 12.3 from source on Mac	Paul Förster	14:16
Re: Building 12.3 from source on Mac	Tom Lane	14:50
Re: Building 12.3 from source on Mac	Paul Förster	15:04
Re: Building 12.3 from source on Mac	Pavel Borisov	15:16
Re: [Patch] ALTER SYSTEM READ ONLY	Soumyadeep Chakraborty	16:10
'with' regression tests fails rarely (and spuriously)	Andres Freund	16:19
Making CASE error handling less surprising 📎	Tom Lane	16:57
Re: Loaded footgun open_datasync on Windows	Jeff Janes	17:05
Re: 'with' regression tests fails rarely (and spuriously)	Tom Lane	17:05
[BUG] Error in BRIN summarization 📎	Anastasia Lubennikova	17:39
Re: Making CASE error handling less surprising	Dagfinn Ilmari Mannsåker	17:50
Re: 'with' regression tests fails rarely (and spuriously)	Andres Freund	18:00
HOT vs freezing issue causing "cannot freeze committed xmax"	Andres Freund	18:10
Re: Making CASE error handling less surprising	Andres Freund	19:02
heap_abort_speculative() sets xmin to Invalid* without HEAP_XMIN_INVALID	Andres Freund	19:40
Re: Making CASE error handling less surprising	Tom Lane	19:43
Re: Making CASE error handling less surprising	Pavel Stehule	19:56
Re: Making CASE error handling less surprising	Andres Freund	20:06
Re: Making CASE error handling less surprising	Pavel Stehule	20:08
Re: Making CASE error handling less surprising	Andres Freund	20:21
Re: Making CASE error handling less surprising	Tom Lane	20:27
Re: Making CASE error handling less surprising	Tom Lane	20:34
Re: Making CASE error handling less surprising	Andres Freund	20:42
Re: Making CASE error handling less surprising	Andres Freund	20:49
Re: Making CASE error handling less surprising	Tom Lane	20:56
Re: Making CASE error handling less surprising	Andres Freund	21:09
Re: heap_abort_speculative() sets xmin to Invalid* without HEAP_XMIN_INVALID	Alvaro Herrera	21:49
Re: Default setting for enable_hashagg_disk 📎	Peter Geoghegan	23:32

July 24, 2020

Thread	Author	Time
Re: [Patch] ALTER SYSTEM READ ONLY	Soumyadeep Chakraborty	00:56
Re: [Patch] ALTER SYSTEM READ ONLY	Soumyadeep Chakraborty	00:58
Re: Improving connection scalability: GetSnapshotData() 📎	Andres Freund	01:11
Re: [PATCH] audo-detect and use -moutline-atomics compilation flag for aarch64	Andres Freund	01:17
Re: Default setting for enable_hashagg_disk 📎	Tomas Vondra	01:22
Re: [Patch] ALTER SYSTEM READ ONLY	Andres Freund	02:04
Re: Default setting for enable_hashagg_disk	Peter Geoghegan	02:33
Re: Making CASE error handling less surprising 📎	Tom Lane	02:34
Re: heap_abort_speculative() sets xmin to Invalid* without HEAP_XMIN_INVALID	Peter Geoghegan	03:51
Row estimates for empty tables	Christophe Pettus	04:01
Re: Row estimates for empty tables	David Rowley	04:56
Re: [Patch] ALTER SYSTEM READ ONLY	Amul Sul	05:13
Re: Parallel worker hangs while handling errors. 📎	Bharath Rupireddy	07:10
Re: Parallel Seq Scan vs kernel read ahead	David Rowley	07:12
Re: logical replication empty transactions	Ajin Cherian	07:40
handle a ECPG_bytea typo 📎	Wang, Shenhao	08:05
Re: logical replication empty transactions	Ajin Cherian	08:13
Re: Implement UNLOGGED clause for COPY FROM	Masahiko Sawada	08:14
Re: deferred primary key and logical replication	Ajin Cherian	08:15
Re: Default setting for enable_hashagg_disk	Tomas Vondra	08:40
Re: recovering from "found xmin ... from before relfrozenxid ..." 📎	Ashutosh Sharma	09:05
Re: renaming configure.in to configure.ac	Peter Eisentraut	09:13
Re: Issue with cancel_before_shmem_exit while searching to remove a particular registered exit callbacks 📎	Bharath Rupireddy	11:09
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎	Amit Kapila	11:35
Re: INSERT INTO SELECT, Why Parallelism is not selected?	Amit Kapila	11:59
Re: [Patch] ALTER SYSTEM READ ONLY	Amul Sul	13:09
Re: Default setting for enable_hashagg_disk 📎	Tomas Vondra	13:18
Re: renaming configure.in to configure.ac	Tom Lane	13:23
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎	Dilip Kumar	13:47

Browse Archives

Prev | Next