pgsql-hackers since 2021-03-07 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

March 7, 2021

Thread	Author	Time
[PATCH] pg_ownerships system view 📎	Joel Jacobson	00:08
Re: WIP: document the hook system	David Fetter	00:40
Re: WIP: document the hook system	Tom Lane	01:32
Tablesync early exit	Peter Smith	01:56
Re: [HACKERS] logical decoding of two-phase transactions 📎	Peter Smith	02:04
Re: Parallel INSERT (INTO ... SELECT ...)	Amit Kapila	02:30
Re: Tablesync early exit	Amit Kapila	02:32
Re: Parallel INSERT (INTO ... SELECT ...)	Zhihong Yu	02:57
Re: [HACKERS] logical decoding of two-phase transactions	Amit Kapila	04:00
Re: Parallel INSERT (INTO ... SELECT ...)	Amit Kapila	04:12
Re: CLUSTER on partitioned index 📎	Justin Pryzby	04:13
Re: Parallel INSERT (INTO ... SELECT ...)	Zhihong Yu	04:49
Re: Inquiries about PostgreSQL's system catalog development——from a student developer of Nanjing University	Japin Li	05:31
Re: EXPLAIN/EXPLAIN ANALYZE REFRESH MATERIALIZED VIEW	Japin Li	06:19
Re: EXPLAIN/EXPLAIN ANALYZE REFRESH MATERIALIZED VIEW	Bharath Rupireddy	06:25
Re: EXPLAIN/EXPLAIN ANALYZE REFRESH MATERIALIZED VIEW	Japin Li	06:43
Re: [HACKERS] Custom compression methods	Dilip Kumar	06:46
Re: [HACKERS] Custom compression methods	Justin Pryzby	07:17
Re: pg_stat_statements oddity with track = all	Julien Rouhaud	07:28
Re: [PATCH] postgres-fdw: column option to override foreign types 📎	Dian M Fay	07:37
Re: pg_stat_statements oddity with track = all	Julien Rouhaud	07:39
Re: [HACKERS] Custom compression methods	Dilip Kumar	08:06
RE: pg_upgrade failing for 200+ million Large Objects 📎	Tharakan, Robins	08:43
Re: [HACKERS] Custom compression methods	Justin Pryzby	08:49
Re: A new function to wait for the backend exit after termination 📎	Bharath Rupireddy	09:09
Re: EXPLAIN/EXPLAIN ANALYZE REFRESH MATERIALIZED VIEW 📎	Bharath Rupireddy	09:33
Re: [patch] bit XOR aggregate functions	Vik Fearing	09:36
Re: [patch] bit XOR aggregate functions	Pavel Stehule	09:53
Re: [patch] bit XOR aggregate functions	Vik Fearing	10:02
Re: [patch] bit XOR aggregate functions	Pavel Stehule	10:05
Re: [patch] bit XOR aggregate functions	Vik Fearing	10:13
Re: Should we improve "PID XXXX is not a PostgreSQL server process" warning for pg_terminate_backend(<<postmaster_pid>>)? 📎	Bharath Rupireddy	10:16
Re: [patch] bit XOR aggregate functions	Pavel Stehule	10:24
Re: [patch] bit XOR aggregate functions	Vik Fearing	10:28
Re: [patch] bit XOR aggregate functions	Pavel Stehule	10:37
Re: Improvements and additions to COPY progress reporting 📎	Bharath Rupireddy	11:20
Re: [patch] bit XOR aggregate functions	Vik Fearing	11:39
Re: Support ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION ... syntax	Bharath Rupireddy	11:43
Re: [patch] bit XOR aggregate functions	Pavel Stehule	12:03
Re: EXPLAIN/EXPLAIN ANALYZE REFRESH MATERIALIZED VIEW	Japin Li	12:07
Re: [HACKERS] Custom compression methods	Dilip Kumar	12:34
Re: Support ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION ... syntax 📎	Japin Li	13:50
Re: Nicer error when connecting to standby with hot_standby=off	Fujii Masao	14:39
Re: [patch] bit XOR aggregate functions	Tom Lane	16:31
Re: EXPLAIN/EXPLAIN ANALYZE REFRESH MATERIALIZED VIEW	Zhihong Yu	16:45
Re: Nicer error when connecting to standby with hot_standby=off	Magnus Hagander	17:11
Why isn't pg_stat_get_subscription() marked as proretset?	Tom Lane	18:29
Re: "has_column_privilege()" issue with attnums and non-existent columns	Joe Conway	19:12
Re: "has_column_privilege()" issue with attnums and non-existent columns	Zhihong Yu	19:35
Re: "has_column_privilege()" issue with attnums and non-existent columns 📎	Joe Conway	19:36
Re: [patch] bit XOR aggregate functions	David Rowley	21:08
Re: PoC/WIP: Extended statistics on expressions 📎	Tomas Vondra	21:10
Re: pg_upgrade failing for 200+ million Large Objects	Daniel Gustafsson	22:41

