pgsql-hackers since 2024-10-22 16:33

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

Oct. 22, 2024

Thread Author Time
Re: POC: make mxidoff 64 bits 📎 Maxim Orlov 16:33
Re: type cache cleanup improvements 📎 Alexander Korotkov 17:33
Re: Inconsistent use of relpages = -1 📎 Jeff Davis 17:41
Re: Better error reporting from extension scripts (Was: Extend ALTER OPERATOR) Pavel Stehule 18:35
Trigger more frequent autovacuums of heavy insert tables 📎 Melanie Plageman 19:12
Re: EXPLAIN IndexOnlyScan shows disabled when enable_indexonlyscan=on David Rowley 19:21
Re: EXPLAIN IndexOnlyScan shows disabled when enable_indexonlyscan=on Melanie Plageman 19:28
Re: Vacuum statistics 📎 Alena Rybakina 19:30
Re: Using Expanded Objects other than Arrays from plpgsql 📎 Tom Lane 19:33
Re: Make default subscription streaming option as Parallel Masahiko Sawada 19:50
use a non-locking initial test in TAS_SPIN on AArch64 📎 Nathan Bossart 19:54
Re: pgsql: Implement pg_wal_replay_wait() stored procedure 📎 Alexander Korotkov 20:12
Unexpected table size usage for small composite arrays Erik Sjoblom 21:58
Re: Statistics Import and Export Jeff Davis 22:27
Re: Unexpected table size usage for small composite arrays Tom Lane 22:34
Re: Unexpected table size usage for small composite arrays Erik Sjoblom 22:45
Re: Unexpected table size usage for small composite arrays Tom Lane 22:50
Re: Unexpected table size usage for small composite arrays Erik Sjoblom 23:40
Re: Unexpected table size usage for small composite arrays David G. Johnston 23:41
Re: Unexpected table size usage for small composite arrays David G. Johnston 23:42
Re: Unexpected table size usage for small composite arrays David G. Johnston 23:49
Re: Parallel heap vacuum Masahiko Sawada 23:54
RE: Statistics Import and Export 📎 Shinoda, Noriyoshi (SXD Japan FSIP) 23:58

Oct. 23, 2024

Thread Author Time
Re: Make default subscription streaming option as Parallel 📎 Peter Smith 00:27
Re: Unexpected table size usage for small composite arrays Tom Lane 00:44
Re: EXPLAIN IndexOnlyScan shows disabled when enable_indexonlyscan=on 📎 David G. Johnston 00:50
Re: Consider the number of columns in the sort cost model 📎 Andrei Lepikhov 01:39
Re: Inconsistent use of relpages = -1 Laurenz Albe 02:47
Re: use a non-locking initial test in TAS_SPIN on AArch64 Jingtang Zhang 03:01
Re: Make default subscription streaming option as Parallel Amit Kapila 03:52
Re: Enhancing Memory Context Statistics Reporting torikoshia 03:58
Re: proposal: schema variables 📎 Laurenz Albe 04:11
Re: Using Expanded Objects other than Arrays from plpgsql Michel Pelletier 04:15
Refactor to use common function 'get_publications_str'. 📎 Peter Smith 04:44
Re: Enhancing Memory Context Statistics Reporting 📎 Rahila Syed 04:50
Re: Pgoutput not capturing the generated columns Peter Smith 05:00
Re: pgsql: Implement pg_wal_replay_wait() stored procedure Pavel Borisov 06:01
Re: Set query_id for query contained in utility statement 📎 Michael Paquier 06:10
Re: Pgoutput not capturing the generated columns Amit Kapila 06:21
Re: Refactor to use common function 'get_publications_str'. Michael Paquier 06:22
Re: Fix for consume_xids advancing XIDs incorrectly Fujii Masao 06:47
Re: Pgoutput not capturing the generated columns Peter Smith 06:55
Re: Refactor to use common function 'get_publications_str'. 📎 Peter Smith 07:25
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails Jehan-Guillaume de Rorthais 08:01
Re: allowing extensions to control planner behavior Robert Haas 08:05
Remove unnecessary word in a comment 📎 Amit Langote 08:29
Re: Set query_id for query contained in utility statement jian he 08:36
Re: Pgoutput not capturing the generated columns Amit Kapila 08:37
Re: allowing extensions to control planner behavior Andrei Lepikhov 08:51
Re: Remove unnecessary word in a comment Amit Langote 09:07
Refine comments on usage WL_POSTMASTER_DEATH vs WL_EXIT_ON_PM_DEATH 📎 Pavel Borisov 09:18
Re: Set query_id for query contained in utility statement 📎 Anthonin Bonnefoy 09:24
Re: Make default subscription streaming option as Parallel Amit Kapila 10:08
Re: allowing extensions to control planner behavior Robert Haas 11:46
Re: msvc directory missing in PostgreSQL 17.0 Bill Smith 12:25
Re: Unexpected table size usage for small composite arrays Erik Sjoblom 13:18
Re: Proposal for Integrating Data Masking and anonymization into PostgreSQL Alastair Turner 13:25
Re: Using read_stream in index vacuum 📎 Andrey M. Borodin 13:32
Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different. 📎 Tender Wang 13:48
Re: general purpose array_sort 📎 Junwang Zhao 14:28
Re: Using read_stream in index vacuum Junwang Zhao 14:37
Re: use a non-locking initial test in TAS_SPIN on AArch64 Nathan Bossart 14:46
Re: Using read_stream in index vacuum Melanie Plageman 15:17
Re: use a non-locking initial test in TAS_SPIN on AArch64 Nathan Bossart 15:18
Re: Using Expanded Objects other than Arrays from plpgsql Tom Lane 15:21
Re: [PoC] Federated Authn/z with OAUTHBEARER 📎 Daniel Gustafsson 15:46
Re: POC: make mxidoff 64 bits 📎 Maxim Orlov 15:55
Re: Using Expanded Objects other than Arrays from plpgsql Tom Lane 16:04
Re: pgsql: Implement pg_wal_replay_wait() stored procedure Alexander Korotkov 16:21
Re: Statistics Import and Export Jeff Davis 16:46
Re: [PoC] Federated Authn/z with OAUTHBEARER 📎 Jacob Champion 16:46
Re: Refine comments on usage WL_POSTMASTER_DEATH vs WL_EXIT_ON_PM_DEATH Heikki Linnakangas 17:00
Re: Inconsistent use of relpages = -1 Jeff Davis 17:05
Re: Inconsistent use of relpages = -1 Tom Lane 17:20
Re: Refine comments on usage WL_POSTMASTER_DEATH vs WL_EXIT_ON_PM_DEATH Pavel Borisov 17:29
Re: Using read_stream in index vacuum 📎 Andrey M. Borodin 17:57
Re: Fix for consume_xids advancing XIDs incorrectly Masahiko Sawada 20:23
Re: Using read_stream in index vacuum 📎 Andrey M. Borodin 20:27
Fix typo in tidstore.h 📎 Masahiko Sawada 20:53
Re: Trigger more frequent autovacuums of heavy insert tables 📎 Melanie Plageman 21:21
Re: Refactor to use common function 'get_publications_str'. Masahiko Sawada 21:25
Re: Refine comments on usage WL_POSTMASTER_DEATH vs WL_EXIT_ON_PM_DEATH Heikki Linnakangas 21:29
Re: DOCS - pg_replication_slot . Fix the 'inactive_since' description Peter Smith 21:32
Re: Refine comments on usage WL_POSTMASTER_DEATH vs WL_EXIT_ON_PM_DEATH Tom Lane 21:51
Re: Fix typo in tidstore.h David Rowley 22:01
Re: Using read_stream in index vacuum Melanie Plageman 22:04
Can rs_cindex be < 0 for bitmap heap scans? 📎 Melanie Plageman 22:15
Re: Refactor to use common function 'get_publications_str'. 📎 Peter Smith 22:26
Re: Refine comments on usage WL_POSTMASTER_DEATH vs WL_EXIT_ON_PM_DEATH David G. Johnston 22:40
Re: Refactor to use common function 'get_publications_str'. Masahiko Sawada 22:40
Re: [PoC] Federated Authn/z with OAUTHBEARER Jacob Champion 22:40
Re: Fix typo in tidstore.h Masahiko Sawada 22:44
Re: Logical Replication of sequences Masahiko Sawada 22:54
Re: Set query_id for query contained in utility statement Michael Paquier 23:36

Oct. 24, 2024

Thread Author Time
Re: New "raw" COPY format Masahiko Sawada 00:54
Commutation of array SOME/ANY and ALL operators Matthew Morrissette Vance 01:27
Re: Using Expanded Objects other than Arrays from plpgsql Michel Pelletier 01:39
Re: Commutation of array SOME/ANY and ALL operators Tom Lane 01:57
Re: Inconsistent use of relpages = -1 Laurenz Albe 02:01
Re: Using Expanded Objects other than Arrays from plpgsql Tom Lane 02:10
Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different. Tender Wang 02:10
Re: Using Expanded Objects other than Arrays from plpgsql Michel Pelletier 02:10
Re: Refactor GetLockStatusData() by skipping unused backends and groups Bertrand Drouvot 02:12
Re: Set query_id for query contained in utility statement 📎 Michael Paquier 02:28
Re: Using Expanded Objects other than Arrays from plpgsql Tom Lane 02:38
Re: Inval reliability, especially for inplace updates 📎 Noah Misch 02:53
Re: Refactor to use common function 'get_publications_str'. Michael Paquier 04:17
Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different. Tender Wang 04:46
Re: Can rs_cindex be < 0 for bitmap heap scans? Dilip Kumar 04:50
Re: Conflict detection for update_deleted in logical replication Peter Smith 05:00
Re: Missing installation of Kerberos.pm and AdjustUpgrade.pm 📎 Michael Paquier 05:51
Re: Enhancing Memory Context Statistics Reporting Rahila Syed 05:59
Re: Refactor to use common function 'get_publications_str'. Peter Smith 06:27
Re: New "raw" COPY format 📎 Joel Jacobson 06:30
Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different. Amit Langote 06:33
Re: [BUG FIX] Fix validation of COPY options FORCE_NOT_NULL/FORCE_NULL Joel Jacobson 06:41
Re: Refactor to use common function 'get_publications_str'. Michael Paquier 06:41
Re: [BUG FIX] Fix validation of COPY options FORCE_NOT_NULL/FORCE_NULL Michael Paquier 06:43
Re: Refactor to use common function 'get_publications_str'. Peter Smith 06:44
Re: Pgoutput not capturing the generated columns 📎 vignesh C 06:45
Re: Pgoutput not capturing the generated columns Amit Kapila 06:47
Re: Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different. Tender Wang 07:01
Re: Using read_stream in index vacuum 📎 Andrey M. Borodin 07:15
Typo spotted in GetFileBackupMethod comment(?) 📎 Haoran Zhang 07:15
Re: Collation & ctype method table, and extension hooks 📎 Andreas Karlsson 08:05
Re: proposal: schema variables 📎 Laurenz Albe 08:29
[PoC] Partition path cache 📎 Bykov Ivan 08:45
execute prepared statement passing parameter expression with COLLATE clause jian he 08:56
Re: Use function smgrclose() to replace the loop Steven Niu 09:09
Re: execute prepared statement passing parameter expression with COLLATE clause Tender Wang 09:19
Re: Commutation of array SOME/ANY and ALL operators Matthew Morrissette Vance 09:55
Re: Pgoutput not capturing the generated columns Amit Kapila 11:14
Re: Using read_stream in index vacuum 📎 Andrey M. Borodin 11:14
Re: general purpose array_sort jian he 12:39
Useless field ispartitioned in CreateStmtContext hugo 13:07
Re: Can rs_cindex be < 0 for bitmap heap scans? Melanie Plageman 13:40
Re: Add support to TLS 1.3 cipher suites and curves lists Daniel Gustafsson 13:52
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails Alexander Lakhin 14:00
Re: Useless field ispartitioned in CreateStmtContext Alena Rybakina 14:23
Re: general purpose array_sort Junwang Zhao 14:33
Re: execute prepared statement passing parameter expression with COLLATE clause Tom Lane 14:34
Re: Fix for consume_xids advancing XIDs incorrectly Fujii Masao 14:55
Re: general purpose array_sort Aleksander Alekseev 14:57
Re: Inconsistent use of relpages = -1 Jeff Davis 15:03
Re: general purpose array_sort David G. Johnston 15:11
Re: Pgoutput not capturing the generated columns 📎 vignesh C 15:17
Re: Pgoutput not capturing the generated columns vignesh C 15:20
Re: Inconsistent use of relpages = -1 Laurenz Albe 15:22
Re: Refactor GetLockStatusData() by skipping unused backends and groups Fujii Masao 15:23
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails Tender Wang 15:27
Re: general purpose array_sort Aleksander Alekseev 15:27
cache lookup failed when \d t concurrent with DML change column data type jian he 15:30
Re: general purpose array_sort David G. Johnston 15:40
Re: Better error reporting from extension scripts (Was: Extend ALTER OPERATOR) Tom Lane 15:47
Re: general purpose array_sort Tom Lane 16:06
Re: general purpose array_sort David G. Johnston 16:47
Re: Retire support for OpenSSL 1.1.1 due to raised API requirements Daniel Gustafsson 17:00
Re: general purpose array_sort Aleksander Alekseev 17:18
Re: Using Expanded Objects other than Arrays from plpgsql Tom Lane 18:32
Re: Trigger more frequent autovacuums of heavy insert tables Greg Sabino Mullane 19:51
vacuumdb --analyze-only (e.g., after a major upgrade) vs. partitioned tables: pg_statistic missing stats for the partitioned table itself Nikolay Samokhvalov 21:48
Re: Using read_stream in index vacuum Rahila Syed 21:55
Re: [PoC] Federated Authn/z with OAUTHBEARER Jacob Champion 22:28
Re: Retire support for OpenSSL 1.1.1 due to raised API requirements Michael Paquier 22:28
Re: Refactor to use common function 'get_publications_str'. 📎 Peter Smith 22:28
Re: Refactor to use common function 'get_publications_str'. Michael Paquier 22:59
Re: [PoC] Partition path cache Andy Fan 23:51

Oct. 25, 2024

Thread Author Time
Re: Changing the default random_page_cost value Greg Sabino Mullane 00:01
Re: Changing the default random_page_cost value Greg Sabino Mullane 00:13
Re: Enhancing Memory Context Statistics Reporting torikoshia 00:21
Re: SQL:2011 application time 📎 Paul Jungwirth 00:22
Re: Add isolation test template in injection_points for wait/wakeup/detach Michael Paquier 00:33
Docs Build in CI failing with "failed to load external entity" Melanie Plageman 00:33
Re: Wrong results with grouping sets Richard Guo 01:09
Re: Changing the default random_page_cost value David Rowley 01:29
Re: Docs Build in CI failing with "failed to load external entity" Tom Lane 01:44
Re: Missing installation of Kerberos.pm and AdjustUpgrade.pm Michael Paquier 01:58
Re: cache lookup failed when \d t concurrent with DML change column data type Andrei Lepikhov 03:05
Re: POC: make mxidoff 64 bits wenhui qiu 03:38
Re: Changing the default random_page_cost value wenhui qiu 03:56
Re: Row pattern recognition 📎 Tatsuo Ishii 04:04
Re: Can rs_cindex be < 0 for bitmap heap scans? Dilip Kumar 04:41
Re: cache lookup failed when \d t concurrent with DML change column data type Andrei Lepikhov 04:51
Re: pgbench: Improve result outputs related to failed transactinos Alexander Lakhin 05:00
Re: Refactor to use common function 'get_publications_str'. Peter Smith 05:03
Re: proposal: schema variables Pavel Stehule 05:21
Re: Docs Build in CI failing with "failed to load external entity" Thomas Munro 05:22
Re: pgsql: Implement pg_wal_replay_wait() stored procedure Heikki Linnakangas 06:06
Re: pgbench: Improve result outputs related to failed transactinos Tatsuo Ishii 06:15
RE: Conflict detection for update_deleted in logical replication 📎 Hayato Kuroda (Fujitsu) 06:17
Re: altering a column's collation leaves an invalid foreign key 📎 jian he 06:23
Re: altering a column's collation leaves an invalid foreign key jian he 06:27
Re: Pgoutput not capturing the generated columns Amit Kapila 06:37
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails 📎 Tender Wang 06:51
Re: cache lookup failed when \d t concurrent with DML change column data type Kirill Reshke 07:15
Re: Useless field ispartitioned in CreateStmtContext Kirill Reshke 07:31
Re: proposal: schema variables Laurenz Albe 07:41
Re: proposal: schema variables James Pang 07:58
Re: proposal: schema variables James Pang 07:59
Forbid to DROP temp tables of other sessions Daniil Davydov 08:02

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