pgsql-performance  

Messages by Date

• 2025/02/10 Re: Poor performance with row wise comparisons Laurenz Albe
• 2025/02/09 Re: Poor performance with row wise comparisons Tom Lane
• 2025/02/09 Re: Poor performance with row wise comparisons Jon Emord
• 2025/02/08 Re: lwlock:LockManager wait_events kyle Hailey
• 2025/02/07 Re: Poor performance with row wise comparisons Greg Sabino Mullane
• 2025/02/06 Poor performance with row wise comparisons Jon Emord
• 2025/02/03 Re: Performance loss after upgrading from 12.15 to 17.2 Laurenz Albe
• 2025/02/03 Performance loss after upgrading from 12.15 to 17.2 Tobias Orlamünde
• 2025/01/31 Re: High System CPU Usage on Selects Seemingly Caused By Vacuum of Same Table Joshua Banton
• 2025/01/31 Re: High System CPU Usage on Selects Seemingly Caused By Vacuum of Same Table Peter Geoghegan
• 2025/01/31 High System CPU Usage on Selects Seemingly Caused By Vacuum of Same Table Joshua Banton
• 2025/01/29 Re: Why ORing with a false one-time filter turns an Index-Lookup into a SeqScan Tom Lane
• 2025/01/29 Re: Why ORing with a false one-time filter turns an Index-Lookup into a SeqScan Clemens Eisserer
• 2025/01/29 Re: Simple query with Planner underestimating rows. Andrei Lepikhov
• 2025/01/28 Re: Simple query with Planner underestimating rows. Andrei Lepikhov
• 2025/01/28 Re: Simple query with Planner underestimating rows. Greg Sabino Mullane
• 2025/01/28 Re: [EXTERNAL] - Re: Reg pg_restore taking more time in windows compare to linux Laurenz Albe
• 2025/01/28 Re: Why ORing with a false one-time filter turns an Index-Lookup into a SeqScan Wetmore, Matthew (CTR)
• 2025/01/28 Why ORing with a false one-time filter turns an Index-Lookup into a SeqScan Clemens Eisserer
• 2025/01/27 RE: [EXT] Re: Read-only connectios optimizatios Wong, Kam Fook (TR Technology)
• 2025/01/27 Re: [EXTERNAL] - Re: Reg pg_restore taking more time in windows compare to linux Laurenz Albe
• 2025/01/27 Re: Unexpected Seq Scan's when using MERGE WHEN NOT MATCHED BY SOURCE Feike Steenbergen
• 2025/01/27 Re: Reg pg_restore taking more time in windows compare to linux Laurenz Albe
• 2025/01/26 Re: Any risk or overhead considerations for frequently executing queries against catalog tables? Jeremy Schneider
• 2025/01/25 Re: Any risk or overhead considerations for frequently executing queries against catalog tables? Pavel Stehule
• 2025/01/25 Re: Any risk or overhead considerations for frequently executing queries against catalog tables? frits . hoogland
• 2025/01/25 Re: Read-only connectios optimizatios peter plachta
• 2025/01/25 Re: Any risk or overhead considerations for frequently executing queries against catalog tables? peter plachta
• 2025/01/25 Re: Any risk or overhead considerations for frequently executing queries against catalog tables? Frits Hoogland
• 2025/01/25 Re: Any risk or overhead considerations for frequently executing queries against catalog tables? Pavel Stehule
• 2025/01/25 Re: Read-only connectios optimizatios Laurenz Albe
• 2025/01/25 Re: Any risk or overhead considerations for frequently executing queries against catalog tables? Frits Hoogland
• 2025/01/25 Read-only connectios optimizatios Edson Richter
• 2025/01/25 Re: Any risk or overhead considerations for frequently executing queries against catalog tables? Pavel Stehule
• 2025/01/25 Any risk or overhead considerations for frequently executing queries against catalog tables? Frits Hoogland
• 2025/01/16 Re: Query planning read a large amount of buffers for partitioned tables bruno vieira da silva
• 2025/01/15 Re: Question: consolidating strpos searches? James Addison
• 2025/01/15 Re: Query planning read a large amount of buffers for partitioned tables David Rowley
• 2025/01/15 Re: Query planning read a large amount of buffers for partitioned tables bruno vieira da silva
• 2025/01/15 Query planning read a large amount of buffers for partitioned tables bruno vieira da silva
• 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

• Earlier messages