pgsql-hackers before 2020-08-03 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 30, 2020

Thread	Author	Time
Re: [PATCH] Tab completion for VACUUM of partitioned tables	Fujii Masao	03:24
Re: Any objections to implementing LogicalDecodeMessageCB for pgoutput? 📎	David Pirotte	03:26
Re: HashAgg's batching counter starts at 0, but Hash's starts at 1.	Peter Geoghegan	03:35
Re: PG 13 release notes, first draft	David G. Johnston	03:43
Re: HashAgg's batching counter starts at 0, but Hash's starts at 1.	Justin Pryzby	04:05
Re: HashAgg's batching counter starts at 0, but Hash's starts at 1.	Peter Geoghegan	04:18
Re: IDEA: pg_stat_statements tracking utility statements by tag?	Julien Rouhaud	04:57
Re: [PATCH] Tab completion for VACUUM of partitioned tables	Masahiko Sawada	05:16
Re: Is it useful to record whether plans are generic or custom?	Fujii Masao	05:31
Re: Reducing WaitEventSet syscall churn	Thomas Munro	05:50
Re: Creating a function for exposing memory usage of backend process	Kasahara Tatsuhito	06:13
Re: INSERT INTO SELECT, Why Parallelism is not selected?	Amit Kapila	06:32
Re: Doc patch: mention indexes in pg_inherits docs	Michael Paquier	06:53
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Ajin Cherian	06:57
RE: Is it useful to record whether plans are generic or custom?	legrand legrand	07:34
RE: [Patch] Optimize dropping of relation buffers using dlist	[email protected]	07:57
Fix minor source code comment mistake 📎	[email protected]	08:03
Re: problem with RETURNING and update row movement 📎	Etsuro Fujita	08:40
Re: Fix minor source code comment mistake	Michael Paquier	08:57
Re: [PATCH] Tab completion for VACUUM of partitioned tables	Michael Paquier	09:08
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Amit Kapila	09:53
Re: Doc patch: mention indexes in pg_inherits docs	Dagfinn Ilmari Mannsåker	09:56
windows config.pl question	Dmitry Markman	10:55
Re: [Proposal] Global temporary tables	wenjing zeng	12:09
Re: Issue with cancel_before_shmem_exit while searching to remove a particular registered exit callbacks	Robert Haas	12:11
Re: INSERT INTO SELECT, Why Parallelism is not selected?	Amit Kapila	13:12
Re: [BUG] Error in BRIN summarization	Anastasia Lubennikova	13:40
Re: Missing CFI in hlCover()?	Stephen Frost	14:22
Re: Missing CFI in hlCover()?	Tom Lane	14:37
Re: Missing CFI in hlCover()?	Stephen Frost	14:37
Re: HyperLogLog.c and pg_leftmost_one_pos32()	Jeff Davis	16:21
Re: HyperLogLog.c and pg_leftmost_one_pos32()	Tomas Vondra	17:16
Re: PG 13 release notes, first draft 📎	Bruce Momjian	17:32
Re: [Patch] Optimize dropping of relation buffers using dlist	Konstantin Knizhnik	17:37
Re: PG 13 release notes, first draft	Peter Geoghegan	17:45
Re: new heapcheck contrib module	Robert Haas	17:59
Re: HyperLogLog.c and pg_leftmost_one_pos32()	Jeff Davis	18:25
Re: Threading in BGWorkers (!)	Andres Freund	18:44
Re: Threading in BGWorkers (!)	Andres Freund	18:46
Re: Threading in BGWorkers (!)	Tom Lane	18:54
Re: Threading in BGWorkers (!)	Robert Haas	19:51
Re: new heapcheck contrib module	Mark Dilger	20:18
Re: new heapcheck contrib module	Andres Freund	20:47
Re: [Proposal] Global temporary tables	Robert Haas	20:57
Re: new heapcheck contrib module	Robert Haas	21:00
Re: Ought to use heap_multi_insert() for pg_attribute/depend insertions?	Daniel Gustafsson	21:23
Re: Reducing WaitEventSet syscall churn 📎	Thomas Munro	21:42
Re: OpenSSL randomness seeding	Daniel Gustafsson	21:42
Re: Missing CFI in hlCover()? 📎	Tom Lane	21:42
Re: psql - improve test coverage from 41% to 88%	Daniel Gustafsson	21:47
Re: Identifying user-created objects	Daniel Gustafsson	21:52
Re: Batch insert in CTAS/MatView code	Daniel Gustafsson	22:08
Re: new heapcheck contrib module	Mark Dilger	22:10
Re: new heapcheck contrib module	Mark Dilger	22:11
Re: proposal: type info support functions for functions that use "any" type	Daniel Gustafsson	22:15
Re: Online checksums patch - once again	Daniel Gustafsson	22:21
Re: Online verification of checksums	Daniel Gustafsson	22:26
Re: ModifyTable overheads in generic plans	Daniel Gustafsson	22:30
Re: pg_dump --where option	Daniel Gustafsson	22:38
logtape.c stats don't account for unused "prefetched" block numbers	Peter Geoghegan	22:51
Re: Missing CFI in hlCover()?	Stephen Frost	23:50

July 31, 2020

Thread	Author	Time
Re: HashAgg's batching counter starts at 0, but Hash's starts at 1. (now: incremental sort)	Justin Pryzby	00:22
Re: proposal: type info support functions for functions that use "any" type	Tom Lane	00:32
Re: new heapcheck contrib module	Robert Haas	00:53
Re: Missing CFI in hlCover()? 📎	Tom Lane	01:25
Re: HashAgg's batching counter starts at 0, but Hash's starts at 1. (now: incremental sort)	Peter Geoghegan	01:33
Re: new heapcheck contrib module	Mark Dilger	01:38
Re: HashAgg's batching counter starts at 0, but Hash's starts at 1. (now: incremental sort)	James Coleman	01:39
Re: HashAgg's batching counter starts at 0, but Hash's starts at 1. (now: incremental sort)	Justin Pryzby	01:40
Re: fixing pg_ctl with relative paths	ZHAOWANCHENG	01:42
Re: HashAgg's batching counter starts at 0, but Hash's starts at 1. (now: incremental sort)	Peter Geoghegan	01:43
Re: HashAgg's batching counter starts at 0, but Hash's starts at 1. (now: incremental sort)	Peter Geoghegan	01:52
Re: windows config.pl question	Michael Paquier	01:59
Re: Use of "long" in incremental sort code	David Rowley	02:11
Re: windows config.pl question	Dmitry Markman	02:25
Re: Cache relation sizes?	Thomas Munro	02:36
Re: Ought to use heap_multi_insert() for pg_attribute/depend insertions? 📎	Michael Paquier	02:41
Re: Index Skip Scan (new UniqueKeys)	David Rowley	03:06
Re: windows config.pl question	Dmitry Markman	03:16
RE: [Patch] Optimize dropping of relation buffers using dlist	[email protected]	05:12
Re: Add Information during standby recovery conflicts	Masahiko Sawada	05:12
RE: [Proposal] Add accumulated statistics for wait event	[email protected]	05:23
Re: Threading in BGWorkers (!)	James Sewell	05:29
Re: Fix minor source code comment mistake	Michael Paquier	05:34
Re: Fast DSM segments	Thomas Munro	05:55
Re: autovac issue with large number of tables	Kasahara Tatsuhito	06:26
Re: Internal key management system 📎	Masahiko Sawada	07:06
Re: Ought to use heap_multi_insert() for pg_attribute/depend insertions?	Daniel Gustafsson	07:44
Re: Creating a function for exposing memory usage of backend process 📎	torikoshia	08:24
[bugfix]"make installcheck" could not work in PGXS 📎	[email protected]	08:31
Re: fixing pg_ctl with relative paths 📎	Kyotaro Horiguchi	08:32
Is it worth accepting multiple CRLs?	Kyotaro Horiguchi	08:39
[PATCH] Remove useless distinct clauses 📎	Pierre Ducroquet	08:41
[PATCH] Add section headings to index types doc 📎	Dagfinn Ilmari Mannsåker	09:30
Re: [PATCH] Remove useless distinct clauses	Ashutosh Bapat	09:36
Re: windows config.pl question	Michael Paquier	09:43
Re: Is it useful to record whether plans are generic or custom? 📎	torikoshia	09:47
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎	Ajin Cherian	09:52
Re: [bugfix]"make installcheck" could not work in PGXS	Michael Paquier	10:57
Re: new heapcheck contrib module	Robert Haas	12:02
[PATCH] - Provide robust alternatives for replace_string 📎	Georgios	12:25
Re: recovering from "found xmin ... from before relfrozenxid ..."	Ashutosh Sharma	12:32
Re: Missing CFI in hlCover()?	Stephen Frost	12:36
Re: track_planning causing performance regression	Hamid Akhtar	12:40
Re: recovering from "found xmin ... from before relfrozenxid ..." 📎	Ashutosh Sharma	12:52
Re: Is it worth accepting multiple CRLs?	Henry B Hotz	12:53
Re: Is it worth accepting multiple CRLs?	Stephen Frost	13:00
Re: Use of "long" in incremental sort code	James Coleman	14:02
Re: Why is pq_begintypsend so slow?	Robert Haas	14:36
Re: recovering from "found xmin ... from before relfrozenxid ..."	Andrey M. Borodin	14:57
Re: Why is pq_begintypsend so slow?	Robert Haas	15:14
Re: Why is pq_begintypsend so slow?	Andres Freund	15:50
Re: Ought to use heap_multi_insert() for pg_attribute/depend insertions?	Andres Freund	15:51
Re: new heapcheck contrib module	Mark Dilger	15:51
Re: Why is pq_begintypsend so slow?	Robert Haas	16:28
Re: proposal: type info support functions for functions that use "any" type	Pavel Stehule	16:28
Re: new heapcheck contrib module	Andres Freund	16:33
Re: new heapcheck contrib module	Robert Haas	16:42
Re: refactoring basebackup.c	Andres Freund	16:49
Re: Why is pq_begintypsend so slow?	Andres Freund	17:00
Re: Why is pq_begintypsend so slow?	Robert Haas	17:35
Re: [Patch] Optimize dropping of relation buffers using dlist	Tom Lane	17:39
Re: refactoring basebackup.c	Robert Haas	17:50
Re: recovering from "found xmin ... from before relfrozenxid ..."	Robert Haas	18:47
Re: [DOC] Document concurrent index builds waiting on each other 📎	James Coleman	18:51
Re: new heapcheck contrib module	Andres Freund	19:05
Re: [PATCH] Support built control file in PGXS VPATH builds	Daniel Gustafsson	19:10
Re: new heapcheck contrib module	Robert Haas	19:16
Re: [Patch] Optimize dropping of relation buffers using dlist	Andres Freund	19:17
Re: Comment simplehash/dynahash trade-offs 📎	James Coleman	19:22
Re: Creating a function for exposing memory usage of backend process	Robert Haas	19:23
Re: Control your disk usage in PG: Introduction to Disk Quota Extension	Daniel Gustafsson	19:35
Re: [HACKERS] [PATCH] Generic type subscripting	Tom Lane	19:35
Re: Improving connection scalability: GetSnapshotData()	Daniel Gustafsson	19:43
Re: ModifyTable overheads in generic plans	Robert Haas	19:46
Re: [Patch] Optimize dropping of relation buffers using dlist	Tom Lane	19:50
Re: [Patch] Use internal pthreads reimplementation only when building with MSVC	Daniel Gustafsson	19:53
Re: expose parallel leader in CSV and log_line_prefix 📎	Justin Pryzby	20:04
Re: Nicer error when connecting to standby with hot_standby=off 📎	James Coleman	20:18
Re: [Patch] Optimize dropping of relation buffers using dlist	Andres Freund	20:23
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits	Robert Haas	20:28
Re: Support for NSS as a libpq TLS backend 📎	Andrew Dunstan	20:44
Re: display offset along with block number in vacuum errors	Justin Pryzby	21:55
Re: Cache relation sizes? 📎	Thomas Munro	21:56
Confusing behavior of create table like 📎	Konstantin Knizhnik	22:06

Aug. 1, 2020

Thread	Author	Time
Re: Comment simplehash/dynahash trade-offs	Thomas Munro	00:16
Re: Concurrency bug in amcheck	Peter Geoghegan	00:23
Re: [PATCH] - Provide robust alternatives for replace_string	Alvaro Herrera	01:52
Re: windows config.pl question	Dmitry Markman	02:41
Re: Include access method in listTables output	vignesh C	02:42
Re: windows config.pl question	Michael Paquier	02:58
Re: windows config.pl question	Dmitry Markman	03:05
Can a background worker exist without shared memory access for EXEC_BACKEND cases? 📎	Bharath Rupireddy	03:13
Re: expose parallel leader in CSV and log_line_prefix 📎	Justin Pryzby	03:31
Re: Parallel copy 📎	vignesh C	04:24
Re: display offset along with block number in vacuum errors 📎	Justin Pryzby	06:17
Re: display offset along with block number in vacuum errors 📎	Mahendra Singh Thalor	07:01
Re: psql - improve test coverage from 41% to 88%	Fabien COELHO	07:06
Re: Getting rid of some more lseek() calls	Thomas Munro	12:24
Re: display offset along with block number in vacuum errors	Justin Pryzby	13:49
Re: [HACKERS] [PATCH] Generic type subscripting	Dmitry Dolgov	14:33
Re: Comment simplehash/dynahash trade-offs	James Coleman	18:15
Re: [PATCH] Btree BackwardScan race condition on Standby during VACUUM 📎	Peter Geoghegan	18:30
Re: psql - improve test coverage from 41% to 88%	Daniel Gustafsson	20:42
Re: Rethinking opclass member checks and dependency strength	Tom Lane	21:17
Re: [PATCH] Btree BackwardScan race condition on Standby during VACUUM	Daniel Gustafsson	21:22
Re: psql - improve test coverage from 41% to 88%	Tom Lane	21:27
Re: Autovacuum on partitioned table (autoanalyze)	Daniel Gustafsson	21:50
Re: Default gucs for EXPLAIN	Daniel Gustafsson	22:00
Re: Default gucs for EXPLAIN	Justin Pryzby	22:12
Re: Comment simplehash/dynahash trade-offs	David Rowley	23:16

Aug. 2, 2020

Thread	Author	Time
Re: Re: fixing pg_ctl with relative paths	Chapman Flack	00:51
Re: Comment simplehash/dynahash trade-offs 📎	David Rowley	01:53
Re: Use of "long" in incremental sort code	David Rowley	02:26
Re: display offset along with block number in vacuum errors	Masahiko Sawada	04:02
Re: display offset along with block number in vacuum errors	Justin Pryzby	04:24
LDAP check flapping on crake due to race	Thomas Munro	05:29
Re: LDAP check flapping on crake due to race	Noah Misch	06:10
Re: SimpleLruTruncate() mutual exclusion	Noah Misch	06:11
Re: OpenSSL randomness seeding	Noah Misch	06:48
Re: OpenSSL randomness seeding	Michael Paquier	07:05
Re: problem with RETURNING and update row movement 📎	Etsuro Fujita	08:57
Re: Index Skip Scan (new UniqueKeys)	Andy Fan	10:36
Re: [HACKERS] [PATCH] Generic type subscripting	Pavel Stehule	10:50
Fix for configure error in 9.5/9.6 on macOS 11.0 Big Sur	Thomas Gilligan	15:04
Re: psql - improve test coverage from 41% to 88%	Andrew Dunstan	15:10
Re: [PATCH] Btree BackwardScan race condition on Standby during VACUUM	Michail Nikolaev	16:07
Re: LDAP check flapping on crake due to race	Tom Lane	16:09
Removing <@ from contrib/intarray's GiST opclasses 📎	Tom Lane	17:37
FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689)	Justin Pryzby	18:11
Re: Default gucs for EXPLAIN	Daniel Gustafsson	20:43
Re: Fix for configure error in 9.5/9.6 on macOS 11.0 Big Sur	Tom Lane	21:18
Re: OpenSSL randomness seeding	Daniel Gustafsson	21:24
Re: MultiXact\SLRU buffers configuration	Daniel Gustafsson	21:30
Re: doc: vacuum full, fillfactor, and "extra space"	Daniel Gustafsson	21:54
Re: [Proposal] Add accumulated statistics for wait event	Daniel Gustafsson	22:00
Re: TRUNCATE on foreign tables	Daniel Gustafsson	22:19
Re: Comment simplehash/dynahash trade-offs	Thomas Munro	23:09
Re: Comment simplehash/dynahash trade-offs	David Rowley	23:36
Re: Comment simplehash/dynahash trade-offs	David Rowley	23:42

Browse Archives

Prev | Next