pgsql-hackers since 2020-09-11 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

Sept. 11, 2020

Thread	Author	Time
Re: Logical Replication - detail message with names of missing columns	Kyotaro Horiguchi	01:14
Re: logtape.c stats don't account for unused "prefetched" block numbers	Peter Geoghegan	01:42
Re: Implement UNLOGGED clause for COPY FROM	Peter Smith	01:43
Re: Fix for parallel BTree initialization bug	Justin Pryzby	02:37
Re: SIGQUIT handling, redux 📎	Tom Lane	02:40
Re: Inconsistency in determining the timestamp of the db statfile.	Amit Kapila	02:52
Re: Transactions involving multiple postgres foreign servers, take 2	Fujii Masao	02:58
Re: New statistics for tuning WAL buffer size	Kyotaro Horiguchi	03:17
Re: New statistics for tuning WAL buffer size	Fujii Masao	04:48
RE: Implement UNLOGGED clause for COPY FROM	tsunakawa.takay@fujitsu.com	05:15
Re: Fix for parallel BTree initialization bug	Hunter, James	05:32
Re: Optimising compactify_tuples()	Thomas Munro	05:44
Re: Optimising compactify_tuples()	Thomas Munro	05:48
Re: Yet another fast GiST build	Andrey M. Borodin	06:02
Corner-case bug in pg_rewind 📎	Ian Barwick	06:42
Re: Improvements in Copy From	Kyotaro Horiguchi	06:58
Re: Range checks of pg_test_fsync --secs-per-test and pg_test_timing --duration	Michael Paquier	07:08
Re: track_planning causing performance regression	bttanakahbk	07:23
Re: Online checksums verification in the backend	Michael Paquier	07:34
Re: Online checksums verification in the backend	Julien Rouhaud	07:49
Re: Additional Chapter for Tutorial	Jürgen Purtz	07:49
Re: New statistics for tuning WAL buffer size	Kyotaro Horiguchi	07:54
Re: New statistics for tuning WAL buffer size	Fujii Masao	08:13
RE: Transactions involving multiple postgres foreign servers, take 2	tsunakawa.takay@fujitsu.com	08:15
Re: Implement UNLOGGED clause for COPY FROM	Kyotaro Horiguchi	08:36
TDE (Transparent Data Encryption) supported ?	laurent.feron	08:41
copyright problem in REL_13_STABLE	Wang, Shenhao	08:42
Re: Improvements in Copy From	Peter Smith	08:44
Re: proposal: possibility to read dumped table's name from file	Pavel Stehule	08:50
Re: Implement UNLOGGED clause for COPY FROM	Kyotaro Horiguchi	08:57
Re: Bug in logical decoding of in-progress transactions	Amit Kapila	09:03
Re: Improvements in Copy From	Kyotaro Horiguchi	09:04
RE: Transactions involving multiple postgres foreign servers, take 2	tsunakawa.takay@fujitsu.com	09:24
RE: Implement UNLOGGED clause for COPY FROM	tsunakawa.takay@fujitsu.com	09:39
Re: WIP: BRIN multi-range indexes 📎	Tomas Vondra	10:14
Re: making update/delete of inheritance trees scale better 📎	Amit Langote	10:20
Re: On login trigger: take three 📎	Konstantin Knizhnik	10:42
Re: Transactions involving multiple postgres foreign servers, take 2	Masahiko Sawada	11:06
Re: copyright problem in REL_13_STABLE	Daniel Gustafsson	11:11
Re: Fix for parallel BTree initialization bug 📎	Amit Kapila	11:11
Re: TDE (Transparent Data Encryption) supported ?	Daniel Gustafsson	11:18
Avoid incorrect allocation in buildIndexArray 📎	Daniel Gustafsson	11:38
Re: Avoid incorrect allocation in buildIndexArray	Julien Rouhaud	11:49
Re: Avoid incorrect allocation in buildIndexArray	Ranier Vilela	11:56
pg_service.conf file with unknown parameters	Magnus Hagander	12:39
Re: Logical Replication - detail message with names of missing columns 📎	Bharath Rupireddy	12:42
Re: copyright problem in REL_13_STABLE	Alvaro Herrera	12:47
Re: Missing "Up" navigation link between parts and doc root?	Fabien COELHO	12:58
Re: pgbench and timestamps (bounced)	Fabien COELHO	13:59
Re: track_planning causing performance regression	Fujii Masao	14:04
Re: WIP: BRIN multi-range indexes	John Naylor	14:08
Re: Logical Replication - detail message with names of missing columns	Tom Lane	14:10
Re: Logical Replication - detail message with names of missing columns	Alvaro Herrera	14:35
Simplified version of read_binary_file (src/backend/utils/adt/genfile.c) 📎	Ranier Vilela	14:50
Re: Logical Replication - detail message with names of missing columns	Tom Lane	14:52
[patch] _bt_binsrch* improvements - equal-prefix-skip binary search 📎	Matthias van de Meent	14:57
Re: [Proposal] Global temporary tables 📎	曾文旌	15:00
Re: factorial function/phase out postfix operators?	Robert Haas	15:06
Re: TDE (Transparent Data Encryption) supported ?	Stephen Frost	15:19
Re: Logical Replication - detail message with names of missing columns	Alvaro Herrera	15:35
Re: factorial function/phase out postfix operators?	Tom Lane	15:36
Re: Logical Replication - detail message with names of missing columns	Tom Lane	15:41
Re: Making index_set_state_flags() transactional	Anastasia Lubennikova	15:42
Re: SIGQUIT handling, redux	Tom Lane	15:52
Re: factorial function/phase out postfix operators?	Mark Dilger	16:39
Re: Weird corner-case failure mode for VPATH builds	Robert Haas	16:53
Re: Weird corner-case failure mode for VPATH builds	Alvaro Herrera	16:58
Re: Simplified version of read_binary_file (src/backend/utils/adt/genfile.c)	Alvaro Herrera	17:01
Re: Simplified version of read_binary_file (src/backend/utils/adt/genfile.c)	Ranier Vilela	17:10
Re: [patch] _bt_binsrch* improvements - equal-prefix-skip binary search	Peter Geoghegan	17:41
Re: WIP: BRIN multi-range indexes 📎	Tomas Vondra	18:05
Re: Simplified version of read_binary_file (src/backend/utils/adt/genfile.c)	Andres Freund	18:09
Re: Weird corner-case failure mode for VPATH builds	Andres Freund	18:13
Re: factorial function/phase out postfix operators?	Tom Lane	18:25
Re: Simplified version of read_binary_file (src/backend/utils/adt/genfile.c)	Ranier Vilela	19:09
Re: WIP: BRIN multi-range indexes	John Naylor	19:19
Re: factorial function/phase out postfix operators?	Mark Dilger	19:23
Re: v13: show extended stats target in \d	Alvaro Herrera	19:26
Re: track_planning causing performance regression	Julien Rouhaud	19:41
Re: factorial function/phase out postfix operators?	Robert Haas	19:54
Re: factorial function/phase out postfix operators?	Mark Dilger	19:56
Re: Simplified version of read_binary_file (src/backend/utils/adt/genfile.c) 📎	Ranier Vilela	20:02
Re: Allow CURRENT_ROLE in GRANTED BY	Alvaro Herrera	20:05
Re: Parallel worker hangs while handling errors.	Tom Lane	20:20
Re: Parallel worker hangs while handling errors.	Robert Haas	20:23
Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY	Robert Haas	20:28
Re: problem with RETURNING and update row movement	Alvaro Herrera	20:42
Re: Simplified version of read_binary_file (src/backend/utils/adt/genfile.c)	Tom Lane	20:44
Re: factorial function/phase out postfix operators?	Tom Lane	20:51
Re: Binary search in ScalarArrayOpExpr for OR'd constant arrays	James Coleman	21:11
Re: Simplified version of read_binary_file (src/backend/utils/adt/genfile.c) 📎	Ranier Vilela	21:43
Re: track_planning causing performance regression	Alvaro Herrera	22:10
Re: track_planning causing performance regression	Andres Freund	22:32

Sept. 12, 2020

Thread	Author	Time
Re: 回复：how to create index concurrently on partitioned table	Justin Pryzby	00:13
Re: logtape.c stats don't account for unused "prefetched" block numbers	Peter Geoghegan	01:29
Re: 回复：how to create index concurrently on partitioned table	Michael Paquier	01:35
Re: logtape.c stats don't account for unused "prefetched" block numbers	Peter Geoghegan	01:37
Re: [Patch] ALTER SYSTEM READ ONLY	Amul Sul	05:22
Re: proposal: possibility to read dumped table's name from file 📎	Pavel Stehule	08:12
Re: Avoid incorrect allocation in buildIndexArray	Michael Paquier	09:13
Re: Avoid incorrect allocation in buildIndexArray	Julien Rouhaud	10:40
Re: [HACKERS] logical decoding of two-phase transactions	Amit Kapila	11:40
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Amit Kapila	11:47
Re: Inconsistency in determining the timestamp of the db statfile.	Amit Kapila	11:49
Function to execute a program	Magnus Hagander	13:12
Re: Inconsistency in determining the timestamp of the db statfile.	Magnus Hagander	13:17
Re: Logical Replication - detail message with names of missing columns 📎	Bharath Rupireddy	13:45
Re: Function to execute a program	Tom Lane	15:06
Re: Function to execute a program	Magnus Hagander	15:11
Re: Function to execute a program	Andrew Dunstan	15:36
Re: WIP: BRIN multi-range indexes 📎	Tomas Vondra	16:13
Re: Parallel worker hangs while handling errors. 📎	Tom Lane	17:57
Re: Missing "Up" navigation link between parts and doc root?	Peter Eisentraut	18:37
Re: recovering from "found xmin ... from before relfrozenxid ..."	Tom Lane	22:00

