pgsql-hackers since 2020-11-03 16:44

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

Nov. 3, 2020

Thread	Author	Time
Re: PATCH: Batch/pipelining support for libpq	Matthieu Garrigues	16:44
Re: [PATCH] remove pg_archivecleanup and pg_standby	Robert Haas	16:49
Re: Online checksums verification in the backend	Robert Haas	16:52
Why does to_json take "anyelement" rather than "any"?	Nikhil Benesch	16:53
Re: PATCH: Batch/pipelining support for libpq	David G. Johnston	17:20
Re: patch: reduce overhead of execution of CALL statement in no atomic mode from PL/pgSQL 📎	Pavel Stehule	17:27
Re: automatic analyze: readahead - add "IO read time" log message 📎	Stephen Frost	17:47
Re: cutting down the TODO list thread	John Naylor	18:06
Re: remove spurious CREATE INDEX CONCURRENTLY wait	Dmitry Dolgov	18:14
Re: Dumping/restoring fails on inherited generated column	Peter Eisentraut	19:23
Re: Deleting older versions in unique indexes to avoid page splits 📎	Peter Geoghegan	20:44
Re: Keep elog(ERROR) and ereport(ERROR) calls in the cold path	David Rowley	20:53
Re: enable_incremental_sort changes query behavior	Tomas Vondra	21:39
Re: Use of "long" in incremental sort code	Tomas Vondra	21:42
Re: Collation versioning	Thomas Munro	21:48
Re: Collation versioning	Tom Lane	21:52
Re: Collation versioning	Thomas Munro	21:56
Re: Collation versioning	Christoph Berg	22:14
Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY 📎	Alvaro Herrera	23:56

Nov. 4, 2020

