pgsql-hackers since 2020-01-13 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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Jan. 13, 2020

Thread Author Time
Re: Using multiple extended statistics for estimates Tomas Vondra 00:24
Re: vacuum verbose detail logs are unclear; log at *start* of each stage; show allvisible/frozen/hintbits 📎 Justin Pryzby 00:45
Re: bitmaps and correlation 📎 Justin Pryzby 01:47
Re: Questions/Observations related to Gist vacuum Dilip Kumar 03:25
Re: [HACKERS] Block level parallel vacuum Amit Kapila 03:50
Re: [HACKERS] Block level parallel vacuum Dilip Kumar 06:38
Comment fix in session.h 📎 Antonin Houska 07:22
How to make a OpExpr check compatible among different versions Andy Fan 07:29
Re: [Proposal] Global temporary tables Konstantin Knizhnik 08:08
Re: How to make a OpExpr check compatible among different versions Peter Eisentraut 08:09
Re: Comment fix in session.h Amit Kapila 08:38
Re: Question regarding heap_multi_insert documentation Michael Paquier 08:59
[PATCH] distinct aggregates within a window function WIP 📎 Krasiyan Andreev 09:17
Re: [HACKERS] Block level parallel vacuum Sergei Kornilov 09:21
Re: How to make a OpExpr check compatible among different versions Andy Fan 09:25
isTempNamespaceInUse() is incorrect with its handling of MyBackendId 📎 Michael Paquier 09:37
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Dilip Kumar 09:48
Re: ALTER TABLE support for dropping generation expression Sergei Kornilov 09:56
Re: [HACKERS] Block level parallel vacuum 📎 Amit Kapila 10:09
Re: Comment fix in session.h Amit Kapila 10:13
Re: standby recovery fails (tablespace related) (tentative patch and discussion) Paul Guo 10:27
Re: benchmarking Flex practices 📎 John Naylor 10:46
Re: our checks for read-only queries are not great Peter Eisentraut 10:57
Re: Allow to_date() and to_timestamp() to accept localized names 📎 Juan José Santamaría Flecha 12:04
Re: isTempNamespaceInUse() is incorrect with its handling of MyBackendId Julien Rouhaud 12:09
Re: Add FOREIGN to ALTER TABLE in pg_dump vignesh C 12:13
Re: pg_basebackup fails on databases with high OIDs Peter Eisentraut 12:49
Re: pg_basebackup fails on databases with high OIDs Julien Rouhaud 13:07
Re: isTempNamespaceInUse() is incorrect with its handling of MyBackendId Michael Paquier 13:14
Re: Add pg_file_sync() to adminpack Michael Paquier 13:46
Re: isTempNamespaceInUse() is incorrect with its handling of MyBackendId Julien Rouhaud 13:56
Re: [PATCH] distinct aggregates within a window function WIP Tom Lane 14:19
Re: Add FOREIGN to ALTER TABLE in pg_dump Tom Lane 14:22
Re: Add pg_file_sync() to adminpack Julien Rouhaud 14:39
Re: [PATCH] distinct aggregates within a window function WIP Thomas Kellerer 14:49
Re: [PATCH] distinct aggregates within a window function WIP Krasiyan Andreev 15:22
Re: Add FOREIGN to ALTER TABLE in pg_dump 📎 Alvaro Herrera 15:36
Re: How to retain lesser paths at add_path()? 📎 Kohei KaiGai 15:46
Re: [PATCH] distinct aggregates within a window function WIP Vik Fearing 16:19
Re: [Proposal] Global temporary tables Tomas Vondra 16:32
Re: BUG #16059: Tab-completion of filenames in COPY commands removes required quotes Peter Eisentraut 16:34
Re: [HACKERS] Block level parallel vacuum Mahendra Singh Thalor 18:20
Re: Removing pg_pltemplate and creating "trustable" extensions Stephen Frost 18:40
Re: our checks for read-only queries are not great Stephen Frost 18:56
Re: our checks for read-only queries are not great Robert Haas 19:14
Re: our checks for read-only queries are not great Laurenz Albe 19:37
Re: our checks for read-only queries are not great Stephen Frost 20:00
Re: [Proposal] Global temporary tables Julien Rouhaud 20:12
Re: benchmarking Flex practices Tom Lane 20:12
Re: BUG #16059: Tab-completion of filenames in COPY commands removes required quotes Tom Lane 20:36
Re: Removing pg_pltemplate and creating "trustable" extensions Tom Lane 20:38
Re: Building infrastructure for B-Tree deduplication that recognizes when opclass equality is also equivalence 📎 Anastasia Lubennikova 20:49
Re: Removing pg_pltemplate and creating "trustable" extensions Stephen Frost 20:57
Re: [Proposal] Global temporary tables Tomas Vondra 21:03
Re: isTempNamespaceInUse() is incorrect with its handling of MyBackendId Michael Paquier 22:23
Re: DROP OWNED CASCADE vs Temp tables Alvaro Herrera 22:45
Re: Building infrastructure for B-Tree deduplication that recognizes when opclass equality is also equivalence Peter Geoghegan 22:53
Additional improvements to extended statistics 📎 Tomas Vondra 23:00
Re: Why is pq_begintypsend so slow? Andres Freund 23:18
Unicode escapes with any backend encoding 📎 Tom Lane 23:31
Re: Amcheck: do rightlink verification with lock coupling Peter Geoghegan 23:49

Jan. 14, 2020

Thread Author Time
Re: [HACKERS] [WIP] Effective storage of duplicates in B-tree index. Peter Geoghegan 00:07
Re: DROP OWNED CASCADE vs Temp tables Michael Paquier 00:19
Re: DROP OWNED CASCADE vs Temp tables Tom Lane 00:27
Re: Add FOREIGN to ALTER TABLE in pg_dump vignesh C 00:32
Re: Option to dump foreign data in pg_dump vignesh C 00:48
Re: benchmarking Flex practices John Naylor 00:59
Re: Amcheck: do rightlink verification with lock coupling Tomas Vondra 01:07
Re: BUG #16059: Tab-completion of filenames in COPY commands removes required quotes 📎 Tom Lane 01:38
Re: Unicode escapes with any backend encoding Andrew Dunstan 01:44
Re: Unicode escapes with any backend encoding Tom Lane 02:05
Re: Making psql error out on output failures David Z 02:39
Re: Avoid full GIN index scan when possible 📎 Alexander Korotkov 03:03
Re: Protect syscache from bloating with negative cache entries 📎 Kyotaro Horiguchi 03:49
Improve errors when setting incorrect bounds for SSL protocols 📎 Michael Paquier 03:54
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Amit Kapila 04:28
Re: [HACKERS] Block level parallel vacuum Masahiko Sawada 04:33
Re: [HACKERS] Block level parallel vacuum Masahiko Sawada 04:35
Re: Amcheck: do rightlink verification with lock coupling Andrey Borodin 04:47
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Amit Kapila 05:13
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎 Dilip Kumar 05:26
Re: Add pg_file_sync() to adminpack Michael Paquier 06:17
Re: Add pg_file_sync() to adminpack Julien Rouhaud 06:26
Re: base backup client as auxiliary backend process Masahiko Sawada 06:32
Re: Implementing Incremental View Maintenance Takuma Hoshiai 06:37
Re: Additional improvements to extended statistics Pavel Stehule 08:16
Re: Re: Append with naive multiplexing of FDWs 📎 [email protected] 09:12
Re: TRUNCATE on foreign tables 📎 Kohei KaiGai 09:16
Re: Append with naive multiplexing of FDWs 📎 Ahsan Hadi 09:37
Re: Errors when update a view with conditional-INSTEAD rules Dean Rasheed 10:18
Re: Improve errors when setting incorrect bounds for SSL protocols Daniel Gustafsson 10:21
Re: [HACKERS] WAL logging problem in 9.4.3? 📎 Kyotaro Horiguchi 10:35
Re: [HACKERS] Block level parallel vacuum Mahendra Singh Thalor 10:47
Re: [HACKERS] Block level parallel vacuum Mahendra Singh Thalor 11:46
Re: Option to dump foreign data in pg_dump Luis Carril 11:52
Re: [HACKERS] Block level parallel vacuum 📎 Amit Kapila 12:43
Re: [HACKERS] Block level parallel vacuum Amit Kapila 12:46
Re: ALTER TABLE support for dropping generation expression Peter Eisentraut 12:47
Re: [Proposal] Global temporary tables 曾文旌 (义从) 13:09
Re: [Proposal] Global temporary tables Pavel Stehule 13:20
pgsql: walreceiver uses a temporary replication slot by default Peter Eisentraut 13:57
Re: base backup client as auxiliary backend process Peter Eisentraut 13:58
Re: [Proposal] Global temporary tables 曾文旌 (义从) 14:15
Re: [Proposal] Global temporary tables 曾文旌 (义从) 14:16
Create/alter policy and exclusive table lock Konstantin Knizhnik 14:18
Re: Setting min/max TLS protocol in clientside libpq 📎 Daniel Gustafsson 14:34
Re: Making psql error out on output failures Daniel Verite 14:37
Re: Create/alter policy and exclusive table lock Tom Lane 14:40
Re: Duplicate Workers entries in some EXPLAIN plans Georgios Kokolatos 14:44
Re: Setting min/max TLS protocol in clientside libpq Tom Lane 14:49
Re: [WIP] UNNEST(REFCURSOR): allowing SELECT to consume data from a REFCURSOR Daniel Verite 14:53
Re: Add pg_file_sync() to adminpack Atsushi Torikoshi 15:08
Re: Unicode escapes with any backend encoding Tom Lane 15:10
Re: Setting min/max TLS protocol in clientside libpq Daniel Gustafsson 15:15
Re: SQL/JSON: JSON_TABLE 📎 Nikita Glukhov 15:26
Re: Create/alter policy and exclusive table lock Konstantin Knizhnik 15:49
Re: our checks for read-only queries are not great Robert Haas 16:02
Re: Add pg_file_sync() to adminpack Julien Rouhaud 16:50
Re: backup manifests Robert Haas 16:54
Re: our checks for read-only queries are not great Tom Lane 17:34
Use compiler intrinsics for bit ops in hash 📎 David Fetter 17:35
Re: Create/alter policy and exclusive table lock Tom Lane 17:40
Re: backup manifests Tom Lane 17:53
Re: Unicode escapes with any backend encoding Chapman Flack 17:55
Re: backup manifests David Fetter 18:33
Re: Avoid full GIN index scan when possible 📎 Tom Lane 18:43
Re: our checks for read-only queries are not great Stephen Frost 18:46
Re: doc: vacuum full, fillfactor, and "extra space" Justin Pryzby 19:12
Re: doc: vacuum full, fillfactor, and "extra space" Fabien COELHO 19:49
Re: SQL/JSON: JSON_TABLE Pavel Stehule 19:55
Re: Add pg_file_sync() to adminpack Stephen Frost 19:57
Re: 12.1 not useable: clientlib fails after a dozen queries (GSSAPI ?) Stephen Frost 20:12
Re: planner support functions: handle GROUP BY estimates ? Tom Lane 20:12
Re: pause recovery if pitr target not reached 📎 Peter Eisentraut 20:13
Re: Use compiler intrinsics for bit ops in hash Jesse Zhang 20:21
Re: 12.1 not useable: clientlib fails after a dozen queries (GSSAPI ?) Tom Lane 20:22
Re: backup manifests Stephen Frost 20:35
Re: 12.1 not useable: clientlib fails after a dozen queries (GSSAPI ?) Stephen Frost 20:45
Re: planner support functions: handle GROUP BY estimates ? Tomas Vondra 20:53
Re: proposal: type info support functions for functions that use "any" type Tom Lane 21:09
Re: Unicode escapes with any backend encoding Andrew Dunstan 21:17
Re: planner support functions: handle GROUP BY estimates ? Tom Lane 21:21
Re: Unicode escapes with any backend encoding Tom Lane 21:25
Re: Remove libpq.rc, use win32ver.rc for libpq 📎 Peter Eisentraut 21:34
Re: planner support functions: handle GROUP BY estimates ? Tomas Vondra 21:45
Re: planner support functions: handle GROUP BY estimates ? Tom Lane 21:52
Re: aggregate crash Alvaro Herrera 21:53
Re: DROP OWNED CASCADE vs Temp tables Alvaro Herrera 21:59
Re: Setting min/max TLS protocol in clientside libpq 📎 Daniel Gustafsson 22:01
Re: aggregate crash Tom Lane 22:01
Re: Unicode escapes with any backend encoding Chapman Flack 22:03
Re: Use compiler intrinsics for bit ops in hash 📎 David Fetter 22:09
Re: Add pg_file_sync() to adminpack Julien Rouhaud 22:12
Re: planner support functions: handle GROUP BY estimates ? Tomas Vondra 22:12
Re: backup manifests David Fetter 22:14
pgindent && weirdness Alvaro Herrera 22:18
Re: Add FOREIGN to ALTER TABLE in pg_dump Alvaro Herrera 22:23
Re: Rearranging ALTER TABLE to avoid multi-operations bugs 📎 Tom Lane 22:27
Re: pgindent && weirdness Tom Lane 22:30
Re: planner support functions: handle GROUP BY estimates ? Tom Lane 22:37
Re: aggregate crash Andres Freund 22:40
Re: Add FOREIGN to ALTER TABLE in pg_dump Tom Lane 22:42
Re: Why is pq_begintypsend so slow? 📎 Andres Freund 22:45
Re: Avoid full GIN index scan when possible 📎 Alexander Korotkov 22:47
Re: Unicode escapes with any backend encoding Andrew Dunstan 22:50
Re: Disallow cancellation of waiting for synchronous replication Andres Freund 22:53
Re: aggregate crash Tom Lane 22:54
Re: Avoid full GIN index scan when possible Alexander Korotkov 22:56
Re: Avoid full GIN index scan when possible Tom Lane 23:03
Re: Add FOREIGN to ALTER TABLE in pg_dump Alvaro Herrera 23:04
Re: Unicode escapes with any backend encoding Tom Lane 23:04
Re: planner support functions: handle GROUP BY estimates ? Tomas Vondra 23:19
Re: planner support functions: handle GROUP BY estimates ? Tom Lane 23:44

