pgsql-hackers since 2021-03-08 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 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
Re: [HACKERS] Custom compression methods	Robert Haas	21:14
proposal - operators ? and ->> for type record, and functions record_keys and record_each_text 📎	Pavel Stehule	21:29
Re: Removing vacuum_cleanup_index_scale_factor	Tom Lane	21:38
Re: proposal - operators ? and ->> for type record, and functions record_keys and record_each_text	Tom Lane	22:12
Re: Proposal: Save user's original authenticated identity for logging	Jacob Champion	22:16
Re: Removing vacuum_cleanup_index_scale_factor 📎	Peter Geoghegan	22:35
Re: PATCH: Batch/pipelining support for libpq	David G. Johnston	22:37
Re: proposal - operators ? and ->> for type record, and functions record_keys and record_each_text	Pavel Stehule	22:44
Re: PATCH: Batch/pipelining support for libpq	'Alvaro Herrera'	23:02
Re: Let people set host(no)ssl settings from initdb	Andrew Dunstan	23:13
Re: non-HOT update not looking at FSM for large tuple update	Matthias van de Meent	23:14
Re: Optimising latch signals	Alvaro Herrera	23:20
Re: cursor sensitivity misunderstanding	David G. Johnston	23:22
Re: documentation fix for SET ROLE	David G. Johnston	23:41
Re: documentation fix for SET ROLE	David G. Johnston	23:48
Re: Proposal: Save user's original authenticated identity for logging	Jacob Champion	23:55

March 9, 2021

Thread	Author	Time
Re: Optimising latch signals	Thomas Munro	00:09
Re: Implementing Incremental View Maintenance	Yugo NAGATA	00:20
Re: Implementing Incremental View Maintenance	Thomas Munro	00:27
RE: Implementing Incremental View Maintenance	[email protected]	00:34
Re: Let people set host(no)ssl settings from initdb	Michael Paquier	00:47
Re: Proposal: Save user's original authenticated identity for logging	Jacob Champion	00:48
Re: Boundary value check in lazy_tid_reaped()	Masahiko Sawada	00:57
Re: cleanup temporary files after crash 📎	Tomas Vondra	01:28
Re: 64-bit XIDs in deleted nbtree pages	Peter Geoghegan	02:03
Re: Disallow SSL compression?	Michael Paquier	02:19
Re: pg_stat_statements oddity with track = all	Julien Rouhaud	02:39
Re: TRUNCATE on foreign table	Amit Langote	02:53
Re: [PATCH] pg_permissions	Chapman Flack	03:01
Re: New IndexAM API controlling index vacuum strategies	Peter Geoghegan	03:34
Add some tests for pg_stat_statements compatibility verification under contrib 📎	Erica Zhang	03:35
Re: [HACKERS] logical decoding of two-phase transactions	Peter Smith	03:44
Re: POC: converting Lists into arrays	[email protected]	03:51
Re: [HACKERS] logical decoding of two-phase transactions	vignesh C	04:21
Re: [HACKERS] logical decoding of two-phase transactions	Amit Kapila	04:44
Re: [HACKERS] logical decoding of two-phase transactions 📎	Peter Smith	05:15
Re: New IndexAM API controlling index vacuum strategies	Peter Geoghegan	05:21
Re: Replace buffer I/O locks with condition variables (reviving an old patch)	Julien Rouhaud	05:25
Re: [HACKERS] logical decoding of two-phase transactions	Amit Kapila	05:31
Re: Improvements and additions to COPY progress reporting	Michael Paquier	05:34
Re: Tablesync early exit 📎	Peter Smith	05:56
Re: [HACKERS] logical decoding of two-phase transactions	vignesh C	06:10
Re: Removing vacuum_cleanup_index_scale_factor	Masahiko Sawada	06:21
Re: [PATCH] pg_permissions	Joel Jacobson	06:34
Re: Make stream_prepare an optional callback	Amit Kapila	06:40
Re: [PoC] Non-volatile WAL buffer 📎	Takashi Menjo	06:53
Re: [PATCH] regexp_positions ( string text, pattern text, flags text ) → setof int4range[]	Joel Jacobson	06:57
RE: Parallel INSERT (INTO ... SELECT ...)	[email protected]	07:07
Re: [HACKERS] Custom compression methods	Justin Pryzby	07:16
RE: [PoC] Non-volatile WAL buffer	[email protected]	07:23
Re: pg_upgrade fails with non-standard ACL 📎	Noah Misch	07:25
Re: [PATCH] regexp_positions ( string text, pattern text, flags text ) → setof int4range[]	Pavel Stehule	07:26
Re: [HACKERS] Custom compression methods	Dilip Kumar	07:34

Browse Archives

Prev | Next