public inbox for [email protected]  
help / color / mirror / Atom feed
Re: Bloom filters and the planner / parallel execution
  2024-11-05 13:22 UTC  Rafia Sabih <[email protected]>

Performance of Query 2 in TPC-H
  2024-11-04 08:42 UTC  Ba Jinsheng <[email protected]>
` Re: Performance of Query 2 in TPC-H
  2024-11-05 02:22 UTC  Andrei Lepikhov <[email protected]>
  [2+ messages in thread]

Postgresql 14/15/16/17 partition pruning on dependent table during join
  2024-11-01 13:21 UTC  Stepan Yankevych <[email protected]>
` Re: Postgresql 14/15/16/17 partition pruning on dependent table during join
  2024-11-02 20:21 UTC  Vijaykumar Jain <[email protected]>
` Re: Postgresql 14/15/16/17 partition pruning on dependent table during join
  2024-11-03 02:42 UTC  Andrei Lepikhov <[email protected]>
` Re: Postgresql 14/15/16/17 partition pruning on dependent table during join
  2024-11-04 08:23 UTC  Stepan Yankevych <[email protected]>
` Re: Postgresql 14/15/16/17 partition pruning on dependent table during join
  2024-11-04 12:05 UTC  Andrei Lepikhov <[email protected]>
  [5+ messages in thread]

Unexpected Performance for the Function simplify_function
  2024-10-24 19:43 UTC  Ba Jinsheng <[email protected]>
` Re: Unexpected Performance for the Function simplify_function
  2024-10-24 19:48 UTC  Shiv Iyer <[email protected]>
` Re: Unexpected Performance for the Function simplify_function
  2024-10-24 20:49 UTC  Tom Lane <[email protected]>
` Re: Unexpected Performance for the Function simplify_function
  2024-10-24 20:51 UTC  Tom Lane <[email protected]>
` Re: Unexpected Performance for the Function simplify_function
  2024-10-24 21:05 UTC  David G. Johnston <[email protected]>
` Re: Unexpected Performance for the Function simplify_function
  2024-10-24 23:09 UTC  Greg Sabino Mullane <[email protected]>
` Re: Unexpected Performance for the Function simplify_function
  2024-10-25 02:13 UTC  Andrei Lepikhov <[email protected]>
` Re: Unexpected Performance for the Function simplify_function
  2024-10-25 09:26 UTC  Ba Jinsheng <[email protected]>
` Re: Unexpected Performance for the Function simplify_function
  2024-10-25 09:29 UTC  Ba Jinsheng <[email protected]>
` Re: Unexpected Performance for the Function simplify_function
  2024-10-25 09:38 UTC  Andrei Lepikhov <[email protected]>
` Re: Unexpected Performance for the Function simplify_function
  2024-10-25 10:20 UTC  David Rowley <[email protected]>
` Re: Unexpected Performance for the Function simplify_function
  2024-10-26 06:28 UTC  Tom Lane <[email protected]>
` Re: Unexpected Performance for the Function simplify_function
  2024-10-26 07:31 UTC  Ba Jinsheng <[email protected]>
  [13+ messages in thread]

lwlock:LockManager wait_events
  2024-10-25 06:36 UTC  James Pang <[email protected]>
` Re: lwlock:LockManager wait_events
  2024-10-25 07:36 UTC  Laurenz Albe <[email protected]>
` Re: lwlock:LockManager wait_events
  2024-10-25 08:37 UTC  Sean Massey <[email protected]>
` Re: lwlock:LockManager wait_events
  2024-10-25 12:09 UTC  SAMEER KUMAR <[email protected]>
  [4+ messages in thread]

Adding exclusion constraint in a big table
  2024-10-24 06:43 UTC  Marcelo Fernandes <[email protected]>

Bloom filters and the planner / parallel execution
  2024-10-08 11:56 UTC  Daniel Westermann (DWE) <[email protected]>

Performance degradation in Index searches with special characters
  2024-10-05 09:23 UTC  Andrey Stikheev <[email protected]>
` Re: Performance degradation in Index searches with special characters
  2024-10-06 16:39 UTC  Tom Lane <[email protected]>
` Re: Performance degradation in Index searches with special characters
  2024-10-06 17:28 UTC  Andrey Stikheev <[email protected]>
