pgsql-performance  

Messages by Date

• 2025/01/09 Re: Unexpected Seq Scan's when using MERGE WHEN NOT MATCHED BY SOURCE Tom Lane
• 2025/01/09 Re: Unexpected Seq Scan's when using MERGE WHEN NOT MATCHED BY SOURCE David Mullineux
• 2025/01/09 Re: Unexpected Seq Scan's when using MERGE WHEN NOT MATCHED BY SOURCE Feike Steenbergen
• 2025/01/09 Unexpected Seq Scan's when using MERGE WHEN NOT MATCHED BY SOURCE Feike Steenbergen
• 2025/01/07 Re: Aggressive vacuum Jeff Janes
• 2025/01/06 Re: Aggressive vacuum Slava Mudry
• 2025/01/04 Re: Question: consolidating strpos searches? Greg Sabino Mullane
• 2025/01/04 Re: Question: consolidating strpos searches? Tom Lane
• 2025/01/04 Question: consolidating strpos searches? James Addison
• 2024/12/27 Re: Reg. Postgres Unique contraint shammat
• 2024/12/27 RE: Reg. Postgres Unique contraint msalais
• 2024/12/27 Re: CTE Inline On TPC-DS Query 95 David Rowley
• 2024/12/27 RE: CTE Inline On TPC-DS Query 95 msalais
• 2024/12/25 Re: huge shared_blocks_hit one select but manually run very fast David Mullineux
• 2024/12/21 Re: huge shared_blocks_hit one select but manually run very fast James Pang
• 2024/12/21 Re: huge shared_blocks_hit one select but manually run very fast David Mullineux
• 2024/12/21 huge shared_blocks_hit one select but manually run very fast James Pang
• 2024/12/20 Re: Why a bitmap scan in this case? Jon Zeppieri
• 2024/12/20 Re: Why a bitmap scan in this case? Frédéric Yhuel
• 2024/12/20 Re: Why a bitmap scan in this case? Frédéric Yhuel
• 2024/12/19 Re: Why a bitmap scan in this case? Jon Zeppieri
• 2024/12/19 Re: Why a bitmap scan in this case? Jon Zeppieri
• 2024/12/19 Re: Why a bitmap scan in this case? Greg Sabino Mullane
• 2024/12/19 Why a bitmap scan in this case? Jon Zeppieri
• 2024/12/19 Aggressive vacuum Graham Hay
• 2024/12/11 Re: PostgreSQL and a Catch-22 Issue related to dead rows Lars Aksel Opsahl
• 2024/12/10 Re: PostgreSQL and a Catch-22 Issue related to dead rows Lars Aksel Opsahl
• 2024/12/10 Re: PostgreSQL and a Catch-22 Issue related to dead rows Hannu Krosing
• 2024/12/10 Re: PostgreSQL and a Catch-22 Issue related to dead rows Greg Sabino Mullane
• 2024/12/10 Re: PostgreSQL and a Catch-22 Issue related to dead rows Lars Aksel Opsahl
• 2024/12/10 Re: PostgreSQL and a Catch-22 Issue related to dead rows Greg Sabino Mullane
• 2024/12/10 Re: can a blocked transaction affect the performance of one that is blocking it? David Mullineux
• 2024/12/10 Re: PostgreSQL and a Catch-22 Issue related to dead rows Lars Aksel Opsahl
• 2024/12/09 Re: PostgreSQL and a Catch-22 Issue related to dead rows Lars Aksel Opsahl
• 2024/12/09 Re: PostgreSQL and a Catch-22 Issue related to dead rows Lars Aksel Opsahl
• 2024/12/09 Re: can a blocked transaction affect the performance of one that is blocking it? Nikolay Samokhvalov
• 2024/12/09 can a blocked transaction affect the performance of one that is blocking it? Eric Schwarzenbach
• 2024/12/09 Re: PostgreSQL and a Catch-22 Issue related to dead rows Tom Lane
• 2024/12/09 Re: PostgreSQL and a Catch-22 Issue related to dead rows Christophe Pettus
• 2024/12/09 Re: PostgreSQL and a Catch-22 Issue related to dead rows Rick Otten
• 2024/12/09 Re: PostgreSQL and a Catch-22 Issue related to dead rows Lars Aksel Opsahl
• 2024/12/09 Re: PostgreSQL and a Catch-22 Issue related to dead rows Lars Aksel Opsahl
• 2024/12/09 Re: PostgreSQL and a Catch-22 Issue related to dead rows Greg Sabino Mullane
• 2024/12/09 Re: PostgreSQL and a Catch-22 Issue related to dead rows michael...@sqlexec.com
• 2024/12/09 PostgreSQL and a Catch-22 Issue related to dead rows Lars Aksel Opsahl
• 2024/11/29 Re: Performance of Query 60 on TPC-DS Benchmark Nikita Malakhov
• 2024/11/27 Re: Performance of Query 60 on TPC-DS Benchmark Nikita Malakhov
• 2024/11/26 Re: Reg. Postgres Unique contraint Vitalii Tymchyshyn
• 2024/11/26 Re: Reg. Postgres Unique contraint Burcin Yazici
• 2024/11/26 Re: Reg. Postgres Unique contraint Sajjad Abid
• 2024/11/26 Re: Reg. Postgres Unique contraint Diomedes Dominguez
• 2024/11/26 Reg. Postgres Unique contraint Sajjad Abid
• 2024/11/26 Re: Has gen_random_uuid() gotten much slower in v17? David Mullineux
• 2024/11/25 Re: CTE Inline On TPC-DS Query 95 David Rowley
• 2024/11/25 Re: Performance of TPC-DS Query 95 David Rowley
• 2024/11/25 Performance of TPC-DS Query 95 Ba Jinsheng
• 2024/11/25 CTE Inline On TPC-DS Query 95 Ba Jinsheng
• 2024/11/25 Re: Cardinality estimate of the inner relation Frédéric Yhuel
• 2024/11/24 Re: Performance of Query 60 on TPC-DS Benchmark Andrei Lepikhov
• 2024/11/22 Re: Cardinality estimate of the inner relation Andrei Lepikhov
• 2024/11/22 Re: could not send data to client: Connection reset by peer Tomas Vondra
• 2024/11/22 Cardinality estimate of the inner relation Frédéric Yhuel
• 2024/11/22 Re: Performance of Query 60 on TPC-DS Benchmark Andrei Lepikhov
• 2024/11/21 could not send data to client: Connection reset by peer James Pang
• 2024/11/20 Re: Has gen_random_uuid() gotten much slower in v17? Tom Lane
• 2024/11/20 Re: Has gen_random_uuid() gotten much slower in v17? David Mullineux
• 2024/11/20 Re: Has gen_random_uuid() gotten much slower in v17? Tom Lane
• 2024/11/20 Re: Has gen_random_uuid() gotten much slower in v17? Frédéric Yhuel
• 2024/11/13 Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4 Achilleas Mantzios - cloud
• 2024/11/12 Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4 Achilleas Mantzios - cloud
• 2024/11/12 Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4 Tomas Vondra
• 2024/11/12 Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4 Tom Lane
• 2024/11/12 Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4 Achilleas Mantzios
• 2024/11/12 Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4 Tomas Vondra
• 2024/11/12 Re: Performance of Query 4 on TPC-DS Benchmark Andrei Lepikhov
• 2024/11/11 Re: Performance of Query 4 on TPC-DS Benchmark Ba Jinsheng
• 2024/11/11 Re: Performance of Query 4 on TPC-DS Benchmark Ba Jinsheng
• 2024/11/11 Re: Performance of Query 4 on TPC-DS Benchmark Andrei Lepikhov
• 2024/11/10 Re: Performance of Query 4 on TPC-DS Benchmark Alena Rybakina
• 2024/11/10 Re: Performance of Query 4 on TPC-DS Benchmark Alena Rybakina
• 2024/11/10 Re: Performance of Query 4 on TPC-DS Benchmark Thomas Munro
• 2024/11/10 Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4 Achilleas Mantzios
• 2024/11/09 Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4 Tomas Vondra
• 2024/11/09 Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4 Achilleas Mantzios
• 2024/11/09 Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4 Achilleas Mantzios
• 2024/11/09 Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4 Tomas Vondra
• 2024/11/08 Re: Major performance degradation with joins in 15.8 or 15.7? Andrei Lepikhov
• 2024/11/08 tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4 Achilleas Mantzios
• 2024/11/08 Re: Major performance degradation with joins in 15.8 or 15.7? Ed Sabol
• 2024/11/07 Re: Major performance degradation with joins in 15.8 or 15.7? Ed Sabol
• 2024/11/07 Re: Major performance degradation with joins in 15.8 or 15.7? Andrei Lepikhov
• 2024/11/07 Re: Major performance degradation with joins in 15.8 or 15.7? Andrei Lepikhov
• 2024/11/07 Re: Major performance degradation with joins in 15.8 or 15.7? Ed Sabol
• 2024/11/07 Re: Major performance degradation with joins in 15.8 or 15.7? David Rowley
• 2024/11/07 Major performance degradation with joins in 15.8 or 15.7? Ed Sabol
• 2024/11/05 Re: Bloom filters and the planner / parallel execution Rafia Sabih
• 2024/11/04 Re: Performance of Query 2 in TPC-H Andrei Lepikhov
• 2024/11/04 Re: Postgresql 14/15/16/17 partition pruning on dependent table during join Andrei Lepikhov
• 2024/11/04 Performance of Query 2 in TPC-H Ba Jinsheng
• 2024/11/04 Re: Postgresql 14/15/16/17 partition pruning on dependent table during join Stepan Yankevych
• 2024/11/02 Re: Postgresql 14/15/16/17 partition pruning on dependent table during join Andrei Lepikhov
• 2024/11/02 Re: Postgresql 14/15/16/17 partition pruning on dependent table during join Vijaykumar Jain
• 2024/11/01 Postgresql 14/15/16/17 partition pruning on dependent table during join Stepan Yankevych
• 2024/10/26 Re: Unexpected Performance for the Function simplify_function Ba Jinsheng
• 2024/10/25 Re: Unexpected Performance for the Function simplify_function Tom Lane
• 2024/10/25 Re: lwlock:LockManager wait_events SAMEER KUMAR
• 2024/10/25 Re: Unexpected Performance for the Function simplify_function Shiv Iyer
• 2024/10/25 Re: Unexpected Performance for the Function simplify_function David Rowley
• 2024/10/25 Re: Unexpected Performance for the Function simplify_function Andrei Lepikhov
• 2024/10/25 Re: Unexpected Performance for the Function simplify_function Ba Jinsheng
• 2024/10/25 Re: Unexpected Performance for the Function simplify_function Ba Jinsheng
• 2024/10/25 Re: lwlock:LockManager wait_events Sean Massey
• 2024/10/25 Unexpected Performance for the Function simplify_function Ba Jinsheng
• 2024/10/25 Re: proposal: schema variables James Pang
• 2024/10/25 Re: proposal: schema variables James Pang
• 2024/10/25 Re: lwlock:LockManager wait_events Laurenz Albe
• 2024/10/24 lwlock:LockManager wait_events James Pang
• 2024/10/24 Re: Unexpected Performance for the Function simplify_function David G. Johnston
• 2024/10/24 Re: Unexpected Performance for the Function simplify_function Andrei Lepikhov
• 2024/10/24 Re: Unexpected Performance for the Function simplify_function Tom Lane
• 2024/10/24 Re: Unexpected Performance for the Function simplify_function Tom Lane
• 2024/10/24 Re: Unexpected Performance for the Function simplify_function Greg Sabino Mullane
• 2024/10/24 Adding exclusion constraint in a big table Marcelo Fernandes
• 2024/10/09 Re: Performance degradation in Index searches with special characters Andrey Stikheev
• 2024/10/08 Bloom filters and the planner / parallel execution Daniel Westermann (DWE)
• 2024/10/07 Re: Performance degradation in Index searches with special characters Joe Conway
• 2024/10/06 Re: Performance degradation in Index searches with special characters Thomas Munro
• 2024/10/06 Re: Performance degradation in Index searches with special characters Shiv Iyer
• 2024/10/06 Re: Performance degradation in Index searches with special characters Tom Lane
• 2024/10/06 Re: Performance degradation in Index searches with special characters Joe Conway
• 2024/10/06 Re: Performance degradation in Index searches with special characters Andrey Stikheev
• 2024/10/06 Re: Performance degradation in Index searches with special characters Tom Lane
• 2024/10/06 Performance degradation in Index searches with special characters Andrey Stikheev
• 2024/09/11 Re: Partition pruning with array-contains check and current_setting function Marcelo Zabani
• 2024/09/11 Re: Has gen_random_uuid() gotten much slower in v17? David Mullineux
• 2024/09/11 Re: Has gen_random_uuid() gotten much slower in v17? Peter Eisentraut
• 2024/09/11 Re: many backends hang on MultiXactOffsetSLRU James Pang
• 2024/09/10 Re: many backends hang on MultiXactOffsetSLRU Alvaro Herrera
• 2024/09/10 Re: many backends hang on MultiXactOffsetSLRU Amine Tengilimoglu
• 2024/09/10 Re: many backends hang on MultiXactOffsetSLRU James Pang
• 2024/09/10 Re: many backends hang on MultiXactOffsetSLRU Alvaro Herrera
• 2024/09/10 Re: many backends hang on MultiXactOffsetSLRU Alvaro Herrera
• 2024/09/10 Re: many backends hang on MultiXactOffsetSLRU Amine Tengilimoglu
• 2024/09/10 many backends hang on MultiXactOffsetSLRU James Pang
• 2024/09/08 Re: Estimate of the inner_rows Tom Lane
• 2024/09/08 Re: Estimate of the inner_rows Tom Lane
• 2024/09/08 Estimate of the inner_rows 陈雁飞
• 2024/08/24 Re: checking for a NULL date in a partitioned table kills performance Rui DeSousa
• 2024/08/22 Re: checking for a NULL date in a partitioned table kills performance Tom Lane
• 2024/08/22 Re: checking for a NULL date in a partitioned table kills performance (accidentally sent to the admin list before) Vitalii Tymchyshyn
• 2024/08/22 checking for a NULL date in a partitioned table kills performance (accidentally sent to the admin list before) Sbob
• 2024/08/19 Re: Trying to understand why a query is filtering when there is a composite index Stephen Samuel (Sam)
• 2024/08/19 Re: Trying to understand why a query is filtering when there is a composite index Tom Lane
• 2024/08/19 Re: Trying to understand why a query is filtering when there is a composite index Stephen Samuel (Sam)
• 2024/08/19 Re: Trying to understand why a query is filtering when there is a composite index Peter Geoghegan
• 2024/08/19 Re: Trying to understand why a query is filtering when there is a composite index Shiv Iyer
• 2024/08/18 Re: Trying to understand why a query is filtering when there is a composite index Stephen Samuel (Sam)
• 2024/08/18 Re: Trying to understand why a query is filtering when there is a composite index Tom Lane
• 2024/08/18 Re: Trying to understand why a query is filtering when there is a composite index Peter Geoghegan
• 2024/08/18 Re: Trying to understand why a query is filtering when there is a composite index Tom Lane
• 2024/08/18 Re: Trying to understand why a query is filtering when there is a composite index Stephen Samuel (Sam)
• 2024/08/18 Re: Trying to understand why a query is filtering when there is a composite index Peter Geoghegan
• 2024/08/18 Re: Trying to understand why a query is filtering when there is a composite index Stephen Samuel (Sam)
• 2024/08/18 Re: Trying to understand why a query is filtering when there is a composite index Peter Geoghegan
• 2024/08/18 Trying to understand why a query is filtering when there is a composite index Stephen Samuel (Sam)
• 2024/08/07 Partition pruning with array-contains check and current_setting function Marcelo Zabani
• 2024/08/07 Re: Postgres index usage Greg Sabino Mullane
• 2024/08/07 Re: Postgres index usage Tom Lane
• 2024/08/07 RE: Postgres index usage Dirschel, Steve
• 2024/08/07 Postgres index usage Dirschel, Steve
• 2024/07/31 Re: logical replication out of memory khan Affan
• 2024/07/30 Re: logical replication out of memory James Pang
• 2024/07/30 Re: logical replication out of memory khan Affan
• 2024/07/30 Re: logical replication out of memory James Pang
• 2024/07/30 logical replication out of memory James Pang
• 2024/07/30 Re: Help with row estimate problem Jon Zeppieri
• 2024/07/30 Re: Help with row estimate problem Andrei Lepikhov
• 2024/07/29 Help with row estimate problem Jon Zeppieri
• 2024/07/26 Re: Outer cost higher than the inner cost Tom Lane
• 2024/07/26 Outer cost higher than the inner cost Stanisław Skonieczny
• 2024/07/11 Re: inequality predicate not pushed down in JOIN? Jerry Brenner
• 2024/07/11 Re: inequality predicate not pushed down in JOIN? Paul George
• 2024/07/11 Re: inequality predicate not pushed down in JOIN? Andrei Lepikhov
• 2024/07/11 inequality predicate not pushed down in JOIN? Paul George
• 2024/07/11 Re: How to solve my slow disk i/o throughput during index scan Andrei Lepikhov
• 2024/07/11 Re: How to solve my slow disk i/o throughput during index scan Andrei Lepikhov
• 2024/07/11 Re: How to solve my slow disk i/o throughput during index scan David G. Johnston
• 2024/07/11 RE: How to solve my slow disk i/o throughput during index scan FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT)
• 2024/07/11 RE: How to solve my slow disk i/o throughput during index scan FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT)
• 2024/07/10 Re: Specific objects backup in PostgreSQL nikhil kumar
• 2024/07/10 Re: Specific objects backup in PostgreSQL Anthony Sotolongo
• 2024/07/10 Re: Specific objects backup in PostgreSQL Olivier Gautherot
• 2024/07/10 Re: Specific objects backup in PostgreSQL David G. Johnston
• 2024/07/10 Specific objects backup in PostgreSQL nikhil kumar
• 2024/07/10 Re: Query performance issue Tom Lane
• 2024/07/10 Query performance issue Dheeraj Sonawane
• 2024/07/08 Re: Low performance between datacenters Andrei Lepikhov
• 2024/07/07 Re: Hash Right join and seq scan Justin Pryzby
• 2024/07/07 Re: Hash Right join and seq scan James Pang
• 2024/07/07 Re: Low performance between datacenters Vitalii Tymchyshyn

• Earlier messages