public inbox for [email protected]help / color / mirror / Atom feed
Messages from [email protected] Re: Bug: PG 14 recovery failure 2026-02-18 10:27 UTC David Rowley <[email protected]> Re: Dealing with SeqScans when Time-based Partitions Cut Over 2025-12-18 20:21 UTC David Rowley <[email protected]> Re: Dealing with SeqScans when Time-based Partitions Cut Over 2025-12-18 20:20 UTC David Rowley <[email protected]> Re: RFC 9557 / IXDTF 2025-11-16 21:18 UTC David Rowley <[email protected]> Re: Postgres memoizing inner loop of join when outer loop join key is guaranteed unique? 2025-10-30 00:01 UTC David Rowley <[email protected]> Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) 2025-10-25 04:50 UTC David Rowley <[email protected]> Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) 2025-10-25 02:19 UTC David Rowley <[email protected]> Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) 2025-10-25 01:06 UTC David Rowley <[email protected]> Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) 2025-10-24 22:37 UTC David Rowley <[email protected]> Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) 2025-10-23 19:37 UTC David Rowley <[email protected]> Re: What is the specific release date of PG18? 2025-08-04 07:54 UTC David Rowley <[email protected]> Re: Wrapping a select in another select makes it slower 2025-07-22 22:08 UTC David Rowley <[email protected]> Re: Sudden increase in n_dead_tup with no corresponding insert/update/delete 2025-06-04 00:23 UTC David Rowley <[email protected]> Re: Feature-Request: Performance-Optimization when using limit in combination with order by on querys using union 2025-05-08 13:43 UTC David Rowley <[email protected]> Re: SQL ERROR subquery uses ungrouped column in PostgreSQL 2025-04-30 13:09 UTC David Rowley <[email protected]> Re: Upsert error "column reference is ambiguous" 2025-04-29 12:43 UTC David Rowley <[email protected]> Re: Changing default fillfactor for the whole database 2025-04-27 03:30 UTC David Rowley <[email protected]> Re: explain 2025-04-25 00:36 UTC David Rowley <[email protected]> Re: explain 2025-04-24 13:41 UTC David Rowley <[email protected]> Re: Postgres Query Plan using wrong index 2025-04-03 10:27 UTC David Rowley <[email protected]> Re: Postgres Query Plan using wrong index 2025-04-03 04:41 UTC David Rowley <[email protected]> Re: Querying one partition in a function takes locks on all partitions 2025-03-31 20:28 UTC David Rowley <[email protected]> Re: Querying one partition in a function takes locks on all partitions 2025-03-31 03:10 UTC David Rowley <[email protected]> Re: Querying one partition in a function takes locks on all partitions 2025-03-23 13:35 UTC David Rowley <[email protected]> Re: How to select avg(select max(something) from ...) 2025-02-18 21:06 UTC David Rowley <[email protected]> Re: PG-15.6: timeout parameters erroring out 2025-02-10 04:54 UTC David Rowley <[email protected]> Re: About PostgreSQL Query Plan 2025-01-14 10:09 UTC David Rowley <[email protected]> Re: Why not do distinct before SetOp 2024-11-05 23:38 UTC David Rowley <[email protected]> Re: Why not do distinct before SetOp 2024-11-05 22:11 UTC David Rowley <[email protected]> Re: Why not do distinct before SetOp 2024-11-04 11:09 UTC David Rowley <[email protected]> Re: Max size per relation for partitioned tables 2024-10-29 10:42 UTC David Rowley <[email protected]> Re: Support for dates before 4713 BC 2024-10-17 00:17 UTC David Rowley <[email protected]> Re: Inefficient use of index scan on 2nd column of composite index during concurrent activity 2024-10-15 09:45 UTC David Rowley <[email protected]> Re: How to Copy/Load 1 billions rows into a Partition Tables Fast 2024-10-15 04:57 UTC David Rowley <[email protected]> Re: Overlapping values (?) in multi-column partitioned tables 2024-09-10 23:02 UTC David Rowley <[email protected]> Re: Using left joins instead of inner joins as an optimization 2024-09-06 13:24 UTC David Rowley <[email protected]> Re: optimizing a join against a windowed function 2024-08-30 13:27 UTC David Rowley <[email protected]> Re: Analytic Function Bug 2024-08-30 13:08 UTC David Rowley <[email protected]> Re: Analytic Function Bug 2024-08-30 01:24 UTC David Rowley <[email protected]> Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables. 2024-08-29 06:49 UTC David Rowley <[email protected]> Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables. 2024-08-27 23:57 UTC David Rowley <[email protected]> Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables. 2024-08-27 23:03 UTC David Rowley <[email protected]> Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables. 2024-08-27 11:03 UTC David Rowley <[email protected]> Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables. 2024-08-27 10:14 UTC David Rowley <[email protected]> Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables. 2024-08-27 01:50 UTC David Rowley <[email protected]> Re: Insert query performance 2024-08-20 11:43 UTC David Rowley <[email protected]> Re: Insert query performance 2024-08-19 11:03 UTC David Rowley <[email protected]> Re: Vacuum full connection exhaustion 2024-08-08 23:02 UTC David Rowley <[email protected]> Re: ANALYZE on partitioned tables vs on individual partitions 2024-08-07 08:09 UTC David Rowley <[email protected]> Re: ANALYZE on partitioned tables vs on individual partitions 2024-08-07 05:22 UTC David Rowley <[email protected]> Re: Building v17 Beta2 on Windows 2024-08-05 12:26 UTC David Rowley <[email protected]> Re: Slow performance 2024-07-27 03:27 UTC David Rowley <[email protected]> Re: Planet Postgres and the curse of AI 2024-07-18 13:33 UTC David Rowley <[email protected]> Re: Query on partitioned table needs memory n_partitions * work_mem 2024-07-17 22:27 UTC David Rowley <[email protected]> Re: Query on partitioned table needs memory n_partitions * work_mem 2024-07-11 02:17 UTC David Rowley <[email protected]> Re: Planning of sub partitions 2024-07-05 22:26 UTC David Rowley <[email protected]> Re: Design strategy for table with many attributes 2024-07-05 08:58 UTC David Rowley <[email protected]> Re: Design strategy for table with many attributes 2024-07-05 08:13 UTC David Rowley <[email protected]> Re: Design strategy for table with many attributes 2024-07-05 05:27 UTC David Rowley <[email protected]> Re: A way to optimize sql about the last temporary-related row 2024-06-27 16:16 UTC David Rowley <[email protected]> Re: [EXT] Re: How to delete column level Stats/Histogram 2024-05-31 01:55 UTC David Rowley <[email protected]> Re: How to delete column level Stats/Histogram 2024-05-30 22:45 UTC David Rowley <[email protected]> Re: Use of inefficient index in the presence of dead tuples 2024-05-29 08:10 UTC David Rowley <[email protected]> Re: problem with query 2024-05-21 11:16 UTC David Rowley <[email protected]> Re: problem with query 2024-05-21 10:48 UTC David Rowley <[email protected]> Re: signal 11: Segmentation fault ; query constraint list; pg16.3 2024-05-20 11:01 UTC David Rowley <[email protected]> Re: problem with query 2024-05-15 11:23 UTC David Rowley <[email protected]> Re: SELECT DISTINCT chooses parallel seqscan instead of indexscan on huge table with 1000 partitions 2024-05-13 14:22 UTC David Rowley <[email protected]> Re: SELECT DISTINCT chooses parallel seqscan instead of indexscan on huge table with 1000 partitions 2024-05-13 14:15 UTC David Rowley <[email protected]> Re: SELECT DISTINCT chooses parallel seqscan instead of indexscan on huge table with 1000 partitions 2024-05-13 13:34 UTC David Rowley <[email protected]> Re: SELECT DISTINCT chooses parallel seqscan instead of indexscan on huge table with 1000 partitions 2024-05-13 13:32 UTC David Rowley <[email protected]> Re: SELECT DISTINCT chooses parallel seqscan instead of indexscan on huge table with 1000 partitions 2024-05-13 13:22 UTC David Rowley <[email protected]> Re: SELECT DISTINCT chooses parallel seqscan instead of indexscan on huge table with 1000 partitions 2024-05-11 01:37 UTC David Rowley <[email protected]> Re: SELECT DISTINCT chooses parallel seqscan instead of indexscan on huge table with 1000 partitions 2024-05-11 01:35 UTC David Rowley <[email protected]> Re: Performance degradation after upgrading from 9.5 to 14 2024-04-22 21:43 UTC David Rowley <[email protected]> Re: CLUSTER vs. VACUUM FULL 2024-04-22 01:34 UTC David Rowley <[email protected]> Re: Foreign Key error between two partitioned tables 2024-04-19 23:19 UTC David Rowley <[email protected]> Re: Assistance needed for the query execution in non-public schema 2024-04-16 11:26 UTC David Rowley <[email protected]> Re: constant crashing 2024-04-15 01:59 UTC David Rowley <[email protected]> Re: effect on planner of turning a subquery to a table, sql function returning table 2024-04-12 11:39 UTC David Rowley <[email protected]> Re: effect on planner of turning a subquery to a table, sql function returning table 2024-04-12 10:58 UTC David Rowley <[email protected]> Re: Seeing high query planning time on Azure Postgres Single Server version 11. 2024-03-15 00:26 UTC David Rowley <[email protected]> Re: select results on pg_class incomplete 2024-03-14 20:03 UTC David Rowley <[email protected]> Re: Behavior of debug_parallel_query=regress 2024-02-27 11:34 UTC David Rowley <[email protected]> Re: Partitioning, Identity and Uniqueness (given pg 16 changes) 2024-02-20 01:40 UTC David Rowley <[email protected]> Re: Partitioning, Identity and Uniqueness (given pg 16 changes) 2024-02-19 04:23 UTC David Rowley <[email protected]> Re: Why doesn't Postgres apply limit on groups when retrieving N results per group using WHERE IN + ORDER BY 2024-02-07 12:18 UTC David Rowley <[email protected]> Re: Query performance in 9.6.24 vs 14.10 2024-01-29 03:44 UTC David Rowley <[email protected]> Re: Pgbackrest version 2.28 Bug/Issue 2021-03-02 09:54 UTC David Rowley <[email protected]> 89+ results
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox