pgsql-performance  

Messages by Date

• 2025/04/11 Re: many sessions wait on LWlock WALWrite suddenly MichaelDBA
• 2025/04/11 Re: many sessions wait on LWlock WALWrite suddenly Laurenz Albe
• 2025/04/11 many sessions wait on LWlock WALWrite suddenly James Pang
• 2025/04/09 Re: parallel pg_restore blocks on heavy random read I/O on all children processes Hannu Krosing
• 2025/04/09 Question on what Duration in the log Vitale, Anthony, Sony Music
• 2025/04/09 RE: Question on what Duration in the log Vitale, Anthony, Sony Music
• 2025/04/09 Re: Question on what Duration in the log Tom Lane
• 2025/04/07 Re: Memory Not Released After Batch Completion – Checkpointer/Background Writer Behavior , postgres 15 Евгений Чекан
• 2025/04/06 Re: Memory Not Released After Batch Completion – Checkpointer/Background Writer Behavior , postgres 15 Motog Plus
• 2025/04/06 Memory Not Released After Batch Completion – Checkpointer/Background Writer Behavior , postgres 15 Motog Plus
• 2025/04/04 Re: parallel pg_restore blocks on heavy random read I/O on all children processes Tom Lane
• 2025/04/04 Fwd: Very slow query performance when using CTE Chris Joysn
• 2025/04/03 Re: Very slow query performance when using CTE Chris Joysn
• 2025/04/03 Re: partition table optimizer join cost misestimation James Pang
• 2025/04/03 Re: Very slow query performance when using CTE Michael Christofides
• 2025/04/02 Re: partition table optimizer join cost misestimation Andrei Lepikhov
• 2025/04/02 Re: partition table optimizer join cost misestimation James Pang
• 2025/04/02 Re: partition table optimizer join cost misestimation Andrei Lepikhov
• 2025/04/02 partition table optimizer join cost misestimation James Pang
• 2025/04/01 Re: Very slow query performance when using CTE Renan Alves Fonseca
• 2025/04/01 Re: Very slow query performance when using CTE Tom Lane
• 2025/04/01 Very slow query performance when using CTE Chris Joysn
• 2025/03/28 Re: parallel pg_restore blocks on heavy random read I/O on all children processes Dimitrios Apostolou
• 2025/03/27 Re: parallel pg_restore blocks on heavy random read I/O on all children processes Dimitrios Apostolou
• 2025/03/24 Re: parallel pg_restore blocks on heavy random read I/O on all children processes Dimitrios Apostolou
• 2025/03/23 Re: parallel pg_restore blocks on heavy random read I/O on all children processes Dimitrios Apostolou
• 2025/03/20 Re: parallel pg_restore blocks on heavy random read I/O on all children processes Tom Lane
• 2025/03/20 parallel pg_restore blocks on heavy random read I/O on all children processes Dimitrios Apostolou
• 2025/03/19 Re: PostgreSQL 16 - Detach partition with FK - Error Álvaro Herrera
• 2025/03/19 PostgreSQL 16 - Detach partition with FK - Error Adithya Kumaranchath
• 2025/03/18 Re: Bad perf when using DECLARE CURSOR on big table kimaidou
• 2025/03/17 Background writer not active Motog Plus
• 2025/03/17 Re: Efficient pagination using multi-column cursors large . goose2829
• 2025/03/17 Re: Bulk DML performance Renan Alves Fonseca
• 2025/03/17 Re: Bad perf when using DECLARE CURSOR on big table Tom Lane
• 2025/03/17 Bad perf when using DECLARE CURSOR on big table kimaidou
• 2025/03/17 Re: Bulk DML performance Greg Sabino Mullane
• 2025/03/17 Re: Bulk DML performance Álvaro Herrera
• 2025/03/17 RE: Bulk DML performance bill.poole
• 2025/03/17 RE: Bulk DML performance bill.poole
• 2025/03/17 RE: Bulk DML performance bill.poole
• 2025/03/13 Re: Bulk DML performance Renan Alves Fonseca
• 2025/03/13 Re: Bulk DML performance Laurenz Albe
• 2025/03/13 Re: Bulk DML performance Laurenz Albe
• 2025/03/13 Re: Bulk DML performance Laurenz Albe
• 2025/03/13 Bulk DML performance bill.poole
• 2025/03/05 Asking for OK for a nasty trick to resolve PG CVE-2025-1094 i Abraham, Danny
• 2025/03/03 Slow performance of collate "en_US.utf8" Alexey Borschev
• 2025/02/28 Re: Slow performance of collate "en_US.utf8" Joe Conway
• 2025/02/28 Re: [PERFORM] Unused index influencing sequential scan plan Thom Brown
• 2025/02/28 Re: Slow performance of collate "en_US.utf8" Thomas Munro
• 2025/02/28 Re: Slow performance of collate "en_US.utf8" Joe Conway
• 2025/02/28 Re: Slow performance of collate "en_US.utf8" Laurenz Albe
• 2025/02/28 Re: Slow performance of collate "en_US.utf8" Achilleas Mantzios - cloud
• 2025/02/26 Re: Efficient pagination using multi-column cursors Laurenz Albe
• 2025/02/26 Re: Efficient pagination using multi-column cursors Peter Geoghegan
• 2025/02/26 Re: Efficient pagination using multi-column cursors large . goose2829
• 2025/02/26 Re: Efficient pagination using multi-column cursors Peter Geoghegan
• 2025/02/26 Efficient pagination using multi-column cursors large . goose2829
• 2025/02/24 Re: Unfortunate Nested Loop + Missing Autovacuum Lincoln Swaine-Moore
• 2025/02/24 Re: Unfortunate Nested Loop + Missing Autovacuum Andrei Lepikhov
• 2025/02/23 Re: Unfortunate Nested Loop + Missing Autovacuum Jeff Janes
• 2025/02/23 Re: Unfortunate Nested Loop + Missing Autovacuum Lincoln Swaine-Moore
• 2025/02/22 Re: Unfortunate Nested Loop + Missing Autovacuum Andrei Lepikhov
• 2025/02/21 Unfortunate Nested Loop + Missing Autovacuum Lincoln Swaine-Moore
• 2025/02/18 Re: Query planning read a large amount of buffers for partitioned tables bruno vieira da silva
• 2025/02/18 Re: Query planning read a large amount of buffers for partitioned tables David Rowley
• 2025/02/17 Re: Query planning read a large amount of buffers for partitioned tables bruno vieira da silva
• 2025/02/17 Re: Query planning read a large amount of buffers for partitioned tables bruno vieira da silva
• 2025/02/17 Re: Query planning read a large amount of buffers for partitioned tables bruno vieira da silva
• 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

• Earlier messages