pgsql-hackers before 2021-04-06 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)

Browse Archives

Prev | Next

April 3, 2021

Thread Author Time
Re: [PATCH] Implement motd for PostgreSQL Chapman Flack 13:43
Re: TRUNCATE on foreign table 📎 Kazutaka Onishi 13:46
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Bharath Rupireddy 13:47
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Pavel Stehule 14:08
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Michael Lewis 14:10
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Justin Pryzby 14:16
Re: TRUNCATE on foreign table Bharath Rupireddy 14:34
Re: TRUNCATE on foreign table Zhihong Yu 14:38
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai 14:59
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Bruce Momjian 15:04
Re: TRUNCATE on foreign table Zhihong Yu 15:04
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai 15:08
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Bruce Momjian 15:12
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai 15:22
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Bruce Momjian 15:24
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai 15:30
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai 15:33
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Pavel Stehule 15:35
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Bruce Momjian 15:38
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Tom Lane 15:39
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Justin Pryzby 15:41
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Bruce Momjian 15:42
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Bruce Momjian 15:43
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai 15:44
Re: [PATCH] Implement motd for PostgreSQL Fabien COELHO 15:50
Re: CLUSTER on partitioned index Zhihong Yu 16:14
Re: SP-GiST confusion: indexed column's type vs. index column type Tom Lane 17:16
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai 17:36
Re: Replication slot stats misgivings 📎 vignesh C 17:37
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Pavel Stehule 17:41
Re: Replication slot stats misgivings vignesh C 17:41
Re: Additional Chapter for Tutorial - arch-dev.sgml Jürgen Purtz 17:43
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai 17:45
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Pavel Stehule 17:50
Re: multi-install PostgresNode fails with older postgres versions Andrew Dunstan 18:01
Re: [PATCH] Implement motd for PostgreSQL Joel Jacobson 18:24
Re: insensitive collations Jim Finnerty 18:47
Re: [PATCH] Implement motd for PostgreSQL Chapman Flack 18:48
Re: Additional Chapter for Tutorial - arch-dev.sgml Alvaro Herrera 19:01
Re: Making wait events a bit more efficient Andres Freund 19:08
Re: [PATCH] Implement motd for PostgreSQL Alvaro Herrera 19:16
Re: Autovacuum on partitioned table (autoanalyze) 📎 Alvaro Herrera 19:42
Re: MultiXact\SLRU buffers configuration Andrey Borodin 19:57
Re: SP-GiST confusion: indexed column's type vs. index column type 📎 Tom Lane 20:06
Re: insensitive collations Daniel Verite 20:23
Re: Confusing behavior of psql's \e Tom Lane 21:43
Allowing dsm allocations in single user mode Andres Freund 23:29

April 4, 2021

Thread Author Time
Re: ALTER TABLE ADD COLUMN fast default Andrew Gierth 00:41
Re: ModifyTable overheads in generic plans Tom Lane 01:20
[PATCH] force_parallel_mode and GUC categories 📎 Justin Pryzby 01:25
Re: New IndexAM API controlling index vacuum strategies 📎 Peter Geoghegan 01:59
Re: Lowering the ever-growing heap->pd_lower Peter Geoghegan 02:07
Re: ALTER TABLE ADD COLUMN fast default Tom Lane 02:09
Unused variable found in AttrDefaultFetch 📎 Zhihong Yu 02:47
RE: Stronger safeguard for archive recovery not to miss data 📎 [email protected] 02:58
RE: Stronger safeguard for archive recovery not to miss data [email protected] 03:07
Re: TRUNCATE on foreign table Bharath Rupireddy 04:07
Re: Unused variable found in AttrDefaultFetch Bharath Rupireddy 04:43
Re: Unused variable found in AttrDefaultFetch Michael Paquier 04:53
Re: Unused variable found in AttrDefaultFetch Tom Lane 05:00
Re: TRUNCATE on foreign table Kohei KaiGai 05:13
Re: Crash in BRIN minmax-multi indexes 📎 Jaime Casanova 05:25
Re: [PATCH] Implement motd for PostgreSQL Joel Jacobson 05:55
Re: [PATCH] Implement motd for PostgreSQL Joel Jacobson 06:23
Re: TRUNCATE on foreign table 📎 Kazutaka Onishi 06:30
Re: [PATCH] Implement motd for PostgreSQL Fabien COELHO 07:16
Re: TRUNCATE on foreign table 📎 Kazutaka Onishi 07:18
Re: [PATCH] Implement motd for PostgreSQL Joel Jacobson 07:25
Re: simplifying foreign key/RI checks 📎 Amit Langote 08:19
Re: simplifying foreign key/RI checks Amit Langote 08:20
Re: proposal: schema variables 📎 Pavel Stehule 08:30
Re: Additional Chapter for Tutorial - arch-dev.sgml Jürgen Purtz 09:07
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai 11:10
[PATCH] typo fix in collationcmds.c: "if they are distinct" 📎 Anton Voloshin 12:49
Re: insensitive collations Jim Finnerty 13:11
Re: ALTER TABLE ADD COLUMN fast default Justin Pryzby 13:19
Re: Unused variable found in AttrDefaultFetch Zhihong Yu 13:39
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? 📎 Julien Rouhaud 14:18
Re: ModifyTable overheads in generic plans Amit Langote 14:34
Re: TRUNCATE on foreign table Bharath Rupireddy 14:56
Re: Allow batched insert during cross-partition updates 📎 Amit Langote 15:05
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan 15:08
Re: Unused variable found in AttrDefaultFetch Andrew Dunstan 15:13
Re: TRUNCATE on foreign table 📎 Kazutaka Onishi 15:18
Re: TRUNCATE on foreign table Bharath Rupireddy 15:20
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan 15:21
possible repalloc() in icu_convert_case() 📎 Anton Voloshin 15:34
Re: Unused variable found in AttrDefaultFetch Zhihong Yu 15:47
Re: Unused variable found in AttrDefaultFetch Zhihong Yu 16:00
Re: ALTER TABLE ADD COLUMN fast default 📎 Tom Lane 16:05
Re: Unused variable found in AttrDefaultFetch Tom Lane 16:07
Re: Allow batched insert during cross-partition updates Zhihong Yu 16:19
Re: possible repalloc() in icu_convert_case() Tom Lane 16:20
Re: ModifyTable overheads in generic plans Tom Lane 16:43
Re: TRUNCATE on foreign table 📎 Kazutaka Onishi 16:53
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan 17:01
Re: Additional Chapter for Tutorial - arch-dev.sgml Alvaro Herrera 17:02
Re: ALTER TABLE ADD COLUMN fast default Zhihong Yu 17:31
Re: Crash in BRIN minmax-multi indexes Tomas Vondra 17:52
Re: Crash in BRIN minmax-multi indexes Tomas Vondra 18:01
Re: possible repalloc() in icu_convert_case() Anton Voloshin 18:09
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan 18:18
Re: pgbench - add pseudo-random permutation function Dean Rasheed 18:21
Re: SP-GiST confusion: indexed column's type vs. index column type Tom Lane 18:40
Re: [PATCH] Implement motd for PostgreSQL Dagfinn Ilmari Mannsåker 18:42
Re: ALTER TABLE ADD COLUMN fast default Justin Pryzby 19:00
Re: Autovacuum on partitioned table (autoanalyze) Tomas Vondra 19:08
Re: GSoC 2021 - Student looking for a mentor - Magzum Assanbayev Gavin Flower 19:46
Re: policies with security definer option for allowing inline optimization Noah Misch 19:51
Re: Flaky vacuum truncate test in reloptions.sql 📎 Arseny Sher 20:00
Re: Autovacuum on partitioned table (autoanalyze) Alvaro Herrera 20:05
Re: Autovacuum on partitioned table (autoanalyze) Tomas Vondra 21:29
Re: debian bugrept involving fast default crash in pg11.7 Andrew Dunstan 21:54
Re: Extensions not dumped when --schema is used 📎 Noah Misch 22:08
Re: Support for NSS as a libpq TLS backend 📎 Daniel Gustafsson 22:13
Re: ALTER TABLE ADD COLUMN fast default Tom Lane 22:50
Re: Autovacuum on partitioned table (autoanalyze) Alvaro Herrera 22:51

