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

Feb. 3, 2020

Thread	Author	Time
Re: Prevent pg_basebackup running as root	Ian Barwick	00:14
Portal->commandTag as an enum 📎	Mark Dilger	00:41
Re: table partitioning and access privileges 📎	Amit Langote	02:05
Re: Portal->commandTag as an enum	Tom Lane	02:14
Re: Autovacuum on partitioned table	Amit Langote	02:36
Re: Internal key management system	Chris Travers	02:37
Re: pg_stat_progress_basebackup - progress reporting for pg_basebackup, in the server side 📎	Fujii Masao	04:17
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Amit Kapila	04:21
Re: table partitioning and access privileges 📎	Fujii Masao	05:07
Re: table partitioning and access privileges	Amit Langote	05:26
Re: ERROR: subtransaction logged without previous top-level txn record	Amit Kapila	06:45
Re: Proposal: Add more compile-time asserts to expose inconsistencies.	Michael Paquier	06:55
Re: Add %x to PROMPT1 and PROMPT2	Michael Paquier	07:08
Re: Tid scan increments value of pg_stat_all_tables.seq_scan. (but not seq_tup_read)	Fujii Masao	07:22
Re: pg_stat_progress_basebackup - progress reporting for pg_basebackup, in the server side	Amit Langote	07:28
Re: pg_stat_progress_basebackup - progress reporting for pg_basebackup, in the server side	Amit Langote	07:30
Re: Tid scan increments value of pg_stat_all_tables.seq_scan. (but not seq_tup_read)	Kasahara Tatsuhito	07:39
Re: WIP: Aggregation push-down	Antonin Houska	07:46
Re: Parallel grouping sets	Richard Guo	08:07
Re: [Proposal] Global temporary tables	Konstantin Knizhnik	08:08
Re: [Proposal] Global temporary tables	Konstantin Knizhnik	08:16
Re: Tid scan increments value of pg_stat_all_tables.seq_scan. (but not seq_tup_read)	Fujii Masao	08:32
Re: ERROR: subtransaction logged without previous top-level txn record	Arseny Sher	09:20
Re: Tid scan increments value of pg_stat_all_tables.seq_scan. (but not seq_tup_read)	Kasahara Tatsuhito	09:20
Re: Parallel grouping sets	Richard Guo	09:27
Re: base backup client as auxiliary backend process	Andres Freund	09:37
Re: [HACKERS] Moving relation extension locks out of heavyweight lock manager	Amit Kapila	11:03
Re: BUG #16171: Potential malformed JSON in explain output	hubert depesz lubaczewski	11:40
Re: Add %x to PROMPT1 and PROMPT2	Daniel Gustafsson	12:40
Re: base backup client as auxiliary backend process	Andres Freund	12:47
Re: Experimenting with hash join prefetch 📎	Thomas Munro	12:48
Re: ERROR: subtransaction logged without previous top-level txn record	Amit Kapila	12:54
Re: BUG #16171: Potential malformed JSON in explain output	Daniel Gustafsson	12:55
Re: [Proposal] Global temporary tables	曾文旌 (义从)	13:03
Re: Brokenness in dump/restore for GENERATED expressions	Peter Eisentraut	13:19
Re: Cache relation sizes?	Andres Freund	13:23
Re: ERROR: subtransaction logged without previous top-level txn record	Arseny Sher	13:46
Re: PATCH: standby crashed when replay block which truncated in standby but failed to truncate in master node	Andres Freund	13:49
Re: pg_stat_progress_basebackup - progress reporting for pg_basebackup, in the server side 📎	Fujii Masao	14:04
Re: Complete data erasure	Stephen Frost	14:07
Re: BUG #16171: Potential malformed JSON in explain output	Tom Lane	14:15
Re: Add %x to PROMPT1 and PROMPT2	Alvaro Herrera	14:34
Re: Add %x to PROMPT1 and PROMPT2	Tom Lane	14:40
Re: explain HashAggregate to report bucket and memory stats	Andres Freund	14:53
Re: BUG #16171: Potential malformed JSON in explain output 📎	Tom Lane	15:56
Re: [PoC] Non-volatile WAL buffer	Andres Freund	15:59
Re: Complete data erasure	Tomas Vondra	17:30
Re: Portal->commandTag as an enum	Mark Dilger	17:41
Re: Memory-Bounded Hash Aggregation 📎	Jeff Davis	18:29
Re: Dumping/restoring fails on inherited generated column 📎	Peter Eisentraut	18:58
Re: Dumping/restoring fails on inherited generated column	Tom Lane	19:32
Index only scan and ctid	Laurenz Albe	19:37
Re: Index only scan and ctid	Tom Lane	19:43
Re: [Proposal] Global temporary tables	Pavel Stehule	19:46
Re: Parallel grouping sets	Jesse Zhang	19:53
Re: Global temporary tables 📎	Konstantin Knizhnik	20:56
Re: Missing break in RelationFindReplTupleSeq	Alvaro Herrera	22:04

Feb. 4, 2020

Thread	Author	Time
Re: Is custom MemoryContext prohibited?	Andres Freund	00:26
RE: Complete data erasure	[email protected]	00:53
Re: Experimenting with hash join prefetch	Andres Freund	01:31
Re: Add %x to PROMPT1 and PROMPT2	Ian Barwick	01:31
Re: pg_stat_progress_basebackup - progress reporting for pg_basebackup, in the server side	Amit Langote	01:34
Re: Implementing Incremental View Maintenance 📎	Takuma Hoshiai	01:58
Re: Memory-Bounded Hash Aggregation 📎	Jeff Davis	02:24
Re: Internal key management system	Masahiko Sawada	03:17
Re: Experimenting with hash join prefetch	Thomas Munro	03:38
Re: logical decoding : exceeded maxAllocatedDescs for .spill files	Kuntal Ghosh	04:45
Re: table partition and column default	Amit Langote	04:56
Re: error context for vacuum to include block number	Masahiko Sawada	04:58
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Dilip Kumar	05:20
Re: base backup client as auxiliary backend process	Michael Paquier	05:28
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Dilip Kumar	05:29
RE: Complete data erasure	[email protected]	06:06
Re: ERROR: subtransaction logged without previous top-level txn record	Amit Kapila	06:41
Re: pg_stat_progress_basebackup - progress reporting for pg_basebackup, in the server side 📎	Amit Langote	06:59
Refactor compile-time assertion checks for C/C++ 📎	Michael Paquier	08:15
Re: Add %x to PROMPT1 and PROMPT2	Michael Paquier	08:20
Re: logical decoding : exceeded maxAllocatedDescs for .spill files	Amit Kapila	09:10
Re: Implementing Incremental View Maintenance	nuko yokohama	09:40
RE: [Patch] Optimize dropping of relation buffers using dlist 📎	[email protected]	09:57
Re: Memory-Bounded Hash Aggregation	Adam Lee	10:42
More DSM slot exhaustion bugs 📎	Thomas Munro	10:44
[PATCH v1] Allow COPY "text" format to output a header 📎	Rémi Lapeyre	13:25
Re: Expose lock group leader pid in pg_stat_activity 📎	Julien Rouhaud	14:27
Re: [Proposal] Global temporary tables	曾文旌 (义从)	15:01
Re: Memory-Bounded Hash Aggregation	Heikki Linnakangas	16:10
Re: [Proposal] Global temporary tables	Konstantin Knizhnik	16:47
Re: BUG #16171: Potential malformed JSON in explain output	Tom Lane	18:08
Re: Index only scan and ctid	Laurenz Albe	18:11
Re: Index only scan and ctid	Tom Lane	18:22
Re: Index Skip Scan	Dmitry Dolgov	20:02
Re: Clarifying/rationalizing Vars' varno/varattno/varnoold/varoattno	Tom Lane	20:24
RE: Index Skip Scan	Floris Van Nee	20:34
Re: [Proposal] Global temporary tables	Robert Haas	20:57
Re: Complete data erasure	Tomas Vondra	21:29
Re: [Proposal] Global temporary tables	Robert Haas	21:38
Re: Complete data erasure	Tom Lane	21:52
Re: Minimal logical decoding on standbys	James Sewell	22:43
Re: Memory-Bounded Hash Aggregation	Peter Geoghegan	23:08
Re: Memory-Bounded Hash Aggregation	Thomas Munro	23:53

Feb. 5, 2020

Thread	Author	Time
Re: Delaying/avoiding BTreeTupleGetNAtts() call within _bt_compare()	Peter Geoghegan	00:00
RE: Complete data erasure	[email protected]	00:34
Re: Expose lock group leader pid in pg_stat_activity 📎	Michael Paquier	01:48
Re: Portal->commandTag as an enum 📎	Mark Dilger	02:18
Re: closesocket behavior in different platforms	Amit Kapila	02:36
Re: Documentation patch for ALTER SUBSCRIPTION	Amit Kapila	02:45
Re: Documentation patch for ALTER SUBSCRIPTION	David Christensen	03:14
Re: Portal->commandTag as an enum	Andres Freund	03:34
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Amit Kapila	03:57
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎	Dilip Kumar	04:12
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Dilip Kumar	04:15
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Dilip Kumar	04:18
RE: Global shared meta cache 📎	[email protected]	04:50
Re: base backup client as auxiliary backend process	Masahiko Sawada	04:52
pgsql: Add kqueue(2) support to the WaitEventSet API.	Thomas Munro	04:59
Re: [HACKERS] kqueue	Thomas Munro	04:59
Re: Portal->commandTag as an enum	Mark Dilger	05:09
Re: table partition and column default	Fujii Masao	05:09
A bug in LWLOCK_STATS 📎	Fujii Masao	05:43
Re: [PATCH v1] Allow COPY "text" format to output a header	Surafel Temesgen	06:06
Re: pg_stat_progress_basebackup - progress reporting for pg_basebackup, in the server side	Fujii Masao	06:36
Re: [HACKERS] Moving relation extension locks out of heavyweight lock manager 📎	Masahiko Sawada	06:36
Re: ALTER tbl rewrite loses CLUSTER ON index 📎	Amit Langote	06:53
Re: Expose lock group leader pid in pg_stat_activity	Julien Rouhaud	06:57
Re: Tid scan increments value of pg_stat_all_tables.seq_scan. (but not seq_tup_read) 📎	Kasahara Tatsuhito	07:25
Re: [Proposal] Global temporary tables	Konstantin Knizhnik	07:28
Re: pg_stat_progress_basebackup - progress reporting for pg_basebackup, in the server side	Amit Langote	07:29
Re: A bug in LWLOCK_STATS	Julien Rouhaud	08:13
Re: Documentation patch for ALTER SUBSCRIPTION	Amit Kapila	08:19
Re: A bug in LWLOCK_STATS	Kyotaro Horiguchi	08:25
Re: pg_stat_progress_basebackup - progress reporting for pg_basebackup, in the server side	Kyotaro Horiguchi	08:30
Re: ALTER tbl rewrite loses CLUSTER ON index	Justin Pryzby	08:32
Re: pg_stat_progress_basebackup - progress reporting for pg_basebackup, in the server side	Amit Langote	08:54
Re: ERROR: subtransaction logged without previous top-level txn record	Arseny Sher	09:04
Assumptions about the number of parallel workers 📎	Antonin Houska	09:50
Re: [Proposal] Global temporary tables	曾文旌 (义从)	09:51
Re: Implementing Incremental View Maintenance	Yugo NAGATA	09:52
Re: pg_stat_progress_basebackup - progress reporting for pg_basebackup, in the server side	Amit Langote	09:53
Re: Complete data erasure	Masahiko Sawada	10:19
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Amit Kapila	10:35
Identifying user-created objects 📎	Masahiko Sawada	11:26
Re: BUG #15858: could not stat file - over 4GB	Emil Iggland	11:46
Re: [HACKERS] advanced partition matching algorithm for partition-wise join 📎	Etsuro Fujita	12:51
Re: [PATCH v1] Allow COPY "text" format to output a header	Rémi Lapeyre	13:18
Re: [Proposal] Global temporary tables	曾文旌 (义从)	13:20
Re: Internal key management system	Sehrope Sarkuni	13:28
WAL usage calculation patch 📎	Kirill Bychik	13:35
Re: Documentation patch for ALTER SUBSCRIPTION	Alvaro Herrera	13:56
Re: [Proposal] Global temporary tables	Robert Haas	14:10
Re: [Proposal] Global temporary tables	Robert Haas	14:15
Re: Is custom MemoryContext prohibited?	Robert Haas	14:19
Re: Is custom MemoryContext prohibited?	Robert Haas	14:28
Re: Add %x to PROMPT1 and PROMPT2	Robert Haas	14:30
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Julien Rouhaud	14:32
Re: Documentation patch for ALTER SUBSCRIPTION	David Christensen	14:35
Re: Is custom MemoryContext prohibited?	Tom Lane	15:09
Re: [Patch] Optimize dropping of relation buffers using dlist	Robert Haas	15:12
Re: Is custom MemoryContext prohibited?	Robert Haas	15:13
Re: Is custom MemoryContext prohibited?	Tom Lane	15:20
Re: Add %x to PROMPT1 and PROMPT2	Tom Lane	15:21
Re: Is custom MemoryContext prohibited?	Robert Haas	15:40
Re: Is custom MemoryContext prohibited?	Robert Haas	15:41
Re: [Proposal] Global temporary tables	Konstantin Knizhnik	15:48
Re: Is custom MemoryContext prohibited?	Chapman Flack	15:52
Re: Is custom MemoryContext prohibited?	Tom Lane	15:56
Re: Is custom MemoryContext prohibited?	Tom Lane	15:59
Re: Is custom MemoryContext prohibited?	Tom Lane	16:03
bad logging around broken restore_command 📎	Jeff Janes	16:10
Re: Add %x to PROMPT1 and PROMPT2	Magnus Hagander	16:16
Re: Collation versioning 📎	Julien Rouhaud	16:17
Re: Add %x to PROMPT1 and PROMPT2	Fabien COELHO	16:31
RETURNING does not explain evaluation context for subqueries	PG Doc comments form	16:32
Re: Index Skip Scan	Dmitry Dolgov	16:37
Re: Is custom MemoryContext prohibited?	Robert Haas	16:48
Re: [HACKERS] advanced partition matching algorithm for partition-wise join	Mark Dilger	17:03
Re: Is custom MemoryContext prohibited?	Tom Lane	17:15
Re: pgsql: Prevent running pg_basebackup as root	Stephen Frost	17:22
Re: Documentation patch for ALTER SUBSCRIPTION	Alvaro Herrera	18:08
Re: Is custom MemoryContext prohibited?	Robert Haas	18:09
Re: Memory-Bounded Hash Aggregation	Jeff Davis	18:26
Re: Memory-Bounded Hash Aggregation 📎	Jeff Davis	18:37
Re: Memory-Bounded Hash Aggregation	Peter Geoghegan	18:40
Re: [HACKERS] advanced partition matching algorithm for partition-wise join	Mark Dilger	18:55
Re: [Proposal] Global temporary tables	Pavel Stehule	19:18
Re: Memory-Bounded Hash Aggregation 📎	Jeff Davis	19:56
Re: widen vacuum buffer counters	Alvaro Herrera	20:18
Re: [HACKERS] Moving relation extension locks out of heavyweight lock manager 📎	Mahendra Singh Thalor	20:26
Re: DROP OWNED CASCADE vs Temp tables	Alvaro Herrera	21:13
Re: Do not check unlogged indexes on standby	Alvaro Herrera	21:27
Re: Add MAIN_RELATION_CLEANUP and SECONDARY_RELATION_CLEANUP options to VACUUM 📎	Bossart, Nathan	21:29
Re: Do not check unlogged indexes on standby	Peter Geoghegan	21:35

Feb. 6, 2020

Thread	Author	Time
Re: Expose lock group leader pid in pg_stat_activity	Michael Paquier	00:24
Re: pg_stat_progress_basebackup - progress reporting for pg_basebackup, in the server side	Kyotaro Horiguchi	00:50
Re: Index Skip Scan	Kyotaro Horiguchi	01:24
Re: Memory-Bounded Hash Aggregation	Jeff Davis	01:54
Re: pg_stat_progress_basebackup - progress reporting for pg_basebackup, in the server side	Amit Langote	02:07
typos in comments and user docs 📎	Justin Pryzby	02:14
Re: Memory-Bounded Hash Aggregation 📎	Jeff Davis	02:20
Re: pg_stat_progress_basebackup - progress reporting for pg_basebackup, in the server side	Amit Langote	02:35
Re: Add %x to PROMPT1 and PROMPT2	Michael Paquier	02:38

Browse Archives

Prev | Next