Sept. 13, 2020

Thread	Author	Time
How to get position in array with JSONPath	Pavel Stehule	06:22
Re: Transactions involving multiple postgres foreign servers, take 2	Masahiko Sawada	08:36
Re: [PATCH] Finally split StdRdOptions into HeapOptions and ToastOptions 📎	Nikolay Shaplov	16:04
Re: WIP: BRIN multi-range indexes 📎	Tomas Vondra	16:40
Re: Sometimes the output to the stdout in Windows disappears	Tom Lane	18:37
Re: Probable documentation errors or improvements	David G. Johnston	19:36
Gripes about walsender command processing 📎	Tom Lane	19:47
Minor documentation error regarding streaming replication protocol	Brar Piening	20:25
Re: Minor documentation error regarding streaming replication protocol	Brar Piening	20:33
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Tom Lane	21:38
Re: A micro-optimisation for walkdir()	Thomas Munro	22:42
Re: Gripes about walsender command processing	Tom Lane	23:00

Sept. 14, 2020

Thread	Author	Time
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Tom Lane	01:27
Re: Avoid incorrect allocation in buildIndexArray	Michael Paquier	01:45
typo in snapmgr.c and procarray.c 📎	btnakamichin	02:06
Re: typo in snapmgr.c and procarray.c	Fujii Masao	02:14
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Amit Kapila	02:28
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Tom Lane	02:48
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Amit Kapila	03:18
Re: ModifyTable overheads in generic plans 📎	Amit Langote	03:51
Re: Print logical WAL message content	Ashutosh Bapat	04:48
Re: Making index_set_state_flags() transactional	Michael Paquier	04:58
Re: typo in snapmgr.c and procarray.c	Fujii Masao	05:17
Re: Optimising compactify_tuples() 📎	David Rowley	05:27
Re: problem with RETURNING and update row movement	Amit Langote	06:53
Re: A micro-optimisation for walkdir()	Juan José Santamaría Flecha	07:51
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Dilip Kumar	07:53
Re: Gripes about walsender command processing	Michael Paquier	08:04
Re: TDE (Transparent Data Encryption) supported ?	laurent.feron	08:29
Re: problem with RETURNING and update row movement	Etsuro Fujita	08:56
unusual use of "path" in pg_verifybackup?	Peter Eisentraut	08:57
Re: On login trigger: take three	Pavel Stehule	09:44
Re: pg_dump --where option 📎	Surafel Temesgen	10:04
Re: recovering from "found xmin ... from before relfrozenxid ..." 📎	Ashutosh Sharma	10:26
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎	Amit Kapila	11:19
Re: Division in dynahash.c due to HASH_FFACTOR	David Rowley	11:34
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Dilip Kumar	11:37
Re: [PATCH] Automatic HASH and LIST partition creation 📎	Anastasia Lubennikova	11:38
Re: Avoid incorrect allocation in buildIndexArray	Ranier Vilela	11:49
Re: TDE (Transparent Data Encryption) supported ?	Hans-Jürgen Schönig (PostgreSQL)	12:01
Re: Use incremental sort paths for window functions	Daniel Gustafsson	12:02
pg_restore causing deadlocks on partitioned tables	Domagoj Smoljanovic	12:27
Re: Fix for parallel BTree initialization bug	Amit Kapila	12:37
Re: TDE (Transparent Data Encryption) supported ?	Stephen Frost	12:39
Fix overflow at return wchar2char (src/backend/utils/adt/pg_locale.c) 📎	Ranier Vilela	12:41
Re: problem with RETURNING and update row movement	Amit Langote	13:45
Re: Fix overflow at return wchar2char (src/backend/utils/adt/pg_locale.c)	Daniel Gustafsson	13:53
Re: On login trigger: take three 📎	Konstantin Knizhnik	14:12
Re: pg_restore causing deadlocks on partitioned tables	Tom Lane	14:17
Re: 回复：how to create index concurrently on partitioned table 📎	Justin Pryzby	14:31
Re: Function to execute a program	Stephen Frost	14:33
Re: On login trigger: take three	Pavel Stehule	14:34
Re: pg_restore causing deadlocks on partitioned tables	Alvaro Herrera	14:40
Re: Function to execute a program	Tom Lane	14:45
RE: pg_restore causing deadlocks on partitioned tables	Domagoj Smoljanovic	14:49
Re: Function to execute a program	Stephen Frost	14:57
Re: pg_dump --where option	Daniel Gustafsson	15:00
Subscription test 013_partition.pl fails under CLOBBER_CACHE_ALWAYS	Tom Lane	15:20
Re: pg_restore causing deadlocks on partitioned tables	Tom Lane	15:24
Re: On login trigger: take three	Konstantin Knizhnik	15:53
Re: Fix overflow at return wchar2char (src/backend/utils/adt/pg_locale.c)	Ranier Vilela	15:59
Re: On login trigger: take three	Pavel Stehule	16:11
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Tom Lane	16:12
Re: Gripes about walsender command processing 📎	Tom Lane	16:51
Re: Use incremental sort paths for window functions	Tomas Vondra	17:18
Re: Allow ERROR from heap_prepare_freeze_tuple to be downgraded to WARNING	Robert Haas	17:26
Re: Fix for parallel BTree initialization bug	Peter Geoghegan	17:55
Re: Fix overflow at return wchar2char (src/backend/utils/adt/pg_locale.c)	Tom Lane	18:07
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch	Ranier Vilela	18:11
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch	Tom Lane	18:33
Re: Allow ERROR from heap_prepare_freeze_tuple to be downgraded to WARNING	Andres Freund	18:39
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch	Ranier Vilela	18:53
Re: Allow ERROR from heap_prepare_freeze_tuple to be downgraded to WARNING	Alvaro Herrera	19:00
Re: pg_restore causing deadlocks on partitioned tables	Tom Lane	19:26
Re: Allow ERROR from heap_prepare_freeze_tuple to be downgraded to WARNING	Robert Haas	19:50
Re: Allow ERROR from heap_prepare_freeze_tuple to be downgraded to WARNING	Andres Freund	20:13
Re: Subscription test 013_partition.pl fails under CLOBBER_CACHE_ALWAYS	Neha Sharma	20:15
"Unified logging system" breaks access to pg_dump debug outputs 📎	Tom Lane	20:50
Re: Allow ERROR from heap_prepare_freeze_tuple to be downgraded to WARNING	Robert Haas	21:00
Re: Allow ERROR from heap_prepare_freeze_tuple to be downgraded to WARNING	Andres Freund	21:05
Re: logtape.c stats don't account for unused "prefetched" block numbers 📎	Peter Geoghegan	21:24
Re: Division in dynahash.c due to HASH_FFACTOR 📎	Thomas Munro	21:56
Re: logtape.c stats don't account for unused "prefetched" block numbers	Jeff Davis	22:20
Re: logtape.c stats don't account for unused "prefetched" block numbers	Alvaro Herrera	22:23
Re: pg_restore causing deadlocks on partitioned tables	Tom Lane	22:28
Re: logtape.c stats don't account for unused "prefetched" block numbers	Peter Geoghegan	22:39

Browse Archives

Prev | Next