pgsql-hackers since 2020-10-24 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

Oct. 24, 2020

Thread	Author	Time
Re: speed up unicode decomposition and recomposition 📎	Michael Paquier	00:02
Re: minor problem in boolean cast	Tom Lane	00:04
Re: speed up unicode decomposition and recomposition	Tom Lane	00:24
Re: Tab complete for alter table rls	Michael Paquier	01:49
Re: [doc] remove reference to pg_dump pre-8.1 switch behaviour	Tom Lane	02:31
Re: Tab complete for alter table rls	Li Japin	04:09
Re: speed up unicode decomposition and recomposition	Michael Paquier	05:25
Re: Deleting older versions in unique indexes to avoid page splits	Simon Riggs	09:55
Re: [doc] remove reference to pg_dump pre-8.1 switch behaviour	Stephen Frost	13:02
Re: Move catalog toast table and index declarations	John Naylor	13:23
Re: Deleting older versions in unique indexes to avoid page splits	Peter Geoghegan	15:01
Re: Timing of relcache inval at parallel worker init	Noah Misch	15:29
Re: Index Skip Scan (new UniqueKeys) 📎	Dmitry Dolgov	16:45
Re: pg_dump, ATTACH, and independently restorable child partitions 📎	Justin Pryzby	19:59

Oct. 25, 2020

Thread	Author	Time
Re: Parallel Append can break run-time partition pruning 📎	David Rowley	01:06
Fix typo in src/backend/utils/cache/lsyscache.c 📎	Hou, Zhijie	01:22
Re: Collation versioning 📎	Thomas Munro	02:35
Re: pgstat_report_activity() and parallel CREATE INDEX (was: Parallel index creation & pg_stat_activity) 📎	Noah Misch	05:18
Re: [PATCH] Add section headings to index types doc 📎	Jürgen Purtz	09:40
Re: Fix typo in src/backend/utils/cache/lsyscache.c	David Rowley	09:42
Re: Collation versioning	Julien Rouhaud	11:13
Supporting = operator in gin/gist_trgm_ops	Julien Rouhaud	11:32
Re: pgstat_report_activity() and parallel CREATE INDEX (was: Parallel index creation & pg_stat_activity)	Tom Lane	14:52
Re: deferred primary key and logical replication	Euler Taveira	16:09
Re: pgstat_report_activity() and parallel CREATE INDEX (was: Parallel index creation & pg_stat_activity) 📎	Noah Misch	16:42
Re: pgstat_report_activity() and parallel CREATE INDEX (was: Parallel index creation & pg_stat_activity)	Tom Lane	17:40
Re: Commitfest manager 2020-11	Anastasia Lubennikova	18:01
Re: bulk typos 📎	Justin Pryzby	19:48
Re: bulk typos	Heikki Linnakangas	21:00
Re: Supporting = operator in gin/gist_trgm_ops	Tom Lane	21:03
Re: bulk typos	Tom Lane	21:12
Re: [doc] remove reference to pg_dump pre-8.1 switch behaviour	Justin Pryzby	21:56
Re: POC: contrib/unaccent as IMMUTABLE	Thomas Munro	22:48

Oct. 26, 2020

Thread	Author	Time
Re: Allow deleting enum value	Justin Pryzby	00:33
Re: Mop-up around psql's \connect behavior	Kyotaro Horiguchi	00:51
Re: MultiXact\SLRU buffers configuration 📎	Alexander Korotkov	01:05
Re: [patch] Fix checksum verification in base backups for zero page headers 📎	Michael Paquier	01:13
A couple questions about ordered-set aggregates	Chapman Flack	01:32
Re: [HACKERS] logical decoding of two-phase transactions 📎	Peter Smith	03:25
Re: Supporting = operator in gin/gist_trgm_ops 📎	Julien Rouhaud	04:02
Re: Supporting = operator in gin/gist_trgm_ops 📎	Julien Rouhaud	04:10
Re: The ultimate extension hook.	Daniel Wood	04:18
Re: Supporting = operator in gin/gist_trgm_ops	Tom Lane	04:19
Re: Supporting = operator in gin/gist_trgm_ops	Julien Rouhaud	04:38
Re: [doc] remove reference to pg_dump pre-8.1 switch behaviour	Heikki Linnakangas	07:18
Re: [HACKERS] logical decoding of two-phase transactions	Peter Smith	07:49
default result formats setting 📎	Peter Eisentraut	08:31
RE: pgbench: option delaying queries till connections establishment?	[email protected]	08:31
Should the function get_variable_numdistinct consider the case when stanullfrac is 1.0? 📎	Zhenghua Lyu	08:42
Re: POC: GROUP BY optimization 📎	Pavel Borisov	08:44
Re: default result formats setting	Pavel Stehule	08:45
Re: POC: GROUP BY optimization	Dmitry Dolgov	08:57
Re: select_common_typmod	Heikki Linnakangas	09:05
Re: POC: GROUP BY optimization	Pavel Borisov	09:28
Re: POC: GROUP BY optimization	Dmitry Dolgov	10:40
Re: pgbench - add pseudo-random permutation function	Muhammad Usama	10:52
automatic analyze: readahead - add "IO read time" log message 📎	Jakub Wartak	12:21
Re: Collation versioning	Julien Rouhaud	12:33
PATCH: Report libpq version and configuration 📎	Craig Ringer	12:56
Re: Additional Chapter for Tutorial 📎	Jürgen Purtz	13:33
Re: new heapcheck contrib module	Robert Haas	13:37
Re: new heapcheck contrib module	Mark Dilger	13:56
Re: new heapcheck contrib module	Robert Haas	14:00
Re: Internal key management system	Craig Ringer	14:05
Re: [PoC] Non-volatile WAL buffer	Heikki Linnakangas	14:07
Re: new heapcheck contrib module	Mark Dilger	14:08
Re: new heapcheck contrib module	Tom Lane	14:13
Re: libpq compression 📎	Konstantin Knizhnik	14:22
Re: default result formats setting	Tom Lane	14:35
Re: Should the function get_variable_numdistinct consider the case when stanullfrac is 1.0?	Tom Lane	14:37
Re: Additional Chapter for Tutorial	David G. Johnston	14:53
Re: Should the function get_variable_numdistinct consider the case when stanullfrac is 1.0?	Zhenghua Lyu	15:01
Re: Internal key management system	Stephen Frost	15:02
Re: new heapcheck contrib module	Andres Freund	15:27
Re: automatic analyze: readahead - add "IO read time" log message	Stephen Frost	15:44
Re: MultiXact\SLRU buffers configuration	Andrey Borodin	15:45
Re: new heapcheck contrib module 📎	Mark Dilger	16:11
Re: new heapcheck contrib module	Tom Lane	16:12
Re: libpq compression 📎	Konstantin Knizhnik	16:20
Re: libpq debug log 📎	Alvaro Herrera	16:23
Re: new heapcheck contrib module	Mark Dilger	16:28
Re: PATCH: Report libpq version and configuration	Alvaro Herrera	16:41
Re: PATCH: Report libpq version and configuration	Abhijit Menon-Sen	16:55
Re: PATCH: Report libpq version and configuration	Tom Lane	16:56
Re: Supporting = operator in gin/gist_trgm_ops	Alexander Korotkov	17:50
Commitfest 2020-11	Anastasia Lubennikova	18:09
Re: PATCH: Batch/pipelining support for libpq 📎	Alvaro Herrera	19:09
Re: Commitfest 2020-11	Fabrízio de Royes Mello	19:47
Re: Wrong example in the bloom documentation	Bruce Momjian	21:04
Re: Deleting older versions in unique indexes to avoid page splits 📎	Peter Geoghegan	21:15
Re: Improve pg_dump dumping publication tables	John Hsu	21:43
Add important info about ANALYZE after create Functional Index	Fabrízio de Royes Mello	22:08
Re: Add important info about ANALYZE after create Functional Index	David G. Johnston	22:46
Re: Wrong example in the bloom documentation 📎	Bruce Momjian	23:18
Re: Non-configure build of thread_test has been broken for awhile	Bruce Momjian	23:30

Oct. 27, 2020

Thread	Author	Time
Re: Commitfest 2020-11	Michael Paquier	00:21
Re: Add Information during standby recovery conflicts 📎	Masahiko Sawada	00:41
Re: PATCH: Report libpq version and configuration	Craig Ringer	00:51
Re: Add important info about ANALYZE after create Functional Index	Nikolay Samokhvalov	01:29
Re: Add important info about ANALYZE after create Functional Index	David G. Johnston	02:03
Re: Commitfest 2020-11	Julien Rouhaud	02:11
Re: pg_upgrade: fail early if a tablespace dir already exists for new cluster version	Bruce Momjian	02:17
Re: Resetting spilled txn statistics in pg_stat_replication	Justin Pryzby	03:21
Re: Autovacuum on partitioned table (autoanalyze)	Justin Pryzby	03:22
[PATCH] remove deprecated v8.2 containment operators 📎	Justin Pryzby	03:25
Re: Parallel INSERT (INTO ... SELECT ...) 📎	Greg Nancarrow	03:45
Patch to fix FK-related selectivity estimates with constants 📎	Tom Lane	03:47
Re: Resetting spilled txn statistics in pg_stat_replication 📎	Amit Kapila	03:47
Re: Add important info about ANALYZE after create Functional Index	Nikolay Samokhvalov	04:44
Re: PATCH: Report libpq version and configuration 📎	Craig Ringer	04:49
Re: [HACKERS] Custom compression methods 📎	Dilip Kumar	05:24
Re: Assertion failure when ATTACH partition followed by CREATE PARTITION. 📎	Amul Sul	05:26
RE: extension patch of CREATE OR REPLACE TRIGGER	[email protected]	06:07
Re: Parallel Append can break run-time partition pruning	Amit Langote	06:39
Re: Internal key management system	Craig Ringer	07:07
Re: Online checksums verification in the backend 📎	Michael Paquier	07:07
Re: Add important info about ANALYZE after create Functional Index 📎	Nikolay Samokhvalov	07:12
Multiple hosts in connection string failed to failover in non-hot standby mode	Hubert Zhang	07:14
Question about make coverage-html	Peter Smith	08:09
Re: Make procedure OUT parameters work with JDBC	Peter Eisentraut	08:12
Re: [patch] [doc] Clarify that signal functions have no feedback	Peter Eisentraut	08:19
Re: [PATCH] Runtime control of CLOBBER_CACHE_ALWAYS	Peter Eisentraut	08:34
Re: [PATCH] remove deprecated v8.2 containment operators	Peter Eisentraut	08:38
Re: [PATCH] remove deprecated v8.2 containment operators	Magnus Hagander	08:46
Re: Commitfest manager 2020-11	gkokolatos	08:57
Re: Question about make coverage-html	Heikki Linnakangas	09:17
RE: Multiple hosts in connection string failed to failover in non-hot standby mode	[email protected]	09:30
Use-after-free in 12- EventTriggerAlterTableEnd 📎	Arseny Sher	09:36
Re: Deleting older versions in unique indexes to avoid page splits	Simon Riggs	09:43
Re: [HACKERS] logical decoding of two-phase transactions 📎	Ajin Cherian	09:54
Re: Re: parallel distinct union and aggregate support patch	Dilip Kumar	09:57
Re: Parallel INSERT (INTO ... SELECT ...)	Amit Kapila	09:57
Re: pg_upgrade analyze script	Peter Eisentraut	10:33
Re: Prevent printing "next step instructions" in initdb and pg_upgrade	Peter Eisentraut	10:35
Re: "unix_socket_directories" should be GUC_LIST_INPUT?	Peter Eisentraut	10:42
Re: deferred primary key and logical replication	Amit Kapila	10:46
Re: Prevent printing "next step instructions" in initdb and pg_upgrade	Bruce Momjian	10:53
Re: [patch] ENUM errdetail should mention bytes, not chars	Peter Eisentraut	11:00
Re: Prevent printing "next step instructions" in initdb and pg_upgrade	Magnus Hagander	11:05
Re: Internal key management system	Bruce Momjian	11:15
Re: Internal key management system	Bruce Momjian	11:34
Re: Prevent printing "next step instructions" in initdb and pg_upgrade	Peter Eisentraut	11:35
Re: Prevent printing "next step instructions" in initdb and pg_upgrade	Bruce Momjian	11:40
Re: Move catalog toast table and index declarations	Peter Eisentraut	11:42
Re: Yet another fast GiST build	Heikki Linnakangas	11:43
Re: Online checksums verification in the backend	Julien Rouhaud	11:47
Re: Move catalog toast table and index declarations	John Naylor	12:12
Re: parallel distinct union and aggregate support patch	Robert Haas	12:12
duplicate function oid symbols	John Naylor	12:43
Re: partition routing layering in nodeModifyTable.c	Heikki Linnakangas	13:23
Re: Parallel copy 📎	vignesh C	13:36
Re: SQL-standard function body 📎	Peter Eisentraut	13:45
Re: "unix_socket_directories" should be GUC_LIST_INPUT?	Tom Lane	13:45
Re: duplicate function oid symbols	Tom Lane	13:51
Re: posgres 12 bug (partitioned table) 📎	Pavel Biryukov	13:55
Re: Internal key management system	Craig Ringer	14:02
Re: Add important info about ANALYZE after create Functional Index	Fabrízio de Royes Mello	14:06
Re: SQL:2011 PERIODS vs Postgres Ranges? 📎	Ibrar Ahmed	14:11
Re: Add important info about ANALYZE after create Functional Index	Fabrízio de Royes Mello	14:11
Re: Question about make coverage-html	Tom Lane	14:19
Re: Internal key management system	Bruce Momjian	14:20
Re: Re: parallel distinct union and aggregate support patch	Dilip Kumar	14:22
Re: parallel distinct union and aggregate support patch	Dilip Kumar	14:23
Re: automatic analyze: readahead - add "IO read time" log message 📎	Jakub Wartak	15:06
Re: Parallel copy	vignesh C	15:22
Re: Parallel copy	vignesh C	15:23
Re: Parallel copy	vignesh C	15:26
Re: Parallel copy	vignesh C	15:33
Re: automatic analyze: readahead - add "IO read time" log message	Stephen Frost	15:35
Re: Parallel copy	vignesh C	15:37
Re: Implementing Incremental View Maintenance 📎	Adam Brusselback	16:14
Re: "unix_socket_directories" should be GUC_LIST_INPUT?	Robert Haas	16:19
Re: "unix_socket_directories" should be GUC_LIST_INPUT?	Tom Lane	16:23
Re: SQL:2011 PERIODS vs Postgres Ranges?	Paul Jungwirth	16:34
Re: MultiXact\SLRU buffers configuration 📎	Alexander Korotkov	17:02
Re: select_common_typmod	Peter Eisentraut	17:12
Re: MultiXact\SLRU buffers configuration 📎	Alexander Korotkov	17:23
Re: CREATE TABLE .. PARTITION OF fails to preserve tgenabled for inherited row triggers 📎	Justin Pryzby	17:43
Re: Patch to fix FK-related selectivity estimates with constants 📎	Tom Lane	17:58
Re: Deleting older versions in unique indexes to avoid page splits	Peter Geoghegan	18:35
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits	Anastasia Lubennikova	19:16
Re: Use-after-free in 12- EventTriggerAlterTableEnd	Tom Lane	19:21
cutting down the TODO list thread	John Naylor	19:24
Re: SEARCH and CYCLE clauses	Anastasia Lubennikova	19:31
Re: cutting down the TODO list thread	Andres Freund	19:36
Re: cutting down the TODO list thread	Bruce Momjian	19:46
Re: cutting down the TODO list thread	Bruce Momjian	19:52
Re: [patch] Fix checksum verification in base backups for zero page headers	Anastasia Lubennikova	19:56
More aggressive vacuuming of unlogged relations?	Andres Freund	19:58
Re: cutting down the TODO list thread	Thomas Munro	20:00
Re: Support for NSS as a libpq TLS backend 📎	Daniel Gustafsson	20:07
Re: Support for NSS as a libpq TLS backend	Heikki Linnakangas	20:18
Re: cutting down the TODO list thread	John Naylor	20:19
Re: POC: GROUP BY optimization	Tomas Vondra	20:19
Re: cutting down the TODO list thread	John Naylor	20:54
Re: duplicate function oid symbols 📎	John Naylor	21:40
Re: cutting down the TODO list thread	Bruce Momjian	22:05
Re: Question about make coverage-html	Peter Smith	23:04
Re: Patch to fix FK-related selectivity estimates with constants	Tomas Vondra	23:18
Re: Resetting spilled txn statistics in pg_stat_replication	Justin Pryzby	23:19

Browse Archives

Prev | Next