` Re: Performance degradation in Index searches with special characters
  2024-10-06 17:45 UTC  Joe Conway <[email protected]>
` Re: Performance degradation in Index searches with special characters
  2024-10-06 18:13 UTC  Tom Lane <[email protected]>
` Re: Performance degradation in Index searches with special characters
  2024-10-06 20:02 UTC  Shiv Iyer <[email protected]>
` Re: Performance degradation in Index searches with special characters
  2024-10-06 20:24 UTC  Thomas Munro <[email protected]>
` Re: Performance degradation in Index searches with special characters
  2024-10-07 16:48 UTC  Joe Conway <[email protected]>
` Re: Performance degradation in Index searches with special characters
  2024-10-07 17:16 UTC  Andrey Stikheev <[email protected]>
  [9+ messages in thread]

Re: Partition pruning with array-contains check and current_setting function
  2024-09-11 19:11 UTC  Marcelo Zabani <[email protected]>

Has gen_random_uuid() gotten much slower in v17?
  2024-09-10 13:58 UTC  David Mullineux <[email protected]>
` Re: Has gen_random_uuid() gotten much slower in v17?
  2024-09-11 09:40 UTC  Peter Eisentraut <[email protected]>
` Re: Has gen_random_uuid() gotten much slower in v17?
  2024-09-11 10:47 UTC  David Mullineux <[email protected]>
  [3+ messages in thread]

many backends hang on MultiXactOffsetSLRU
  2024-09-10 07:33 UTC  James Pang <[email protected]>
` Re: many backends hang on MultiXactOffsetSLRU
  2024-09-10 08:12 UTC  Amine Tengilimoglu <[email protected]>
` Re: many backends hang on MultiXactOffsetSLRU
  2024-09-10 08:13 UTC  Alvaro Herrera <[email protected]>
` Re: many backends hang on MultiXactOffsetSLRU
  2024-09-10 08:15 UTC  Alvaro Herrera <[email protected]>
` Re: many backends hang on MultiXactOffsetSLRU
  2024-09-10 08:34 UTC  James Pang <[email protected]>
` Re: many backends hang on MultiXactOffsetSLRU
  2024-09-10 08:53 UTC  Amine Tengilimoglu <[email protected]>
` Re: many backends hang on MultiXactOffsetSLRU
  2024-09-10 09:00 UTC  Alvaro Herrera <[email protected]>
` Re: many backends hang on MultiXactOffsetSLRU
  2024-09-11 07:00 UTC  James Pang <[email protected]>
  [8+ messages in thread]

Estimate of the inner_rows
  2024-09-08 08:21 UTC  =?GBK?B?s8LR47fJ?= <[email protected]>
` Re: Estimate of the inner_rows
  2024-09-08 16:50 UTC  Tom Lane <[email protected]>
` Re: Estimate of the inner_rows
  2024-09-09 03:30 UTC  Tom Lane <[email protected]>
  [3+ messages in thread]

checking for a NULL date in a partitioned table kills performance
  2024-08-22 21:44 UTC  Sbob <[email protected]>
` Re: checking for a NULL date in a partitioned table kills performance
  2024-08-22 23:06 UTC  Rui DeSousa <[email protected]>
` Re: checking for a NULL date in a partitioned table kills performance
  2024-08-22 23:26 UTC  Sbob <[email protected]>
` Re: checking for a NULL date in a partitioned table kills performance
  2024-08-22 23:32 UTC  Sbob <[email protected]>
` Re: checking for a NULL date in a partitioned table kills performance
  2024-08-23 00:01 UTC  David G. Johnston <[email protected]>
` Re: checking for a NULL date in a partitioned table kills performance
  2024-08-23 00:05 UTC  Tom Lane <[email protected]>
` Re: checking for a NULL date in a partitioned table kills performance
  2024-08-23 00:07 UTC  Rui DeSousa <[email protected]>
` Re: checking for a NULL date in a partitioned table kills performance
  2024-08-23 04:40 UTC  Muhammad Usman Khan <[email protected]>
` Re: checking for a NULL date in a partitioned table kills performance
  2024-08-23 06:45 UTC  [email protected]
` Re: checking for a NULL date in a partitioned table kills performance
  2024-08-23 09:54 UTC  Rui DeSousa <[email protected]>