Thread	Author	Time
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch 📎	Tom Lane	00:22
Re: Delay of standby shutdown	Soumyadeep Chakraborty	00:35
Re: Parallel INSERT (INTO ... SELECT ...)	Greg Nancarrow	00:41
Re: Move OpenSSL random under USE_OPENSSL_RANDOM	Michael Paquier	01:01
Fix brin_form_tuple to properly detoast data 📎	Tomas Vondra	01:05
Re: Dereference before NULL check (src/backend/storage/ipc/latch.c)	Kyotaro Horiguchi	01:09
Re: -O switch	Tom Lane	01:10
Re: Collation versioning 📎	Thomas Munro	01:20
Re: Online checksums verification in the backend	Michael Paquier	01:32
PANIC: could not fsync file "pg_multixact/..." since commit dee663f7843 📎	Tomas Vondra	01:32
Re: Collation versioning	Tom Lane	01:33
Re: Explicit NULL dereference (src/backend/utils/adt/ruleutils.c)	Kyotaro Horiguchi	01:41
Re: PANIC: could not fsync file "pg_multixact/..." since commit dee663f7843	Thomas Munro	01:49
Re: Collation versioning	David Rowley	01:56
Re: PANIC: could not fsync file "pg_multixact/..." since commit dee663f7843	Tomas Vondra	01:57
Re: Collation versioning	Thomas Munro	02:20
Re: ModifyTable overheads in generic plans	Amit Langote	02:32
RE: [Patch] Optimize dropping of relation buffers using dlist 📎	[email protected]	02:58
Re: list of extended statistics on psql 📎	Tatsuro Yamada	03:04
Re: Parallel INSERT (INTO ... SELECT ...)	Amit Kapila	03:19
RE: extension patch of CREATE OR REPLACE TRIGGER 📎	[email protected]	03:53
Re: "unix_socket_directories" should be GUC_LIST_INPUT?	Michael Paquier	03:59
Re: PANIC: could not fsync file "pg_multixact/..." since commit dee663f7843 📎	Thomas Munro	04:36
Re: [HACKERS] logical decoding of two-phase transactions 📎	Peter Smith	07:29
Re: Collation versioning 📎	Juan José Santamaría Flecha	07:44
Re: Collation versioning	Michael Paquier	08:10
Re: Collation versioning	Julien Rouhaud	08:21
Re: shared-memory based stats collector 📎	Kyotaro Horiguchi	08:39
Re: Online verification of checksums	Michael Paquier	08:48
Re: Collation versioning	Laurenz Albe	08:52
Some doubious code in pgstat.c 📎	Kyotaro Horiguchi	08:55
Re: Bogus documentation for bogus geometric operators 📎	Pavel Borisov	09:02
Re: Move OpenSSL random under USE_OPENSSL_RANDOM	Magnus Hagander	09:05
Re: Use standard SIGHUP and SIGTERM handlers in autoprewarm module 📎	Fujii Masao	09:06
Re: automatic analyze: readahead - add "IO read time" log message	Jakub Wartak	09:07
Re: Refactor pg_rewind code and make it work against a standby	Heikki Linnakangas	09:23
Re: [HACKERS] logical decoding of two-phase transactions	Ajin Cherian	09:26
Re: [HACKERS] logical decoding of two-phase transactions 📎	Ajin Cherian	09:31
Re: Bogus documentation for bogus geometric operators	Emre Hasegeli	09:32
Re: Bogus documentation for bogus geometric operators 📎	Pavel Borisov	09:43
Re: Some doubious code in pgstat.c	Amit Kapila	09:50
Re: [HACKERS] logical decoding of two-phase transactions	Amit Kapila	10:02
Re: [HACKERS] logical decoding of two-phase transactions	Ajin Cherian	10:15
Re: [Patch] Optimize dropping of relation buffers using dlist	Amit Kapila	10:29
Re: [HACKERS] logical decoding of two-phase transactions	Amit Kapila	10:32
Re: hash_array_extended() needs to pass down collation	Peter Eisentraut	11:51
Re: Support for NSS as a libpq TLS backend 📎	Daniel Gustafsson	13:09
Re: Support for NSS as a libpq TLS backend	Daniel Gustafsson	13:14
Re: Some doubious code in pgstat.c	Masahiko Sawada	13:49
Re: PANIC: could not fsync file "pg_multixact/..." since commit dee663f7843	Tomas Vondra	13:50
Re: automatic analyze: readahead - add "IO read time" log message	Tomas Vondra	14:19
Re: automatic analyze: readahead - add "IO read time" log message	Stephen Frost	14:30
Re: Use standard SIGHUP and SIGTERM handlers in autoprewarm module	Bharath Rupireddy	15:46
Re: "unix_socket_directories" should be GUC_LIST_INPUT?	Tom Lane	15:47
Making cancellations safe	Shay Rojansky	15:50
Re: automatic analyze: readahead - add "IO read time" log message 📎	Stephen Frost	16:02
Re: Getting rid of aggregate_dummy()	Tom Lane	16:32
Re: Online verification of checksums	Michael Banck	16:41
Re: automatic analyze: readahead - add "IO read time" log message	Tomas Vondra	16:46
Re: Compatible defaults for LEAD/LAG	Tom Lane	21:12
Re: Dereference before NULL check (src/backend/storage/ipc/latch.c)	Ranier Vilela	21:47
Re: Use of "long" in incremental sort code	David Rowley	21:58
Re: Compatible defaults for LEAD/LAG	Pavel Stehule	22:00
Re: Use of "long" in incremental sort code	Tomas Vondra	22:13
Re: Fix brin_form_tuple to properly detoast data 📎	Tomas Vondra	22:25
Re: Parallel Full Hash Join 📎	Melanie Plageman	22:33
Re: PANIC: could not fsync file "pg_multixact/..." since commit dee663f7843	Tomas Vondra	23:07
Re: Use of "long" in incremental sort code	James Coleman	23:53

Nov. 5, 2020

Thread	Author	Time
Re: "unix_socket_directories" should be GUC_LIST_INPUT? 📎	Michael Paquier	00:16
Re: overriding current_timestamp	thehesiod	00:39
array_cat anycompatible change is breaking xversion upgrade tests	Tom Lane	00:43
Re: PANIC: could not fsync file "pg_multixact/..." since commit dee663f7843	Thomas Munro	01:21
Re: [Patch] Optimize dropping of relation buffers using dlist	Kyotaro Horiguchi	01:22
Re: Log message for GSS connection is missing once connection authorization is successful.	Bharath Rupireddy	01:52
Re: Online verification of checksums	Michael Paquier	01:57
Re: Some doubious code in pgstat.c 📎	Kyotaro Horiguchi	02:18
Re: CLUSTER on partitioned index 📎	Justin Pryzby	02:23
Re: Log message for GSS connection is missing once connection authorization is successful.	Euler Taveira	02:25
Re: vacuum -vs reltuples on insert only index	Peter Geoghegan	02:44
RE: [Patch] Optimize dropping of relation buffers using dlist	[email protected]	02:56
Re: Use standard SIGHUP and SIGTERM handlers in autoprewarm module	Kyotaro Horiguchi	03:12
Re: Transactions involving multiple postgres foreign servers, take 2 📎	Masahiko Sawada	03:15
Re: Move OpenSSL random under USE_OPENSSL_RANDOM 📎	Michael Paquier	03:44
Re: Any objections to implementing LogicalDecodeMessageCB for pgoutput? 📎	David Pirotte	03:46
Re: Some doubious code in pgstat.c	Masahiko Sawada	04:14
Re: Log message for GSS connection is missing once connection authorization is successful.	Bharath Rupireddy	04:20
Re: extension patch of CREATE OR REPLACE TRIGGER	Peter Smith	04:21
Re: Autovacuum on partitioned table (autoanalyze) 📎	yuzuko	05:04
Re: Strange behavior with polygon and NaN 📎	Kyotaro Horiguchi	05:07
Re: [Patch] Optimize dropping of relation buffers using dlist	Amit Kapila	05:37
Re: Some doubious code in pgstat.c	Amit Kapila	06:18
Re: scram-sha-256 broken with FIPS and OpenSSL 1.0.2 📎	Michael Paquier	06:41
Re: Autovacuum on partitioned table (autoanalyze)	yuzuko	07:03
Re: Protect syscache from bloating with negative cache entries 📎	Kyotaro Horiguchi	07:26
Re: Move catalog toast table and index declarations	Peter Eisentraut	08:24
Re: [Patch] Optimize dropping of relation buffers using dlist	Kyotaro Horiguchi	08:29
Re: [PoC] Non-volatile WAL buffer	Takashi Menjo	08:35
Re: Some doubious code in pgstat.c	Kyotaro Horiguchi	08:43
Re: Protect syscache from bloating with negative cache entries	Heikki Linnakangas	09:09
Re: Some doubious code in pgstat.c	Amit Kapila	09:20
Re: [Patch] Optimize dropping of relation buffers using dlist	Amit Kapila	09:48
Re: Move OpenSSL random under USE_OPENSSL_RANDOM	Daniel Gustafsson	09:49
Re: Multi Inserts in CREATE TABLE AS - revived patch	Bharath Rupireddy	11:03
Re: Move catalog toast table and index declarations	John Naylor	11:59
Re: Move OpenSSL random under USE_OPENSSL_RANDOM	Michael Paquier	12:12
Re: Move OpenSSL random under USE_OPENSSL_RANDOM	Daniel Gustafsson	12:18
redundant error messages 📎	Peter Eisentraut	12:27
Re: Move OpenSSL random under USE_OPENSSL_RANDOM	Michael Paquier	12:28
Re: libpq compression	Matthias van de Meent	12:40
Re: ModifyTable overheads in generic plans	Amit Langote	12:54
Re: Move OpenSSL random under USE_OPENSSL_RANDOM	Magnus Hagander	12:56
Re: Move OpenSSL random under USE_OPENSSL_RANDOM 📎	Daniel Gustafsson	12:59
RE: Parallel copy	Hou, Zhijie	13:02
Re: redundant error messages	Euler Taveira	13:34
Re: pg_ls_tmpdir to show directories and shared filesets (and pg_ls_*) 📎	Justin Pryzby	13:51
Re: redundant error messages	Isaac Morland	14:49
Re: enable pg_stat_statements to track rows processed by REFRESH MATERIALIZED VIEW 📎	Seino Yuki	14:54
Re: How to retain lesser paths at add_path()?	Dmitry Dolgov	15:41
Re: redundant error messages	Alvaro Herrera	15:53
Re: libpq compression	Konstantin Knizhnik	16:01
REFRESH MATERIALIZED VIEW and completion tag output	Fujii Masao	16:20
Re: REFRESH MATERIALIZED VIEW and completion tag output	Mark Dilger	16:56
Re: Yet another fast GiST build	Andrey Borodin	17:11
Re: Fix brin_form_tuple to properly detoast data 📎	Alvaro Herrera	17:17
Re: Yet another fast GiST build	Justin Pryzby	17:20
Re: Fix brin_form_tuple to properly detoast data	Tomas Vondra	17:42
Re: libpq compression	Matthias van de Meent	18:07
Re: Move catalog toast table and index declarations	Peter Eisentraut	18:20
Re: libpq compression	Peter Eisentraut	19:22
list_free() in index_get_partition() 📎	Justin Pryzby	20:36
Re: default result formats setting	Peter Eisentraut	20:48
Re: default result formats setting	Peter Eisentraut	21:03
Re: Fix brin_form_tuple to properly detoast data	Alvaro Herrera	21:16
Re: Reduce the number of special cases to build contrib modules on windows 📎	David Rowley	21:51
Re: Collation versioning	Thomas Munro	21:56
Re: Hybrid Hash/Nested Loop joins and caching results from subplans	David Rowley	22:12
Re: Why does to_json take "anyelement" rather than "any"?	Mohamed Wael Khobalatte	22:42
Re: [Patch] Optimize dropping of relation buffers using dlist	Thomas Munro	23:31
Re: Move OpenSSL random under USE_OPENSSL_RANDOM	Michael Paquier	23:36
RE: extension patch of CREATE OR REPLACE TRIGGER 📎	[email protected]	23:57

Nov. 6, 2020

Thread	Author	Time
Re: shared-memory based stats collector 📎	Kyotaro Horiguchi	00:27
Re: list_free() in index_get_partition()	Michael Paquier	00:32
Re: Why does to_json take "anyelement" rather than "any"?	David G. Johnston	00:38
Re: REFRESH MATERIALIZED VIEW and completion tag output	Fujii Masao	00:45
Re: Add statistics to pg_stat_wal view for wal related parameter tuning 📎	Masahiro Ikeda	01:25
Re: Why does to_json take "anyelement" rather than "any"?	Nikhil Benesch	01:45
Re: Why does to_json take "anyelement" rather than "any"?	Tom Lane	01:58
RE: pgbench: option delaying queries till connections establishment?	[email protected]	02:15
Re: Add Information during standby recovery conflicts	Masahiko Sawada	02:21
subscribing	meission	02:26
Re: [HACKERS] logical decoding of two-phase transactions 📎	Ajin Cherian	03:10
RE: [Patch] Optimize dropping of relation buffers using dlist	[email protected]	03:44
Re: Why does to_json take "anyelement" rather than "any"?	Nikhil Benesch	03:51
Re: Dumping/restoring fails on inherited generated column	Masahiko Sawada	03:55
Re: [Patch] Optimize dropping of relation buffers using dlist	Amit Kapila	04:10
Re: Implementing Incremental View Maintenance 📎	Justin Pryzby	04:58
Re: REFRESH MATERIALIZED VIEW and completion tag output	Mark Dilger	05:07
Re: extension patch of CREATE OR REPLACE TRIGGER 📎	Peter Smith	05:24
Re: Why does to_json take "anyelement" rather than "any"?	Pavel Stehule	05:25
Re: default result formats setting	Pavel Stehule	05:36
Re: [Patch] Optimize dropping of relation buffers using dlist	Thomas Munro	05:40
Re: libpq compression	Konstantin Knizhnik	06:18
Re: libpq compression	Konstantin Knizhnik	06:28
Re: libpq compression	Andrey Borodin	06:58
Refactor MD5 implementations and switch to EVP for OpenSSL 📎	Michael Paquier	07:34
RE: extension patch of CREATE OR REPLACE TRIGGER 📎	[email protected]	08:06
Re: Protect syscache from bloating with negative cache entries	Kyotaro Horiguchi	08:24
Re: Protect syscache from bloating with negative cache entries 📎	Kyotaro Horiguchi	08:29
Re: Protect syscache from bloating with negative cache entries	Heikki Linnakangas	08:42
Advance xmin aggressively on Read Commit isolation level	Andy Fan	08:48
Re: Advance xmin aggressively on Read Commit isolation level	Thomas Munro	08:53
Re: Move OpenSSL random under USE_OPENSSL_RANDOM	Daniel Gustafsson	11:08
Re: Some doubious code in pgstat.c	Amit Kapila	11:10
Re: Corruption during WAL replay	Masahiko Sawada	11:40
Re: [Patch] Optimize dropping of relation buffers using dlist	Amit Kapila	11:40
Re: Move OpenSSL random under USE_OPENSSL_RANDOM	Magnus Hagander	12:31
Re: Allow some recovery parameters to be changed with reload 📎	Sergei Kornilov	12:36
Re: Move catalog toast table and index declarations	John Naylor	13:00
Re: Any objections to implementing LogicalDecodeMessageCB for pgoutput?	Ashutosh Bapat	13:05
Re: Move OpenSSL random under USE_OPENSSL_RANDOM	Michael Paquier	13:27
Re: bitmaps and correlation	Anastasia Lubennikova	13:51

Browse Archives

Prev | Next