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

July 24, 2021

Thread Author Time
Re: visibility map corruption Bruce Momjian 00:08
Re: visibility map corruption Peter Geoghegan 00:47
Re: visibility map corruption Bruce Momjian 01:01
Re: Followup Timestamp to timestamp with TZ conversion Robert Haas 01:02
Re: A micro-optimisation for ProcSendSignal() 📎 Soumyadeep Chakraborty 05:26
proposal: plpgsql: special comments that will be part of AST Pavel Stehule 05:39
Re: [bug?] Missed parallel safety checks, and wrong parallel safety Amit Kapila 09:52
Re: Logical replication error "no record found" /* shouldn't happen */ Michail Nikolaev 10:26
Re: Incorrect usage of strtol, atoi for non-numeric junk inputs Michael Paquier 10:41
Re: Avoiding data loss with synchronous replication 📎 Andrey Borodin 10:52
Re: Avoiding data loss with synchronous replication Andrey Borodin 10:53
Maintain the pathkesy for subquery from outer side information Andy Fan 13:14
Re: visibility map corruption Bruce Momjian 14:01
Re: Maintain the pathkesy for subquery from outer side information Tom Lane 14:14
Re: Maintain the pathkesy for subquery from outer side information Andy Fan 14:19
Re: Maintain the pathkesy for subquery from outer side information Tom Lane 14:34
Re: Use WaitLatch for {pre, post}_auth_delay instead of pg_usleep 📎 Bharath Rupireddy 16:16
Re: Configure with thread sanitizer fails the thread test Tom Lane 16:20
Re: CREATE SEQUENCE with RESTART option 📎 Bharath Rupireddy 16:26
Re: DROP INDEX CONCURRENTLY on partitioned index Justin Pryzby 16:46
log_checkpoint's "WAL file(s) added" is misleading to the point of uselessness Andres Freund 22:50
Re: log_checkpoint's "WAL file(s) added" is misleading to the point of uselessness Andres Freund 23:02
Re: something is wonky with pgbench pipelining Andres Freund 23:08

July 25, 2021

Thread Author Time
Re: Avoiding data loss with synchronous replication Andres Freund 00:24
Re: Avoiding data loss with synchronous replication Andres Freund 00:29
Re: Removing "long int"-related limit on hash table sizes Andres Freund 01:25
Re: Removing "long int"-related limit on hash table sizes Bruce Momjian 01:39
Re: log_checkpoint's "WAL file(s) added" is misleading to the point of uselessness Fujii Masao 03:10
pgsql: Deduplicate choice of horizon for a relation procarray.c. Andres Freund 03:34
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic Andres Freund 03:34
Re: Maintain the pathkesy for subquery from outer side information Andy Fan 08:16
Re: Avoiding data loss with synchronous replication Andrey Borodin 09:13
Re: [PROPOSAL] new diagnostic items for the dynamic sql Dinesh Chemuduru 10:52
Re: [PROPOSAL] new diagnostic items for the dynamic sql Pavel Stehule 11:03
Re: proposal: plpgsql: special comments that will be part of AST Pavel Stehule 13:34
Re: Rename of triggers for partitioned tables Tom Lane 14:49
Re: Planning counters in pg_stat_statements (using pgss_store) Tom Lane 16:03
Re: [PoC] Improve dead tuple storage for lazy vacuum 📎 Yura Sokolov 16:07
Re: Removing "long int"-related limit on hash table sizes Tom Lane 16:28
Re: Planning counters in pg_stat_statements (using pgss_store) Julien Rouhaud 16:36
Re: Planning counters in pg_stat_statements (using pgss_store) Tom Lane 16:59
Re: Planning counters in pg_stat_statements (using pgss_store) Julien Rouhaud 17:08
Re: Removing "long int"-related limit on hash table sizes Ranier Vilela 17:19
Re: when the startup process doesn't (logging startup delays) Justin Pryzby 17:56
Re: Removing "long int"-related limit on hash table sizes Tom Lane 18:53
Re: Have I found an interval arithmetic bug? Bryn Llewellyn 18:56
Re: Removing "long int"-related limit on hash table sizes Ranier Vilela 19:57
Re: Planning counters in pg_stat_statements (using pgss_store) Andrew Dunstan 22:25
Re: Planning counters in pg_stat_statements (using pgss_store) Tom Lane 22:46

July 26, 2021

Thread Author Time
Re: logical replication empty transactions Peter Smith 01:20
Re: Planning counters in pg_stat_statements (using pgss_store) 📎 Julien Rouhaud 01:36
Re: logical replication empty transactions Greg Nancarrow 02:03
RE: Added schema level support for publication. [email protected] 02:11
Re: Fix memory leak when output postgres_fdw's "Relations" Michael Paquier 02:13
Re: Removing "long int"-related limit on hash table sizes Michael Paquier 02:38
Re: Added schema level support for publication. Greg Nancarrow 02:47
Re: Outdated comment in get_agg_clause_costs David Rowley 02:58
Re: Skipping logical replication transactions on subscriber side 📎 Masahiko Sawada 02:58
Re: Planning counters in pg_stat_statements (using pgss_store) Tom Lane 03:26
Re: Planning counters in pg_stat_statements (using pgss_store) Julien Rouhaud 03:32
Re: Planning counters in pg_stat_statements (using pgss_store) Fujii Masao 03:35
Re: [Doc] Tiny fix for regression tests example Michael Paquier 04:04
RE: logical replication empty transactions [email protected] 04:12
Re: Inaccurate error message when set fdw batch_size to 0 📎 Bharath Rupireddy 04:56
Re: [BUG]Update Toast data failure in logical replication Dilip Kumar 05:15
Re: Added schema level support for publication. 📎 vignesh C 05:21
Re: Added schema level support for publication. vignesh C 05:25
RE: [Doc] Tiny fix for regression tests example 📎 [email protected] 05:50
Re: Incorrect usage of strtol, atoi for non-numeric junk inputs 📎 Michael Paquier 06:01
Some code cleanup for pgbench and pg_verifybackup 📎 Michael Paquier 07:01
Re: something is wonky with pgbench pipelining Michael Paquier 07:07
Re: pg_upgrade don't echo windows commands Michael Paquier 07:13
Re: [Doc] Tiny fix for regression tests example Michael Paquier 07:28
Re: Logical Replication - improve error message while adding tables to the publication in check_publication_add_relation 📎 Bharath Rupireddy 07:33
Re: CREATE SEQUENCE with RESTART option Michael Paquier 07:57
Re: Some code cleanup for pgbench and pg_verifybackup Fabien COELHO 08:13
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith 08:45
Re: Incorrect usage of strtol, atoi for non-numeric junk inputs Kyotaro Horiguchi 08:46
Re: shared-memory based stats collector Kyotaro Horiguchi 08:52
Re: speed up verifying UTF-8 📎 John Naylor 11:09
Re: speed up verifying UTF-8 Vladimir Sitnikov 11:55
Re: 2021-07 CF now in progress Ibrar Ahmed 12:52
Re: Skip temporary table schema name from explain-verbose output. Simon Riggs 12:53
Re: speed up verifying UTF-8 John Naylor 12:56
Re: speed up verifying UTF-8 John Naylor 12:58
Re: Support for NSS as a libpq TLS backend 📎 Daniel Gustafsson 13:26
Re: .ready and .done files considered harmful Robert Haas 13:31
Re: WIP: Relaxing the constraints on numeric scale Dean Rasheed 13:51
Re: [PoC] Improve dead tuple storage for lazy vacuum Masahiko Sawada 14:01
Re: SQL/JSON: JSON_TABLE Daniel Gustafsson 14:12
Re: when the startup process doesn't (logging startup delays) Robert Haas 14:13
Re: Skip temporary table schema name from explain-verbose output. Tom Lane 14:21
Re: [bug?] Missed parallel safety checks, and wrong parallel safety Robert Haas 15:02
Re: Case expression pushdown Tom Lane 15:18
Re: when the startup process doesn't (logging startup delays) 📎 Justin Pryzby 15:30
Re: Case expression pushdown 📎 Alexander Pyhalov 16:03
Re: Inaccurate error message when set fdw batch_size to 0 📎 Fujii Masao 16:07
needless complexity in StartupXLOG 📎 Robert Haas 16:12
Re: .ready and .done files considered harmful Bossart, Nathan 16:14
Re: Skip temporary table schema name from explain-verbose output. 📎 Tom Lane 16:49
Re: Skip temporary table schema name from explain-verbose output. Simon Riggs 17:01
Re: Avoiding data loss with synchronous replication 📎 Bossart, Nathan 17:08
Re: when the startup process doesn't (logging startup delays) Robert Haas 17:11
Re: Rename of triggers for partitioned tables Alvaro Herrera 17:14
Re: Avoiding data loss with synchronous replication Bossart, Nathan 17:14
Re: Skip temporary table schema name from explain-verbose output. Robert Haas 17:15
Re: badly calculated width of emoji in psql 📎 Jacob Champion 17:27
Re: Skip temporary table schema name from explain-verbose output. Alvaro Herrera 17:30
Re: needless complexity in StartupXLOG Stephen Frost 17:32
Re: Use WaitLatch for {pre, post}_auth_delay instead of pg_usleep Bossart, Nathan 17:33
Re: Skip temporary table schema name from explain-verbose output. Tom Lane 17:33
Re: Have I found an interval arithmetic bug? Bruce Momjian 17:35
Re: Rename of triggers for partitioned tables Tom Lane 17:38
Why don't update minimum recovery point in xact_redo_abort 蔡梦娟 (玊于) 17:38
Re: Skip temporary table schema name from explain-verbose output. Alvaro Herrera 17:53
Re: Fix around conn_duration in pgbench Fujii Masao 18:04
Re: Slightly improve initdb --sync-only option's help message 📎 Bossart, Nathan 18:05
Re: Rename of triggers for partitioned tables Arne Roland 18:11
Re: Skip temporary table schema name from explain-verbose output. Tom Lane 18:30
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Robert Haas 19:09
Re: Improve documentation for pg_upgrade, standbys and rsync Stephen Frost 19:11
Re: Removing "long int"-related limit on hash table sizes Alvaro Herrera 19:20
Re: list of extended statistics on psql (\dX) Tomas Vondra 19:26
Re: Some code cleanup for pgbench and pg_verifybackup Alvaro Herrera 19:35
Re: needless complexity in StartupXLOG Robert Haas 19:53
Re: [PATCH] proposal for regexp_count, regexp_instr, regexp_substr and regexp_replace Tom Lane 19:56
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Stephen Frost 20:05
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Robert Haas 20:12
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Robert Haas 20:13
Re: needless complexity in StartupXLOG Stephen Frost 20:15
Re: Removing "long int"-related limit on hash table sizes Dagfinn Ilmari Mannsåker 20:21
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Tom Lane 20:24
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger 20:25
Re: Removing "long int"-related limit on hash table sizes Tom Lane 20:27
Re: log_checkpoint's "WAL file(s) added" is misleading to the point of uselessness Bossart, Nathan 20:27
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Stephen Frost 20:28
Re: Removing "long int"-related limit on hash table sizes Alvaro Herrera 20:39
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Alvaro Herrera 20:46
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Stephen Frost 20:54
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Tom Lane 20:57
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Tom Lane 21:01
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Alvaro Herrera 21:16
Re: automatically generating node support functions Tom Lane 21:25
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Tom Lane 21:30
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Robert Haas 21:33
pg_settings.pending_restart not set when line removed 📎 Alvaro Herrera 23:02
Re: Added schema level support for publication. Greg Nancarrow 23:41
Slim down integer formatting 📎 David Fetter 23:51
Re: Some code cleanup for pgbench and pg_verifybackup Michael Paquier 23:53

July 27, 2021

Thread Author Time
Re: log_checkpoint's "WAL file(s) added" is misleading to the point of uselessness Fujii Masao 00:22
Re: list of extended statistics on psql (\dX) Tatsuro Yamada 00:25
Re: needless complexity in StartupXLOG Justin Pryzby 00:36
Re: log_checkpoint's "WAL file(s) added" is misleading to the point of uselessness Bossart, Nathan 00:40
Re: log_checkpoint's "WAL file(s) added" is misleading to the point of uselessness Andres Freund 00:48
Re: log_checkpoint's "WAL file(s) added" is misleading to the point of uselessness Andres Freund 00:50
RE: row filtering for logical replication [email protected] 00:51
Re: ORDER BY pushdowns seem broken in postgres_fdw 📎 David Rowley 01:19
Re: shared-memory based stats collector Andres Freund 01:27
Re: Incorrect usage of strtol, atoi for non-numeric junk inputs Michael Paquier 01:47
Re: Fix around conn_duration in pgbench 📎 Yugo NAGATA 02:02
a thinko in b676ac443b6 📎 Amit Langote 02:28
Re: Slim down integer formatting 📎 Greg Nancarrow 02:28
Re: Allow batched insert during cross-partition updates 📎 Amit Langote 02:32
Re: [UNVERIFIED SENDER] Re: pg_upgrade can result in early wraparound on databases with high transaction load Bruce Momjian 02:39
Re: visibility map corruption Bruce Momjian 02:39
Re: Slim down integer formatting Michael Paquier 02:42
Re: Slim down integer formatting David Rowley 02:53
Re: Slim down integer formatting Greg Nancarrow 03:08
Re: log_checkpoint's "WAL file(s) added" is misleading to the point of uselessness Bossart, Nathan 03:39
Re: [PoC] Improve dead tuple storage for lazy vacuum Masahiko Sawada 04:06
Re: row filtering for logical replication Dilip Kumar 04:26
Re: Slim down integer formatting David Rowley 04:30
Re: Some code cleanup for pgbench and pg_verifybackup Fabien COELHO 04:36
Re: Slim down integer formatting Andrew Gierth 05:07
Re: [bug?] Missed parallel safety checks, and wrong parallel safety Amit Kapila 05:14
Re: ORDER BY pushdowns seem broken in postgres_fdw Ronan Dunklau 05:20
Re: Use WaitLatch for {pre, post}_auth_delay instead of pg_usleep 📎 Bharath Rupireddy 05:34
Re: Removing unneeded self joins 📎 Andrey V. Lepikhov 05:34
pg_receivewal starting position Ronan Dunklau 05:50
Re: [bug?] Missed parallel safety checks, and wrong parallel safety Dilip Kumar 05:58
Re: Fwd: Emit namespace in post-copy output Corey Huinker 06:01
Re: ATTACH PARTITION locking documentation for DEFAULT partitions 📎 David Rowley 06:02
Re: ORDER BY pushdowns seem broken in postgres_fdw David Rowley 06:05
Re: Inaccurate error message when set fdw batch_size to 0 Bharath Rupireddy 06:06
Re: [PoC] Improve dead tuple storage for lazy vacuum Yura Sokolov 06:06
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith 06:09
Re: [HACKERS] logical decoding of two-phase transactions 📎 Peter Smith 06:11
RE: Added schema level support for publication. 📎 [email protected] 06:51
Re: Slim down integer formatting Greg Nancarrow 06:53
Re: Some code cleanup for pgbench and pg_verifybackup Michael Paquier 06:56
Re: Failed transaction statistics to measure the logical replication progress Ajin Cherian 06:59
Re: Minimal logical decoding on standbys 📎 Drouvot, Bertrand 07:23
Re: [UNVERIFIED SENDER] Re: pg_upgrade can result in early wraparound on databases with high transaction load Drouvot, Bertrand 07:25
Re: alter table set TABLE ACCESS METHOD 📎 Michael Paquier 07:38
Re: .ready and .done files considered harmful 📎 Dipesh Pandit 07:43
Re: row filtering for logical replication 📎 Peter Smith 07:52
Re: Why don't update minimum recovery point in xact_redo_abort Fujii Masao 08:26
Re: [bug?] Missed parallel safety checks, and wrong parallel safety Amit Kapila 08:35
Re: Automatic notification of top transaction IDs Neil Chen 09:18
Re: ATTACH PARTITION locking documentation for DEFAULT partitions Matthias van de Meent 09:35

Browse Archives

Prev | Next