April 5, 2021

Thread Author Time
Re: pg_amcheck contrib application 📎 Mark Dilger 00:02
Re: Autovacuum on partitioned table (autoanalyze) Tomas Vondra 00:44
Re: Improve error matching patterns in the SSL tests Michael Paquier 01:36
Re: Support for NSS as a libpq TLS backend 📎 Michael Paquier 02:12
Re: [PATCH] typo fix in collationcmds.c: "if they are distinct" Michael Paquier 02:20
Re: Get memory contexts of an arbitrary backend process 📎 torikoshia 02:55
Re: Get memory contexts of an arbitrary backend process Zhihong Yu 03:20
Re: A new function to wait for the backend exit after termination 📎 Bharath Rupireddy 03:21
Re: Logical Replication - improve error message while adding tables to the publication in check_publication_add_relation 📎 Bharath Rupireddy 03:27
Re: Stronger safeguard for archive recovery not to miss data 📎 Fujii Masao 03:34
Re: Get memory contexts of an arbitrary backend process Fujii Masao 03:59
Re: Can we remove extra memset in BloomInitPage, GinInitPage and SpGistInitPage when we have it in PageInit? Bharath Rupireddy 04:11
Re: New Table Access Methods for Multi and Single Inserts 📎 Bharath Rupireddy 04:19
Re: badly calculated width of emoji in psql Kyotaro Horiguchi 05:07
Re: [Patch] ALTER SYSTEM READ ONLY 📎 Amul Sul 05:31
Re: Proposal: Save user's original authenticated identity for logging 📎 Michael Paquier 05:47
Re: TRUNCATE on foreign table Bharath Rupireddy 05:59
Re: [PATCH] Implement motd for PostgreSQL Joel Jacobson 06:19
use AV worker items infrastructure for GIN pending list's cleanup 📎 Jaime Casanova 06:31
RE: Stronger safeguard for archive recovery not to miss data [email protected] 07:04
Re: Any objections to implementing LogicalDecodeMessageCB for pgoutput? 📎 Amit Kapila 07:06
Re: Stronger safeguard for archive recovery not to miss data Kyotaro Horiguchi 07:13
Re: Replication slot stats misgivings Bharath Rupireddy 07:14
Re: Failed assertion on standby while shutdown Maxim Orlov 07:30
Re: Stronger safeguard for archive recovery not to miss data Kyotaro Horiguchi 07:36
RE: Stronger safeguard for archive recovery not to miss data [email protected] 08:13
Re: Asynchronous Append on postgres_fdw nodes. 📎 Etsuro Fujita 08:15
Re: Is it useful to record whether plans are generic or custom? torikoshia 09:01
Re: shared-memory based stats collector 📎 Andres Freund 09:29
Re: shared memory stats: high level design decisions: consistency, dropping Andres Freund 09:38
Re: Why reset pgstat during recovery Masahiro Ikeda 10:20
Re: [Patch] ALTER SYSTEM READ ONLY Bharath Rupireddy 11:15
Re: New IndexAM API controlling index vacuum strategies Masahiko Sawada 11:30
Re: Flaky vacuum truncate test in reloptions.sql Masahiko Sawada 11:55
Re: [Patch] ALTER SYSTEM READ ONLY 📎 Amul Sul 11:57
Re: Get memory contexts of an arbitrary backend process 📎 torikoshia 12:03
Re: pgbench - add pseudo-random permutation function 📎 Fabien COELHO 12:07
Re: [EXTERNAL] Re: Crash in record_type_typmod_compare 📎 Sait Talha Nisanci 12:07
Re: Any objections to implementing LogicalDecodeMessageCB for pgoutput? Euler Taveira 12:15
Re: Stronger safeguard for archive recovery not to miss data Fujii Masao 12:16
Re: Logical Replication - improve error message while adding tables to the publication in check_publication_add_relation Euler Taveira 13:11
Re: badly calculated width of emoji in psql Pavel Stehule 13:13
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan 13:15
Re: Additional Chapter for Tutorial - arch-dev.sgml 📎 Jürgen Purtz 13:18
Re: use AV worker items infrastructure for GIN pending list's cleanup Euler Taveira 13:41
Re: ModifyTable overheads in generic plans 📎 Amit Langote 13:42
Re: Logical Replication - improve error message while adding tables to the publication in check_publication_add_relation 📎 Bharath Rupireddy 13:49
Re: Replication slot stats misgivings vignesh C 13:54
Re: TRUNCATE on foreign table 📎 Kazutaka Onishi 14:08
Re: TRUNCATE on foreign table Bharath Rupireddy 14:35
Re: use AV worker items infrastructure for GIN pending list's cleanup Jaime Casanova 14:47
RE: Stronger safeguard for archive recovery not to miss data [email protected] 14:49
RE: Stronger safeguard for archive recovery not to miss data [email protected] 14:54
Re: Get memory contexts of an arbitrary backend process 📎 Fujii Masao 15:08
Re: TRUNCATE on foreign table Kazutaka Onishi 15:17
Re: Replication slot stats misgivings 📎 vignesh C 15:21
Re: Additional Chapter for Tutorial - arch-dev.sgml Alvaro Herrera 15:48
Re: ALTER TABLE ADD COLUMN fast default 📎 Tom Lane 16:10
Re: ALTER TABLE ADD COLUMN fast default Tom Lane 16:21
Re: Have I found an interval arithmetic bug? Justin Pryzby 16:33
Re: Proposal: Save user's original authenticated identity for logging 📎 Jacob Champion 16:40
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Bruce Momjian 17:16
Re: Failed assertion on standby while shutdown Fujii Masao 17:31
Re: New predefined roles- 'pg_read/write_all_data' Stephen Frost 17:46
Re: Have I found an interval arithmetic bug? 📎 Bruce Momjian 18:01
Re: Have I found an interval arithmetic bug? Justin Pryzby 18:15
Re: [PATCH] New default role allowing to change per-role/database settings Stephen Frost 18:33
Re: Have I found an interval arithmetic bug? Bruce Momjian 18:37
Re: Stronger safeguard for archive recovery not to miss data David Steele 19:23
Table AM and DROP TABLE [ Was: Table AM and DDLs] Mats Kindahl 19:57
Re: Have I found an interval arithmetic bug? Bryn Llewellyn 20:06
Re: Have I found an interval arithmetic bug? Bruce Momjian 20:35
Re: Have I found an interval arithmetic bug? Bryn Llewellyn 20:58
Re: New IndexAM API controlling index vacuum strategies Matthias van de Meent 21:44
GSoc Applicant Mohamed Mansour 21:46
Fwd: GSoc Applicant 📎 Mohamed Mansour 21:52
Re: New IndexAM API controlling index vacuum strategies Peter Geoghegan 22:39
Re: [PATCH] Covering SPGiST index Tom Lane 22:52
Re: New IndexAM API controlling index vacuum strategies Tom Lane 23:29
RE: Stronger safeguard for archive recovery not to miss data [email protected] 23:31
Re: New IndexAM API controlling index vacuum strategies Masahiko Sawada 23:32
Re: postgres_fdw: IMPORT FOREIGN SCHEMA ... LIMIT TO (partition) Fujii Masao 23:34
Re: New IndexAM API controlling index vacuum strategies Peter Geoghegan 23:53

Browse Archives

Prev | Next