Jan. 15, 2020

Thread Author Time
Re: Restore replication settings when modifying a field type Quan Zongliang 00:30
Re: Add support for automatically updating Unicode derived files Tom Lane 00:37
Re: base backup client as auxiliary backend process Masahiko Sawada 00:40
Complete data erasure [email protected] 01:31
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Amit Kapila 01:40
Re: pause recovery if pitr target not reached Kyotaro Horiguchi 02:02
Re: [HACKERS] [WIP] Effective storage of duplicates in B-tree index. 📎 Peter Geoghegan 02:08
Re: Improve errors when setting incorrect bounds for SSL protocols 📎 Michael Paquier 02:28
Re: [HACKERS] Block level parallel vacuum Mahendra Singh Thalor 03:34
Re: Complete data erasure Kyotaro Horiguchi 03:45
Re: Complete data erasure Tom Lane 04:01
Re: pause recovery if pitr target not reached Kyotaro Horiguchi 04:02
Re: [HACKERS] Block level parallel vacuum 📎 Masahiko Sawada 04:34
Re: backup manifests David Steele 04:36
Re: backup manifests Tom Lane 04:47
Re: [HACKERS] Block level parallel vacuum Masahiko Sawada 05:19
Re: backup manifests 📎 David Steele 05:21
Re: Remove libpq.rc, use win32ver.rc for libpq Kyotaro Horiguchi 05:22
Re: Setting min/max TLS protocol in clientside libpq Michael Paquier 05:58
Re: Remove libpq.rc, use win32ver.rc for libpq Michael Paquier 06:44
Re: Duplicate Workers entries in some EXPLAIN plans 📎 Maciek Sakrejda 07:22
Re: aggregate crash Andres Freund 07:27
Re: TRUNCATE on foreign tables Michael Paquier 08:11
Re: [HACKERS] WAL logging problem in 9.4.3? 📎 Kyotaro Horiguchi 08:18
Re: pause recovery if pitr target not reached Leif Gunnar Erlandsen 08:25
Re: proposal: type info support functions for functions that use "any" type Pavel Stehule 10:04
Re: Duplicate Workers entries in some EXPLAIN plans Georgios Kokolatos 10:11

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31