agora inbox for [email protected]help / color / mirror / Atom feed
Messages from [email protected] Re: Creating foreign key on partitioned table is too slow 2019-10-31 20:17 UTC David Rowley <[email protected]> Re: Creating foreign key on partitioned table is too slow 2019-10-30 22:19 UTC David Rowley <[email protected]> Re: v12.0: ERROR: could not find pathkey item to sort 2019-10-30 21:47 UTC David Rowley <[email protected]> Re: BRIN index which is much faster never chosen by planner 2019-10-15 22:46 UTC David Rowley <[email protected]> Re: BRIN index which is much faster never chosen by planner 2019-10-15 22:43 UTC David Rowley <[email protected]> Re: BRIN index which is much faster never chosen by planner 2019-10-14 20:48 UTC David Rowley <[email protected]> Re: BRIN index which is much faster never chosen by planner 2019-10-11 08:47 UTC David Rowley <[email protected]> Re: BRIN index which is much faster never chosen by planner 2019-10-11 00:22 UTC David Rowley <[email protected]> Re: Change atoi to strtol in same place 2019-10-08 10:06 UTC David Rowley <[email protected]> Re: Change atoi to strtol in same place 2019-10-07 05:35 UTC David Rowley <[email protected]> Re: Change atoi to strtol in same place 2019-10-07 05:10 UTC David Rowley <[email protected]> Re: Converting NOT IN to anti-joins during planning 2019-09-03 01:13 UTC David Rowley <[email protected]> Re: Speed up transaction completion faster after many relations are accessed in a transaction 2019-08-14 07:25 UTC David Rowley <[email protected]> Re: Custom table AMs need to include heapam.h because of BulkInsertState 2019-08-14 06:11 UTC David Rowley <[email protected]> Re: POC: converting Lists into arrays 2019-08-10 04:03 UTC David Rowley <[email protected]> Re: POC: converting Lists into arrays 2019-08-09 00:52 UTC David Rowley <[email protected]> Re: POC: converting Lists into arrays 2019-08-09 00:41 UTC David Rowley <[email protected]> Re: Tid scan improvements 2019-08-01 21:04 UTC David Rowley <[email protected]> Re: Runtime pruning problem 2019-07-30 23:14 UTC David Rowley <[email protected]> Re: Runtime pruning problem 2019-07-30 22:32 UTC David Rowley <[email protected]> Re: Statistical aggregate functions are not working with PARTIAL aggregation 2019-07-24 23:52 UTC David Rowley <[email protected]> Re: Statistical aggregate functions are not working with PARTIAL aggregation 2019-07-24 22:36 UTC David Rowley <[email protected]> Re: Speed up transaction completion faster after many relations are accessed in a transaction 2019-07-24 07:14 UTC David Rowley <[email protected]> Re: Change atoi to strtol in same place 2019-07-24 04:57 UTC David Rowley <[email protected]> Re: Speed up transaction completion faster after many relations are accessed in a transaction 2019-07-24 04:16 UTC David Rowley <[email protected]> Re: Speed up transaction completion faster after many relations are accessed in a transaction 2019-07-24 03:05 UTC David Rowley <[email protected]> Re: Runtime pruning problem 2019-07-23 08:49 UTC David Rowley <[email protected]> Re: Speed up transaction completion faster after many relations are accessed in a transaction 2019-07-23 06:11 UTC David Rowley <[email protected]> Re: Change ereport level for QueuePartitionConstraintValidation 2019-07-23 02:22 UTC David Rowley <[email protected]> Re: Cleaning up and speeding up string functions 2019-07-22 12:16 UTC David Rowley <[email protected]> Re: Speed up transaction completion faster after many relations are accessed in a transaction 2019-07-22 11:14 UTC David Rowley <[email protected]> Re: POC: converting Lists into arrays 2019-07-22 08:34 UTC David Rowley <[email protected]> Re: Tid scan improvements 2019-07-22 07:24 UTC David Rowley <[email protected]> Re: Index Skip Scan 2019-07-22 05:44 UTC David Rowley <[email protected]> Re: Speed up transaction completion faster after many relations are accessed in a transaction 2019-07-22 04:50 UTC David Rowley <[email protected]> Re: POC: converting Lists into arrays 2019-07-22 04:46 UTC David Rowley <[email protected]> Re: Speed up transaction completion faster after many relations are accessed in a transaction 2019-07-22 02:29 UTC David Rowley <[email protected]> Re: Speed up transaction completion faster after many relations are accessed in a transaction 2019-07-22 01:21 UTC David Rowley <[email protected]> Re: POC: converting Lists into arrays 2019-07-22 01:15 UTC David Rowley <[email protected]> Re: Performance issue in foreign-key-aware join estimation 2019-07-21 22:35 UTC David Rowley <[email protected]> Re: Performance issue in foreign-key-aware join estimation 2019-07-21 13:50 UTC David Rowley <[email protected]> Re: POC: converting Lists into arrays 2019-07-21 13:32 UTC David Rowley <[email protected]> Re: Speed up transaction completion faster after many relations are accessed in a transaction 2019-07-21 09:37 UTC David Rowley <[email protected]> Re: Performance issue in foreign-key-aware join estimation 2019-07-21 05:43 UTC David Rowley <[email protected]> Re: Tid scan improvements 2019-07-19 01:54 UTC David Rowley <[email protected]> Re: Performance issue in foreign-key-aware join estimation 2019-07-18 07:24 UTC David Rowley <[email protected]> Re: Speed up transaction completion faster after many relations are accessed in a transaction 2019-07-18 02:53 UTC David Rowley <[email protected]> Re: Custom table AMs need to include heapam.h because of BulkInsertState 2019-07-17 23:57 UTC David Rowley <[email protected]> Re: Custom table AMs need to include heapam.h because of BulkInsertState 2019-07-17 23:29 UTC David Rowley <[email protected]> Re: Tid scan improvements 2019-07-17 11:10 UTC David Rowley <[email protected]> Re: POC: converting Lists into arrays 2019-07-17 03:02 UTC David Rowley <[email protected]> Re: Parallel Append subplan order instability on aye-aye 2019-07-17 01:20 UTC David Rowley <[email protected]> Re: POC: converting Lists into arrays 2019-07-16 02:56 UTC David Rowley <[email protected]> Re: Change ereport level for QueuePartitionConstraintValidation 2019-07-16 01:15 UTC David Rowley <[email protected]> Re: Change ereport level for QueuePartitionConstraintValidation 2019-07-15 02:03 UTC David Rowley <[email protected]> Re: Using unique btree indexes for pathkeys with one extra column 2019-07-15 01:46 UTC David Rowley <[email protected]> Re: Index Skip Scan 2019-07-11 11:38 UTC David Rowley <[email protected]> Re: Index Skip Scan 2019-07-11 10:12 UTC David Rowley <[email protected]> Re: Index Skip Scan 2019-07-11 05:16 UTC David Rowley <[email protected]> Re: Tid scan improvements 2019-07-10 22:22 UTC David Rowley <[email protected]> Re: Custom table AMs need to include heapam.h because of BulkInsertState 2019-07-10 09:40 UTC David Rowley <[email protected]> Re: Tid scan improvements 2019-07-04 03:43 UTC David Rowley <[email protected]> Re: Cleaning up and speeding up string functions 2019-07-04 01:51 UTC David Rowley <[email protected]> Re: POC: converting Lists into arrays 2019-07-03 22:25 UTC David Rowley <[email protected]> Re: Index Skip Scan 2019-07-03 22:06 UTC David Rowley <[email protected]> Re: Custom table AMs need to include heapam.h because of BulkInsertState 2019-07-03 07:46 UTC David Rowley <[email protected]> Re: Run-time pruning for ModifyTable 2019-07-03 07:34 UTC David Rowley <[email protected]> Re: POC: converting Lists into arrays 2019-07-03 06:56 UTC David Rowley <[email protected]> Re: Index Skip Scan 2019-07-02 12:27 UTC David Rowley <[email protected]> Re: Custom table AMs need to include heapam.h because of BulkInsertState 2019-07-01 13:26 UTC David Rowley <[email protected]> Re: Converting NOT IN to anti-joins during planning 2019-07-01 11:23 UTC David Rowley <[email protected]> Re: BUG #15383: Join Filter cost estimation problem in 10.5 2019-07-01 02:14 UTC David Rowley <[email protected]> Re: Multivariate MCV list vs. statistics target 2019-06-30 07:34 UTC David Rowley <[email protected]> Re: Custom table AMs need to include heapam.h because of BulkInsertState 2019-06-30 05:54 UTC David Rowley <[email protected]> Run-time pruning for ModifyTable 2019-06-27 05:28 UTC David Rowley <[email protected]> Re: Speed up transaction completion faster after many relations are accessed in a transaction 2019-06-26 23:00 UTC David Rowley <[email protected]> Re: Custom table AMs need to include heapam.h because of BulkInsertState 2019-06-24 11:12 UTC David Rowley <[email protected]> Re: Performance issue in foreign-key-aware join estimation 2019-06-16 07:42 UTC David Rowley <[email protected]> Re: Extracting only the columns needed for a query 2019-06-15 04:58 UTC David Rowley <[email protected]> Re: Speed up transaction completion faster after many relations are accessed in a transaction 2019-06-15 03:28 UTC David Rowley <[email protected]> Re: Custom table AMs need to include heapam.h because of BulkInsertState 2019-06-15 00:25 UTC David Rowley <[email protected]> Re: Converting NOT IN to anti-joins during planning 2019-06-14 09:50 UTC David Rowley <[email protected]> Re: Index Skip Scan 2019-06-14 07:19 UTC David Rowley <[email protected]> Re: PostgreSQL 12: Feature Highlights 2019-06-14 03:57 UTC David Rowley <[email protected]> Re: POC: converting Lists into arrays 2019-06-14 02:05 UTC David Rowley <[email protected]> Re: Parallel grouping sets 2019-06-14 00:02 UTC David Rowley <[email protected]> Re: release notes: tids & self-joins 2019-06-13 20:53 UTC David Rowley <[email protected]> Re: Cleaning up and speeding up string functions 2019-06-13 05:24 UTC David Rowley <[email protected]> Re: Parallel grouping sets 2019-06-13 04:29 UTC David Rowley <[email protected]> Re: Custom table AMs need to include heapam.h because of BulkInsertState 2019-06-13 01:42 UTC David Rowley <[email protected]> Re: Should we warn against using too many partitions? 2019-06-12 22:36 UTC David Rowley <[email protected]> Re: using index or check in ALTER TABLE SET NOT NULL 2019-06-11 20:34 UTC David Rowley <[email protected]> Re: Should we warn against using too many partitions? 2019-06-11 20:12 UTC David Rowley <[email protected]> Re: Should we warn against using too many partitions? 2019-06-11 01:30 UTC David Rowley <[email protected]> Re: Should we warn against using too many partitions? 2019-06-10 21:45 UTC David Rowley <[email protected]> Re: Should we warn against using too many partitions? 2019-06-10 09:10 UTC David Rowley <[email protected]> Re: Custom table AMs need to include heapam.h because of BulkInsertState 2019-06-09 23:45 UTC David Rowley <[email protected]> Re: Should we warn against using too many partitions? 2019-06-09 05:44 UTC David Rowley <[email protected]> Re: Should we warn against using too many partitions? 2019-06-09 05:07 UTC David Rowley <[email protected]> Re: Should we warn against using too many partitions? 2019-06-09 01:15 UTC David Rowley <[email protected]> Re: Should we warn against using too many partitions? 2019-06-08 20:29 UTC David Rowley <[email protected]> Re: Should we warn against using too many partitions? 2019-06-07 05:34 UTC David Rowley <[email protected]> Re: Why does not subquery pruning conditions inherit to parent query? 2019-06-06 19:55 UTC David Rowley <[email protected]> Re: Should we warn against using too many partitions? 2019-06-06 19:36 UTC David Rowley <[email protected]> Re: Should we warn against using too many partitions? 2019-06-06 18:59 UTC David Rowley <[email protected]> Re: Should we warn against using too many partitions? 2019-06-06 18:46 UTC David Rowley <[email protected]> Re: Should we warn against using too many partitions? 2019-06-06 04:43 UTC David Rowley <[email protected]> Re: No mention of no CIC support for partitioned index in docs 2019-06-06 00:41 UTC David Rowley <[email protected]> Re: Confusing error message for REINDEX TABLE CONCURRENTLY 2019-06-05 09:08 UTC David Rowley <[email protected]> Re: using index or check in ALTER TABLE SET NOT NULL 2019-05-31 19:06 UTC David Rowley <[email protected]> Re: Comment typo in tableam.h 2019-05-31 17:34 UTC David Rowley <[email protected]> Re: Why does not subquery pruning conditions inherit to parent query? 2019-05-31 12:32 UTC David Rowley <[email protected]> Re: New committer: David Rowley 2019-05-31 12:14 UTC David Rowley <[email protected]> Re: Confusing error message for REINDEX TABLE CONCURRENTLY 2019-05-28 19:04 UTC David Rowley <[email protected]> Re: Cleaning up and speeding up string functions 2019-05-25 23:00 UTC David Rowley <[email protected]> Cleaning up and speeding up string functions 2019-05-25 07:53 UTC David Rowley <[email protected]> Re: Runtime pruning problem 2019-05-25 06:55 UTC David Rowley <[email protected]> Re: Performance issue in foreign-key-aware join estimation 2019-05-25 04:37 UTC David Rowley <[email protected]> Re: POC: converting Lists into arrays 2019-05-25 03:26 UTC David Rowley <[email protected]> Re: Confusing error message for REINDEX TABLE CONCURRENTLY 2019-05-25 02:42 UTC David Rowley <[email protected]> Re: Excessive memory usage in multi-statement queries w/ partitioning 2019-05-24 13:33 UTC David Rowley <[email protected]> Re: Converting NOT IN to anti-joins during planning 2019-05-24 11:46 UTC David Rowley <[email protected]> Re: Should we warn against using too many partitions? 2019-05-24 10:00 UTC David Rowley <[email protected]> Re: Why does not subquery pruning conditions inherit to parent query? 2019-05-24 08:09 UTC David Rowley <[email protected]> Re: Aggregate error message 2019-05-24 07:20 UTC David Rowley <[email protected]> Re: Should we warn against using too many partitions? 2019-05-24 04:37 UTC David Rowley <[email protected]> Re: Top-N sorts in EXPLAIN, row count estimates, and parallelism 2019-05-24 02:47 UTC David Rowley <[email protected]> No mention of no CIC support for partitioned index in docs 2019-05-23 23:14 UTC David Rowley <[email protected]> Re: Excessive memory usage in multi-statement queries w/ partitioning 2019-05-23 10:02 UTC David Rowley <[email protected]> Should we warn against using too many partitions? 2019-05-23 09:02 UTC David Rowley <[email protected]> Re: Excessive memory usage in multi-statement queries w/ partitioning 2019-05-23 08:47 UTC David Rowley <[email protected]> Re: PostgreSQL 12 Beta 1 press release draft 2019-05-23 05:45 UTC David Rowley <[email protected]> Re: PostgreSQL 12 Beta 1 press release draft 2019-05-22 06:47 UTC David Rowley <[email protected]> Re: PostgreSQL 12: Feature Highlights 2019-05-22 00:33 UTC David Rowley <[email protected]> Re: Compile using the Visual Studio 2019 2019-05-21 02:37 UTC David Rowley <[email protected]> Re: Parallel Append subplan order instability on aye-aye 2019-05-21 00:43 UTC David Rowley <[email protected]> Re: Caveats from reloption toast_tuple_target 2019-05-21 00:33 UTC David Rowley <[email protected]> Re: PG 12 draft release notes 2019-05-21 00:04 UTC David Rowley <[email protected]> Re: Statistical aggregate functions are not working with PARTIAL aggregation 2019-05-20 12:25 UTC David Rowley <[email protected]> Re: Statistical aggregate functions are not working with PARTIAL aggregation 2019-05-20 05:27 UTC David Rowley <[email protected]> Re: Why does ExecComputeStoredGenerated() form a heap tuple 2019-05-20 02:23 UTC David Rowley <[email protected]> Re: Statistical aggregate functions are not working with PARTIAL aggregation 2019-05-19 22:36 UTC David Rowley <[email protected]> Re: Statistical aggregate functions are not working with PARTIAL aggregation 2019-05-19 08:18 UTC David Rowley <[email protected]> Re: Statistical aggregate functions are not working with PARTIAL aggregation 2019-05-19 04:37 UTC David Rowley <[email protected]> Re: PostgreSQL 12: Feature Highlights 2019-05-18 14:26 UTC David Rowley <[email protected]> Re: PostgreSQL 12: Feature Highlights 2019-05-18 11:34 UTC David Rowley <[email protected]> Re: PostgreSQL 12: Feature Highlights 2019-05-18 01:38 UTC David Rowley <[email protected]> Re: Passing CopyMultiInsertInfo structure to CopyMultiInsertInfoNextFreeSlot() 2019-05-18 01:14 UTC David Rowley <[email protected]> Re: PostgreSQL 12: Feature Highlights 2019-05-15 02:59 UTC David Rowley <[email protected]> Re: Passing CopyMultiInsertInfo structure to CopyMultiInsertInfoNextFreeSlot() 2019-05-14 01:19 UTC David Rowley <[email protected]> Re: Passing CopyMultiInsertInfo structure to CopyMultiInsertInfoNextFreeSlot() 2019-05-13 13:46 UTC David Rowley <[email protected]> Re: PostgreSQL 12: Feature Highlights 2019-05-13 10:50 UTC David Rowley <[email protected]> Re: PostgreSQL 12: Feature Highlights 2019-05-13 02:19 UTC David Rowley <[email protected]> Re: PG 12 draft release notes 2019-05-13 01:37 UTC David Rowley <[email protected]> Re: PostgreSQL 12: Feature Highlights 2019-05-12 23:47 UTC David Rowley <[email protected]> Re: pg12 release notes 2019-05-10 05:51 UTC David Rowley <[email protected]> Re: pg12 release notes 2019-05-10 05:10 UTC David Rowley <[email protected]> Re: pg12 release notes 2019-05-10 03:57 UTC David Rowley <[email protected]> Re: pg12 release notes 2019-05-10 03:34 UTC David Rowley <[email protected]> Re: pg12 release notes 2019-05-10 03:18 UTC David Rowley <[email protected]> Re: using index or check in ALTER TABLE SET NOT NULL 2019-05-03 23:06 UTC David Rowley <[email protected]> Re: using index or check in ALTER TABLE SET NOT NULL 2019-05-02 02:22 UTC David Rowley <[email protected]> Re: using index or check in ALTER TABLE SET NOT NULL 2019-05-02 00:57 UTC David Rowley <[email protected]> Re: Caveats from reloption toast_tuple_target 2019-04-30 02:20 UTC David Rowley <[email protected]> Re: "long" type is not appropriate for counting tuples 2019-04-29 21:29 UTC David Rowley <[email protected]> Re: Speed up build on Windows by generating symbol definition in batch 2019-04-29 07:36 UTC David Rowley <[email protected]> Re: Optimizer items in the release notes 2019-04-27 02:47 UTC David Rowley <[email protected]> Re: Optimizer items in the release notes 2019-04-27 02:04 UTC David Rowley <[email protected]> Re: Optimizer items in the release notes 2019-04-24 12:43 UTC David Rowley <[email protected]> Re: pg_dump partitions can lead to inconsistent state after restore 2019-04-24 07:36 UTC David Rowley <[email protected]> Re: pg_dump partitions can lead to inconsistent state after restore 2019-04-24 01:19 UTC David Rowley <[email protected]> Re: Runtime pruning problem 2019-04-23 23:42 UTC David Rowley <[email protected]> Re: pg_dump is broken for partition tablespaces 2019-04-23 23:02 UTC David Rowley <[email protected]> Re: Why does ExecComputeStoredGenerated() form a heap tuple 2019-04-23 22:26 UTC David Rowley <[email protected]> Re: pg_dump is broken for partition tablespaces 2019-04-23 11:03 UTC David Rowley <[email protected]> Re: pg_dump is broken for partition tablespaces 2019-04-23 05:45 UTC David Rowley <[email protected]> Re: display of variables in EXPLAIN VERBOSE 2019-04-22 13:27 UTC David Rowley <[email protected]> Re: Runtime pruning problem 2019-04-22 13:12 UTC David Rowley <[email protected]> Re: Runtime pruning problem 2019-04-21 06:25 UTC David Rowley <[email protected]> Re: Runtime pruning problem 2019-04-17 03:58 UTC David Rowley <[email protected]> Re: Runtime pruning problem 2019-04-17 02:29 UTC David Rowley <[email protected]> Re: pg_dump is broken for partition tablespaces 2019-04-16 12:15 UTC David Rowley <[email protected]> Re: Runtime pruning problem 2019-04-16 12:09 UTC David Rowley <[email protected]> Re: Caveats from reloption toast_tuple_target 2019-04-16 11:30 UTC David Rowley <[email protected]> Re: partitioning performance tests after recent patches 2019-04-15 13:04 UTC David Rowley <[email protected]> Re: Issue in ExecCleanupTupleRouting() 2019-04-15 04:32 UTC David Rowley <[email protected]> Re: pg_dump is broken for partition tablespaces 2019-04-14 23:32 UTC David Rowley <[email protected]> Re: partitioning performance tests after recent patches 2019-04-14 23:25 UTC David Rowley <[email protected]> Re: pg_dump is broken for partition tablespaces 2019-04-14 14:25 UTC David Rowley <[email protected]> Re: pg_dump is broken for partition tablespaces 2019-04-14 11:21 UTC David Rowley <[email protected]> Re: Should we add GUCs to allow partition pruning to be disabled? 2019-04-12 02:01 UTC David Rowley <[email protected]> Re: Issue in ExecCleanupTupleRouting() 2019-04-11 13:28 UTC David Rowley <[email protected]> Re: speeding up planning with partitions 2019-04-11 05:03 UTC David Rowley <[email protected]> Re: Reducing the runtime of the core regression tests 2019-04-11 04:54 UTC David Rowley <[email protected]> Re: Should we add GUCs to allow partition pruning to be disabled? 2019-04-11 04:50 UTC David Rowley <[email protected]> Re: Proper usage of ndistinct vs. dependencies extended statistics 2019-04-11 04:26 UTC David Rowley <[email protected]> Re: Should we add GUCs to allow partition pruning to be disabled? 2019-04-11 03:34 UTC David Rowley <[email protected]> Re: Should the docs have a warning about pg_stat_reset()? 2019-04-11 01:49 UTC David Rowley <[email protected]> Re: Should the docs have a warning about pg_stat_reset()? 2019-04-11 01:43 UTC David Rowley <[email protected]> Re: Reducing the runtime of the core regression tests 2019-04-11 00:27 UTC David Rowley <[email protected]> 200+ results
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox