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

Jan. 31, 2020

Thread Author Time
MSVC installs too much stuff? Andrew Dunstan 02:17
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Amit Kapila 02:38
Re: Proposal: Add more compile-time asserts to expose inconsistencies. 📎 Michael Paquier 02:47
PATCH: Fix wrong size argument to pg_strncasecmp 📎 Dominik Czarnota 03:18
Re: Tweaking DSM and DSA limits Thomas Munro 04:33
Re: table partitioning and access privileges Amit Langote 04:38
Re: [Patch] Make pg_checksums skip foreign tablespace directories 📎 Michael Paquier 04:53
Re: Proposal: Add more compile-time asserts to expose inconsistencies. Kyotaro Horiguchi 05:15
Re: MSVC installs too much stuff? Michael Paquier 05:26
Re: standby apply lag on inactive servers Kyotaro Horiguchi 05:35
Re: Proposal: Add more compile-time asserts to expose inconsistencies. Michael Paquier 05:46
Re: MSVC installs too much stuff? Craig Ringer 06:05
Re: Unix-domain socket support on Windows Craig Ringer 06:10
Re: Fetching timeline during recovery Michael Paquier 06:12
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Masahiko Sawada 06:21
Re: [Patch] Make pg_checksums skip foreign tablespace directories Kyotaro Horiguchi 08:30
Re: [Patch] Make pg_checksums skip foreign tablespace directories Kyotaro Horiguchi 08:39
Re: SimpleLruTruncate() mutual exclusion Noah Misch 08:42
Re: Hash join not finding which collation to use for string hashing Amit Langote 09:37
Re: Marking some contrib modules as trusted extensions Dean Rasheed 09:40
Re: [Patch] Make pg_checksums skip foreign tablespace directories Michael Banck 09:59
Re: pg_restore crash when there is a failure before all child process is created Ahsan Hadi 10:15
Re: unsupportable composite type partition keys 📎 Julien Rouhaud 10:25
Re: [Patch] Make pg_checksums skip foreign tablespace directories Bernd Helmle 10:33
Re: Data race in interfaces/libpq/fe-exec.c Mark Charsley 10:47
Re: pg_restore crash when there is a failure before all child process is created vignesh C 11:13
Re: Physical replication slot advance is not persistent Alexey Kondratov 11:14
Re: Duplicated LSN in ReorderBuffer Amit Kapila 11:17
Re: allow online change primary_conninfo 📎 Sergei Kornilov 11:26
Re: standby apply lag on inactive servers Fujii Masao 12:30
Re: table partitioning and access privileges Fujii Masao 12:39
[PATCH] Erase the distinctClause if the result is unique by definition 📎 Andy Fan 12:39
Re: pg_restore crash when there is a failure before all child process is created ahsan hadi 12:54
Re: Allow to_date() and to_timestamp() to accept localized names 📎 Juan José Santamaría Flecha 13:02
Re: standby apply lag on inactive servers Alvaro Herrera 13:40
Missing break in RelationFindReplTupleSeq Konstantin Knizhnik 13:46
Re: Missing break in RelationFindReplTupleSeq 📎 Alvaro Herrera 13:58
Re: Do we need to handle orphaned prepared transactions in the server? Hamid Akhtar 14:02
Re: standby apply lag on inactive servers Fujii Masao 14:29
Re: standby apply lag on inactive servers Alvaro Herrera 14:47
Re: Marking some contrib modules as trusted extensions Tom Lane 15:13
Re: Use compiler intrinsics for bit ops in hash 📎 David Fetter 15:59
Re: standby apply lag on inactive servers Fujii Masao 16:23
Re: Unix-domain socket support on Windows Peter Eisentraut 16:55
Re: Extracting only the columns needed for a query Melanie Plageman 17:52
Re: Extracting only the columns needed for a query Ashwin Agrawal 18:05
Re: Shared memory leak on DSM slot exhaustion Robert Haas 18:37
get a relations DDL server-side Jordan Deitch 18:59
Re: [Proposal] Global temporary tables Robert Haas 19:38
Re: pg_restore crash when there is a failure before all child process is created Tom Lane 19:45
Re: get a relations DDL server-side Tom Lane 20:01
widen vacuum buffer counters 📎 Alvaro Herrera 20:59
Re: widen vacuum buffer counters Julien Rouhaud 21:10
Re: unsupportable composite type partition keys Tom Lane 21:20
Re: WIP: Aggregation push-down legrand legrand 21:59
Re: widen vacuum buffer counters Tom Lane 22:13
Re: PATCH: Fix wrong size argument to pg_strncasecmp Tom Lane 22:28
Re: Created feature for to_date() conversion using patterns 'YYYY-WW', 'YYYY-WW-D', 'YYYY-MM-W' and 'YYYY-MM-W-D' Cleysson Lima 22:34
Re: [Patch] pg_rewind: options to use restore_command from recovery.conf or command line 📎 Alexey Kondratov 23:16