March 8, 2021

Thread	Author	Time
Re: is cfbot's apply aging intentional?	Thomas Munro	00:30
Re: 011_crash_recovery.pl intermittently fails	Kyotaro Horiguchi	00:31
Re: 011_crash_recovery.pl intermittently fails	Kyotaro Horiguchi	00:39
Re: WIP: BRIN multi-range indexes 📎	Tomas Vondra	00:53
Re: 011_crash_recovery.pl intermittently fails	Thomas Munro	01:03
Re: alter table set TABLE ACCESS METHOD 📎	Justin Pryzby	01:07
Re: [PATCH] pg_permissions	David Fetter	01:09
Re: 011_crash_recovery.pl intermittently fails	Tom Lane	01:09
RE: Parallel INSERT (INTO ... SELECT ...) 📎	[email protected]	01:25
Re: Extend more usecase for planning time partition pruning and init partition pruning.	David Rowley	01:34
Re: [HACKERS] logical decoding of two-phase transactions 📎	Peter Smith	01:46
Re: n_mod_since_analyze isn't reset at table truncation	Masahiko Sawada	01:49
RE: [PATCH] pgbench: improve \sleep meta command 📎	miyake_kouta	01:51
Re: pgbench: option delaying queries till connections establishment? 📎	Thomas Munro	02:18
Re: Track replica origin progress for Rollback Prepared	Amit Kapila	02:41
RE: Enhance traceability of wal_level changes for backup management	[email protected]	02:45
Re: automatic analyze: readahead - add "IO read time" log message 📎	Tomas Vondra	03:26
Re: Track replica origin progress for Rollback Prepared	Michael Paquier	03:33
Re: EXPLAIN/EXPLAIN ANALYZE REFRESH MATERIALIZED VIEW 📎	Bharath Rupireddy	04:28
Re: [HACKERS] logical decoding of two-phase transactions	Peter Smith	04:34
Re: n_mod_since_analyze isn't reset at table truncation	Julien Rouhaud	04:34
Re: About to add WAL write/fsync statistics to pg_stat_wal view	Fujii Masao	04:44
Re: 64-bit XIDs in deleted nbtree pages	Masahiko Sawada	04:52
Re: Asynchronous Append on postgres_fdw nodes. 📎	Etsuro Fujita	05:05
Re: Replace buffer I/O locks with condition variables (reviving an old patch) 📎	Thomas Munro	05:10
Re: [HACKERS] logical decoding of two-phase transactions	Amit Kapila	05:19
Re: Huge memory consumption on partitioned table with FKs 📎	Amit Langote	05:27
Re: Asynchronous Append on postgres_fdw nodes.	Etsuro Fujita	05:30
Re: a verbose option for autovacuum	Masahiko Sawada	05:32
Using COPY FREEZE in pgbench 📎	Tatsuo Ishii	05:39
Re: is cfbot's apply aging intentional?	er	05:47
Re: a verbose option for autovacuum	Masahiko Sawada	05:47
RE: [PATCH] pgbench: improve \sleep meta command	[email protected]	05:58
Re: [HACKERS] logical decoding of two-phase transactions	vignesh C	05:58
Re: [HACKERS] logical decoding of two-phase transactions 📎	Ajin Cherian	06:00
Re: Parallel INSERT (INTO ... SELECT ...)	Greg Nancarrow	06:26
Re: [PATCH] pg_permissions 📎	Joel Jacobson	06:28
RE: Parallel INSERT (INTO ... SELECT ...)	[email protected]	06:32
Re: Wired if-statement in gen_partprune_steps_internal	Amit Langote	06:38
Re: [PATCH] pgbench: improve \sleep meta command	Fujii Masao	07:16
Re: Parallel INSERT (INTO ... SELECT ...)	Amit Langote	07:25
Re: alter table set TABLE ACCESS METHOD	Michael Paquier	07:30
RE: [PATCH] pgbench: improve \sleep meta command	[email protected]	07:33
Re: Huge memory consumption on partitioned table with FKs	Andy Fan	07:43
Re: [PATCH] pg_permissions 📎	Joel Jacobson	07:44
Re: [HACKERS] logical decoding of two-phase transactions	Peter Smith	07:56
Re: Improvements and additions to COPY progress reporting	Michael Paquier	08:23
Re: [HACKERS] logical decoding of two-phase transactions	Amit Kapila	08:30
Re: Parallel INSERT (INTO ... SELECT ...)	Amit Kapila	08:31
Re: 011_crash_recovery.pl intermittently fails 📎	Kyotaro Horiguchi	08:32
Re: Parallel INSERT (INTO ... SELECT ...)	Greg Nancarrow	08:42
Re: alter table set TABLE ACCESS METHOD	Michael Paquier	08:56
RE: should INSERT SELECT use a BulkInsertState?	[email protected]	09:07
Make stream_prepare an optional callback 📎	Ajin Cherian	09:13
RE: should INSERT SELECT use a BulkInsertState?	[email protected]	09:18
Re: macOS SIP, next try	Peter Eisentraut	09:20
Re: authtype parameter in libpq	Peter Eisentraut	09:57
Re: [HACKERS] Custom compression methods 📎	Dilip Kumar	10:02
Re: Boundary value check in lazy_tid_reaped()	Peter Eisentraut	10:16
Re: Using COPY FREEZE in pgbench	Laurenz Albe	10:19
Re: Parallel INSERT (INTO ... SELECT ...) 📎	Greg Nancarrow	10:24
Re: pg_upgrade failing for 200+ million Large Objects	Peter Eisentraut	10:25
Re: Using COPY FREEZE in pgbench	Fabien COELHO	10:32
Re: About to add WAL write/fsync statistics to pg_stat_wal view 📎	Masahiro Ikeda	10:42
Re: [HACKERS] logical decoding of two-phase transactions	vignesh C	10:49
Re: pgbench - add pseudo-random permutation function	Fabien COELHO	10:50
Re: Occasional tablespace.sql failures in check-world -jnn	Peter Eisentraut	10:53
RE: pg_upgrade failing for 200+ million Large Objects	Tharakan, Robins	11:00
Re: pg_upgrade failing for 200+ million Large Objects	Tharakan, Robins	11:02
Re: [Patch] ALTER SYSTEM READ ONLY	Dilip Kumar	11:06
Re: Using COPY FREEZE in pgbench 📎	Tatsuo Ishii	11:22
Re: Using COPY FREEZE in pgbench	Tatsuo Ishii	11:23
Re: Huge memory consumption on partitioned table with FKs	Andy Fan	11:39
Re: Using COPY FREEZE in pgbench	Tatsuo Ishii	11:52
Re: pg_upgrade failing for 200+ million Large Objects	Magnus Hagander	12:33
Re: Huge memory consumption on partitioned table with FKs	Amit Langote	12:40
Re: Speeding up GIST index creation for tsvectors	Amit Khandekar	12:43
Re: WIP: BRIN multi-range indexes 📎	Tomas Vondra	12:50
Re: Huge memory consumption on partitioned table with FKs	Andy Fan	12:53
Re: [HACKERS] logical decoding of two-phase transactions	Amit Kapila	12:55
Re: Huge memory consumption on partitioned table with FKs	Amit Langote	12:58
Re: pg_rewind race condition just after promotion 📎	Ibrar Ahmed	13:06
Re: New Table Access Methods for Multi and Single Inserts	Dilip Kumar	13:07
Re: Parallel INSERT (INTO ... SELECT ...)	Amit Kapila	13:18
Re: [HACKERS] logical decoding of two-phase transactions	Amit Kapila	13:26
Re: Parallel INSERT (INTO ... SELECT ...)	Amit Langote	13:48
Re: [PATCH] pgbench: improve \sleep meta command	Alvaro Herrera	14:10
Re: pg_upgrade failing for 200+ million Large Objects	Robins Tharakan	14:13
Re: [PATCH] pg_permissions	Joe Conway	14:35
Re: [HACKERS] logical decoding of two-phase transactions	vignesh C	14:39
Re: Yet another fast GiST build	Ibrar Ahmed	14:41
Re: simplifying foreign key/RI checks	Amit Langote	14:41
RE: non-HOT update not looking at FSM for large tuple update	Floris Van Nee	15:25
Re: popcount 📎	Ibrar Ahmed	15:29
Re: proposal: psql –help reflecting service or URI usage	Mark Dilger	15:39
Re: About to add WAL write/fsync statistics to pg_stat_wal view 📎	Fujii Masao	15:48
Re: [PATCH] pgbench: improve \sleep meta command	Fujii Masao	15:54
Re: [PATCH] New default role allowing to change per-role/database settings	Ibrar Ahmed	15:54
Re: a verbose option for autovacuum	Euler Taveira	15:57
Re: Yet another fast GiST build	Peter Geoghegan	15:59
Re: [PATCH] pg_ownerships system view	Andreas Karlsson	16:04
Re: Evaluate expression at planning time for two more cases 📎	Ibrar Ahmed	16:12
Re: Yet another fast GiST build	Ibrar Ahmed	16:15
Re: [PATCH] regexp_positions ( string text, pattern text, flags text ) → setof int4range[]	Mark Dilger	16:20
Re: Let people set host(no)ssl settings from initdb	Ibrar Ahmed	16:23
Re: pg_amcheck contrib application	Robert Haas	16:26
Re: pg_upgrade failing for 200+ million Large Objects	Tom Lane	16:33
Re: Improvements and additions to COPY progress reporting 📎	Matthias van de Meent	16:33
Re: pg_upgrade failing for 200+ million Large Objects	Magnus Hagander	16:35
Re: proposal: psql –help reflecting service or URI usage	Paul Förster	16:40
Re: ResourceOwner refactoring	Ibrar Ahmed	16:47
Re: [PATCH] New default role allowing to change per-role/database settings 📎	Michael Banck	16:49
Re: shared-memory based stats collector	Ibrar Ahmed	16:55
Re: proposal: psql –help reflecting service or URI usage	Mark Dilger	16:56
Re: pg_upgrade failing for 200+ million Large Objects	Tom Lane	16:58
Re: pg_stat_statements oddity with track = all	Magnus Hagander	17:03
Re: [PATCH] regexp_positions ( string text, pattern text, flags text ) → setof int4range[]	Joel Jacobson	17:05
Re: Yet another fast GiST build 📎	Andrey Borodin	17:06
Re: [PATCH] regexp_positions ( string text, pattern text, flags text ) → setof int4range[]	Mark Dilger	17:11
Re: [PATCH] pg_permissions	Joel Jacobson	17:14
Re: pg_upgrade failing for 200+ million Large Objects	Magnus Hagander	17:18
Re: [PATCH] regexp_positions ( string text, pattern text, flags text ) → setof int4range[]	Joel Jacobson	17:20
Re: TRUNCATE on foreign table 📎	Ibrar Ahmed	17:24
Re: [HACKERS] Custom compression methods	Justin Pryzby	17:29
Re: Re: [PATCH] regexp_positions ( string text, pattern text, flags text ) → setof int4range[]	Tom Lane	17:30
Re: WIP: System Versioned Temporal Table 📎	Ibrar Ahmed	17:33
Re: cryptohash: missing locking functions for OpenSSL <= 1.0.2?	Jacob Champion	18:06
Re: partial heap only tuples	Ibrar Ahmed	18:14
Re: [PATCH] regexp_positions ( string text, pattern text, flags text ) → setof int4range[]	Chapman Flack	18:29
Re: [PATCH] regexp_positions ( string text, pattern text, flags text ) → setof int4range[]	Chapman Flack	18:30
Re: [PATCH] regexp_positions ( string text, pattern text, flags text ) → setof int4range[]	Mark Dilger	18:32
Re: partial heap only tuples	Bossart, Nathan	18:38
Re: [PATCH] regexp_positions ( string text, pattern text, flags text ) → setof int4range[]	Joel Jacobson	18:46
Re: SQL/JSON: functions	Ibrar Ahmed	18:55
Re: New IndexAM API controlling index vacuum strategies	Robert Haas	18:57
Re: Why isn't pg_stat_get_subscription() marked as proretset? 📎	Tom Lane	19:25
Re: [PATCH] regexp_positions ( string text, pattern text, flags text ) → setof int4range[]	Joel Jacobson	19:41
Re: automatic analyze: readahead - add "IO read time" log message 📎	Stephen Frost	19:42
Re: About to add WAL write/fsync statistics to pg_stat_wal view	David G. Johnston	19:47
Re: Re: [PATCH] regexp_positions ( string text, pattern text, flags text ) → setof int4range[]	Tom Lane	20:12
Re: [HACKERS] Custom compression methods	Robert Haas	20:26
Re: pg_amcheck contrib application	Mark Dilger	20:30
Re: Implementing Incremental View Maintenance	Andrew Dunstan	20:42
Re: Confusing behavior of psql's \e	Jacob Champion	20:44
Re: Re: [PATCH] regexp_positions ( string text, pattern text, flags text ) → setof int4range[]	Pavel Stehule	20:46
Re: [HACKERS] Custom compression methods	Justin Pryzby	20:58
Re: Removing vacuum_cleanup_index_scale_factor	Peter Geoghegan	21:00

Browse Archives

Prev | Next