` Re: checking for a NULL date in a partitioned table kills performance
  2024-08-23 11:39 UTC  Doug Reynolds <[email protected]>
` Re: checking for a NULL date in a partitioned table kills performance
  2024-08-23 13:47 UTC  Sbob <[email protected]>
` Re: checking for a NULL date in a partitioned table kills performance
  2024-08-23 15:17 UTC  Scott Ribe <[email protected]>
` Re: checking for a NULL date in a partitioned table kills performance
  2024-08-23 15:42 UTC  Doug Reynolds <[email protected]>
` Re: checking for a NULL date in a partitioned table kills performance
  2024-08-23 15:49 UTC  Wetmore, Matthew  (CTR) <[email protected]>
` Re: checking for a NULL date in a partitioned table kills performance
  2024-08-23 16:08 UTC  Scott Ribe <[email protected]>
  [16+ messages in thread]

checking for a NULL date in a partitioned table kills performance (accidentally sent to the admin list before)
  2024-08-22 21:47 UTC  Sbob <[email protected]>
` Re: checking for a NULL date in a partitioned table kills performance (accidentally sent to the admin list before)
  2024-08-22 23:54 UTC  Vitalii Tymchyshyn <[email protected]>
  [2+ messages in thread]

Trying to understand why a query is filtering when there is a composite index
  2024-08-19 01:55 UTC  Stephen Samuel (Sam) <[email protected]>
` Re: Trying to understand why a query is filtering when there is a composite index
  2024-08-19 01:59 UTC  Peter Geoghegan <[email protected]>
` Re: Trying to understand why a query is filtering when there is a composite index
  2024-08-19 02:01 UTC  Stephen Samuel (Sam) <[email protected]>
` Re: Trying to understand why a query is filtering when there is a composite index
  2024-08-19 02:08 UTC  Peter Geoghegan <[email protected]>
` Re: Trying to understand why a query is filtering when there is a composite index
  2024-08-19 02:09 UTC  Stephen Samuel (Sam) <[email protected]>
` Re: Trying to understand why a query is filtering when there is a composite index
  2024-08-19 02:50 UTC  Tom Lane <[email protected]>
` Re: Trying to understand why a query is filtering when there is a composite index
  2024-08-19 03:11 UTC  Peter Geoghegan <[email protected]>
` Re: Trying to understand why a query is filtering when there is a composite index
  2024-08-19 04:06 UTC  Tom Lane <[email protected]>
` Re: Trying to understand why a query is filtering when there is a composite index
  2024-08-19 04:16 UTC  Stephen Samuel (Sam) <[email protected]>
` Re: Trying to understand why a query is filtering when there is a composite index
  2024-08-19 08:05 UTC  Shiv Iyer <[email protected]>
` Re: Trying to understand why a query is filtering when there is a composite index
  2024-08-19 15:21 UTC  Peter Geoghegan <[email protected]>
` Re: Trying to understand why a query is filtering when there is a composite index
  2024-08-19 23:44 UTC  Stephen Samuel (Sam) <[email protected]>
` Re: Trying to understand why a query is filtering when there is a composite index
  2024-08-19 23:55 UTC  Tom Lane <[email protected]>
` Re: Trying to understand why a query is filtering when there is a composite index
  2024-08-20 00:00 UTC  Stephen Samuel (Sam) <[email protected]>
  [14+ messages in thread]

Partition pruning with array-contains check and current_setting function
  2024-08-07 21:10 UTC  Marcelo Zabani <[email protected]>

Postgres index usage
  2024-08-07 17:06 UTC  Dirschel, Steve <[email protected]>
` RE: Postgres index usage
  2024-08-07 17:23 UTC  Dirschel, Steve <[email protected]>
` Re: Postgres index usage
  2024-08-07 17:36 UTC  Tom Lane <[email protected]>
` Re: Postgres index usage
  2024-08-07 18:18 UTC  Greg Sabino Mullane <[email protected]>
  [4+ messages in thread]

logical replication out of memory
  2024-07-31 02:17 UTC  James Pang <[email protected]>
` Re: logical replication out of memory
  2024-07-31 02:30 UTC  James Pang <[email protected]>
