pgsql-hackers since 2020-01-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
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. 11, 2020

Thread Author Time
Re: Assert failure due to "drop schema pg_temp_3 cascade" for temporary tables and \d+ is not showing any info after drooping temp table schema Michael Paquier 00:03
Re: Avoid full GIN index scan when possible 📎 Alexander Korotkov 00:10
Re: Implementing Incremental View Maintenance nuko yokohama 00:27
Re: [HACKERS] WIP: Aggregation push-down 📎 Tomas Vondra 01:11
Re: [Logical Replication] TRAP: FailedAssertion("rel->rd_rel->relreplident == REPLICA_IDENTITY_DEFAULT || rel->rd_rel->relreplident == REPLICA_IDENTITY_FULL || rel->rd_rel->relreplident == REPLICA_IDENTITY_INDEX" Michael Paquier 01:34
Re: Assert failure due to "drop schema pg_temp_3 cascade" for temporary tables and \d+ is not showing any info after drooping temp table schema Michael Paquier 01:41
Re: Amcheck: do rightlink verification with lock coupling Tomas Vondra 01:45
Re: Add FOREIGN to ALTER TABLE in pg_dump Tomas Vondra 01:52
Re: How to retain lesser paths at add_path()? Tomas Vondra 02:01
Re: Disallow cancellation of waiting for synchronous replication Bruce Momjian 02:34
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Alvaro Herrera 02:48
Re: Setting min/max TLS protocol in clientside libpq Michael Paquier 02:49
Re: Amcheck: do rightlink verification with lock coupling Peter Geoghegan 02:49
Re: 12.1 not useable: clientlib fails after a dozen queries (GSSAPI ?) 📎 Tom Lane 03:51
Re: [HACKERS] Block level parallel vacuum Masahiko Sawada 03:53
Re: [HACKERS] Block level parallel vacuum 📎 Amit Kapila 04:18
Re: logical decoding : exceeded maxAllocatedDescs for .spill files 📎 Amit Kapila 05:36
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Tom Lane 05:46
Re: ALTER TABLE support for dropping generation expression 📎 Peter Eisentraut 06:35
Re: remove some STATUS_* symbols Peter Eisentraut 07:14
Re: pg_basebackup fails on databases with high OIDs 📎 Peter Eisentraut 07:21
Re: pgbench - use pg logging capabilities Michael Paquier 07:37
Re: How to retain lesser paths at add_path()? Kohei KaiGai 08:07
Re: base backup client as auxiliary backend process 📎 Peter Eisentraut 09:52
Re: Add pg_file_sync() to adminpack Artur Zakirov 10:04
Re: [WIP] UNNEST(REFCURSOR): allowing SELECT to consume data from a REFCURSOR Dent John 12:04
Re: Avoid full GIN index scan when possible Julien Rouhaud 12:21
Re: Amcheck: do rightlink verification with lock coupling Tomas Vondra 12:25
Re: How to retain lesser paths at add_path()? Tomas Vondra 12:27
Re: Efficient output for integer types Tomas Vondra 13:31
Re: [Proposal] Global temporary tables 曾文旌 (义从) 14:00
Re: [HACKERS] Block level parallel vacuum Masahiko Sawada 14:18
Re: 12.1 not useable: clientlib fails after a dozen queries (GSSAPI ?) Tom Lane 15:28
Re: Allow to_date() and to_timestamp() to accept localized names Tomas Vondra 16:06
Re: [HACKERS] Block level parallel vacuum Mahendra Singh Thalor 16:08
Re: pg_basebackup fails on databases with high OIDs Julien Rouhaud 16:44
Re: pg_basebackup fails on databases with high OIDs Magnus Hagander 16:47
Re: Make autovacuum sort tables in descending order of xid_age David Fetter 17:53
Why is pq_begintypsend so slow? Jeff Janes 19:04
Re: Why is pq_begintypsend so slow? Tom Lane 20:19
Re: [Proposal] Global temporary tables Pavel Stehule 20:27
Re: 12.1 not useable: clientlib fails after a dozen queries (GSSAPI ?) 📎 Tom Lane 20:37
Re: Avoid full GIN index scan when possible Alexander Korotkov 21:10
Re: 12.1 not useable: clientlib fails after a dozen queries (GSSAPI ?) 📎 Tom Lane 21:42
Re: Improve checking for pg_index.xmin Alexander Korotkov 22:02
Re: [PATCH] Atomic pgrename on Windows Alexander Korotkov 22:13

Jan. 12, 2020

Thread Author Time
Re: Windows UTF-8, non-ICU collation trouble Noah Misch 00:23
Re: [Proposal] Global temporary tables Tomas Vondra 01:14
Re: Why is pq_begintypsend so slow? 📎 David Fetter 01:41
Re: [Proposal] Global temporary tables Tomas Vondra 01:51
Re: Why is pq_begintypsend so slow? 📎 Tom Lane 02:43
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Amit Kapila 02:48
Re: ECPG: proposal for new DECLARE STATEMENT Tomas Vondra 02:52
Re: [proposal] de-TOAST'ing using a iterator John Naylor 02:53
Re: Why is pq_begintypsend so slow? Tom Lane 03:32
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Tomas Vondra 03:39
Re: ECPG: proposal for new DECLARE STATEMENT 📎 Tomas Vondra 03:41
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Tom Lane 03:53
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Tomas Vondra 04:10
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Tom Lane 04:20
Re: Disallow cancellation of waiting for synchronous replication Andrey Borodin 11:18
Re: [Logical Replication] TRAP: FailedAssertion("rel->rd_rel->relreplident == REPLICA_IDENTITY_DEFAULT || rel->rd_rel->relreplident == REPLICA_IDENTITY_FULL || rel->rd_rel->relreplident == REPLICA_IDENTITY_INDEX" Michael Paquier 14:56
Re: our checks for read-only queries are not great Laurenz Albe 16:25
Re: our checks for read-only queries are not great Tom Lane 17:06
Re: 12.1 not useable: clientlib fails after a dozen queries (GSSAPI ?) Peter 18:36
Re: [Proposal] Add accumulated statistics for wait event Pavel Stehule 19:11
Re: 12.1 not useable: clientlib fails after a dozen queries (GSSAPI ?) Tom Lane 19:46
Re: Consolidate 'unique array values' logic into a reusable function? Noah Misch 20:59
Re: refactoring - standardize integer parsing in front-end utilities Joe Nelson 21:43
Question regarding heap_multi_insert documentation Daniel Gustafsson 23:03
Re: Question regarding heap_multi_insert documentation Tom Lane 23:25
Re: Question regarding heap_multi_insert documentation 📎 Daniel Gustafsson 23:40
Re: benchmarking Flex practices Tom Lane 23:57

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

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