Feb. 1, 2020

Thread Author Time
Re: Created feature for to_date() conversion using patterns 'YYYY-WW', 'YYYY-WW-D', 'YYYY-MM-W' and 'YYYY-MM-W-D' Tom Lane 00:42
Re: Shared memory leak on DSM slot exhaustion Thomas Munro 02:37
What's difference among insert/write/flush lsn? Jinhua Luo 03:18
Re: dropdb --force Amit Kapila 05:26
Re: Don't try fetching future segment of a TLI. David Steele 05:31
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Amit Kapila 05:35
Re: [PATCH] Fix Proposal - Deadlock Issue in Single User Mode When IO Failure Occurs Amit Kapila 05:42
Re: [Proposal] Add accumulated statistics for wait event 📎 Pavel Stehule 05:49
Re: Tid scan increments value of pg_stat_all_tables.seq_scan. (but not seq_tup_read) 📎 Kasahara Tatsuhito 07:05
Re: unsupportable composite type partition keys Julien Rouhaud 07:46
PATCH: add support for IN and @> in functional-dependency statistics use 📎 Pierre Ducroquet 07:51
Re: pgbench - add pseudo-random permutation function Fabien COELHO 09:07
Re: The flinfo->fn_extra question, from me this time. Dent John 09:09
pgsql: Prevent running pg_basebackup as root Michael Paquier 09:33
Re: Prevent pg_basebackup running as root Michael Paquier 09:34
Re: widen vacuum buffer counters Michael Paquier 09:52
Re: polymorphic table functions light Dent John 09:55
Re: pgbench - add pseudo-random permutation function 📎 Fabien COELHO 10:12
Re: fix for BUG #3720: wrong results at using ltree Tomas Vondra 11:13
Re: enhance SPI to support EXECUTE commands Tomas Vondra 11:21
Re: Copy data to DSA area Tomas Vondra 11:24
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Tomas Vondra 11:30
Re: [Proposal] Add accumulated statistics for wait event Tomas Vondra 11:34
Re: [Proposal] Add accumulated statistics for wait event Pavel Stehule 11:37
Re: Speed up transaction completion faster after many relations are accessed in a transaction Tomas Vondra 11:41
Re: [proposal] recovery_target "latest" Tomas Vondra 11:44
Re: Global temporary tables Tomas Vondra 11:49
Re: Global shared meta cache Tomas Vondra 11:51
Re: psql - add SHOW_ALL_RESULTS option Tomas Vondra 12:01
Re: [Proposal] Global temporary tables 曾文旌 (义从) 13:39
Re: PATCH: add support for IN and @> in functional-dependency statistics use Tomas Vondra 14:24
Re: widen vacuum buffer counters Tom Lane 15:26
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Sehrope Sarkuni 15:37
Re: [Proposal] Global temporary tables 曾文旌 (义从) 16:14
Re: [Proposal] Global temporary tables Pavel Stehule 18:00
Re: BUG #16171: Potential malformed JSON in explain output 📎 Tom Lane 19:37
Re: Created feature for to_date() conversion using patterns 'YYYY-WW', 'YYYY-WW-D', 'YYYY-MM-W' and 'YYYY-MM-W-D' Tom Lane 20:00

Feb. 2, 2020

Thread Author Time
Internal key management system Masahiko Sawada 00:02
Re: error context for vacuum to include block number Masahiko Sawada 01:45
Re: Autovacuum on partitioned table Masahiko Sawada 03:52
Re: pg_stat_progress_basebackup - progress reporting for pg_basebackup, in the server side Masahiko Sawada 05:59
Re: error context for vacuum to include block number 📎 Justin Pryzby 06:02
Re: Internal key management system Fabien COELHO 08:05
Re: psql - add SHOW_ALL_RESULTS option Fabien COELHO 08:16
Re: PATCH: add support for IN and @> in functional-dependency statistics use Pierre Ducroquet 09:59
Re: BUG #16171: Potential malformed JSON in explain output Daniel Gustafsson 12:08
ALTER tbl rewrite loses CLUSTER ON index 📎 Justin Pryzby 16:17
Re: BUG #16171: Potential malformed JSON in explain output Tom Lane 16:48
TestLib condition for deleting temporary directories 📎 Noah Misch 17:01
Re: TestLib condition for deleting temporary directories Daniel Gustafsson 17:19
[PATCH] Fix for slow GIN index queries when "gin_fuzzy_search_limit" setting is relatively small for large tables 📎 Adé 18:06
Re: PATCH: add support for IN and @> in functional-dependency statistics use Tomas Vondra 18:41

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

Browse Archives

Prev | Next