` Re: logical replication out of memory
  2024-07-31 05:41 UTC  khan Affan <[email protected]>
` Re: logical replication out of memory
  2024-07-31 06:48 UTC  James Pang <[email protected]>
` Re: logical replication out of memory
  2024-07-31 07:06 UTC  khan Affan <[email protected]>
  [5+ messages in thread]

Help with row estimate problem
  2024-07-29 20:51 UTC  Jon Zeppieri <[email protected]>
` Re: Help with row estimate problem
  2024-07-30 15:34 UTC  Andrei Lepikhov <[email protected]>
` Re: Help with row estimate problem
  2024-07-30 17:22 UTC  Jon Zeppieri <[email protected]>
  [3+ messages in thread]

Outer cost higher than the inner cost
  2024-07-26 13:25 UTC  Stanisław Skonieczny <[email protected]>
` Re: Outer cost higher than the inner cost
  2024-07-26 14:30 UTC  Tom Lane <[email protected]>
  [2+ messages in thread]

inequality predicate not pushed down in JOIN?
  2024-07-11 23:31 UTC  Paul George <[email protected]>
` Re: inequality predicate not pushed down in JOIN?
  2024-07-11 23:49 UTC  Andrei Lepikhov <[email protected]>
` Re: inequality predicate not pushed down in JOIN?
  2024-07-12 00:07 UTC  Paul George <[email protected]>
` Re: inequality predicate not pushed down in JOIN?
  2024-07-12 00:58 UTC  Jerry Brenner <[email protected]>
  [4+ messages in thread]

How to solve my slow disk i/o throughput during index scan
  2024-07-04 13:25 UTC  FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT) <[email protected]>
` Re: How to solve my slow disk i/o throughput during index scan
  2024-07-04 14:36 UTC  Andrei Lepikhov <[email protected]>
` RE: How to solve my slow disk i/o throughput during index scan
  2024-07-04 15:23 UTC  FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT) <[email protected]>
` Re: How to solve my slow disk i/o throughput during index scan
  2024-07-05 02:04 UTC  Andrei Lepikhov <[email protected]>
` RE: How to solve my slow disk i/o throughput during index scan
  2024-07-11 14:59 UTC  FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT) <[email protected]>
` RE: How to solve my slow disk i/o throughput during index scan
  2024-07-11 15:09 UTC  FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT) <[email protected]>
` Re: How to solve my slow disk i/o throughput during index scan
  2024-07-11 15:19 UTC  David G. Johnston <[email protected]>
` Re: How to solve my slow disk i/o throughput during index scan
  2024-07-11 15:22 UTC  Andrei Lepikhov <[email protected]>
` Re: How to solve my slow disk i/o throughput during index scan
  2024-07-11 15:34 UTC  Andrei Lepikhov <[email protected]>
  [9+ messages in thread]

Specific objects backup in PostgreSQL
  2024-07-10 18:05 UTC  nikhil kumar <[email protected]>
` Re: Specific objects backup in PostgreSQL
  2024-07-10 18:41 UTC  David G. Johnston <[email protected]>
` Re: Specific objects backup in PostgreSQL
  2024-07-10 18:42 UTC  Olivier Gautherot <[email protected]>
` Re: Specific objects backup in PostgreSQL
  2024-07-10 20:04 UTC  Anthony Sotolongo <[email protected]>
` Re: Specific objects backup in PostgreSQL
  2024-07-11 03:29 UTC  nikhil kumar <[email protected]>
  [5+ messages in thread]

Query performance issue
  2024-07-10 07:11 UTC  Dheeraj Sonawane <[email protected]>
` Re: Query performance issue
  2024-07-10 13:40 UTC  Tom Lane <[email protected]>
  [2+ messages in thread]

Low performance between datacenters
  2024-07-07 18:17 UTC  Tamás PAPP <[email protected]>
` Re: Low performance between datacenters
  2024-07-07 20:23 UTC  Fernando Hevia <[email protected]>
` Re: Low performance between datacenters
  2024-07-08 00:42 UTC  Vitalii Tymchyshyn <[email protected]>
` Re: Low performance between datacenters
  2024-07-08 07:24 UTC  Andrei Lepikhov <[email protected]>
  [4+ messages in thread]


[next (older)]

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox