agora inbox for pgsql-performance@postgresql.org
help / color / mirror / Atom feedBackground writer not active
2025-03-18 04:04 UTC Motog Plus <mplus7535@gmail.com>
Efficient pagination using multi-column cursors
2025-02-26 14:27 UTC large.goose2829@salomvary.com
` Re: Efficient pagination using multi-column cursors
2025-02-26 15:05 UTC Peter Geoghegan <pg@bowt.ie>
` Re: Efficient pagination using multi-column cursors
2025-02-26 15:40 UTC large.goose2829@salomvary.com
` Re: Efficient pagination using multi-column cursors
2025-02-26 16:14 UTC Peter Geoghegan <pg@bowt.ie>
` Re: Efficient pagination using multi-column cursors
2025-02-26 16:15 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Efficient pagination using multi-column cursors
2025-03-17 19:52 UTC large.goose2829@salomvary.com
[6+ messages in thread]
Bulk DML performance
2025-03-13 04:05 UTC bill.poole@ymail.com
` Re: Bulk DML performance
2025-03-13 09:21 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` RE: Bulk DML performance
2025-03-13 10:13 UTC bill.poole@ymail.com
` Re: Bulk DML performance
2025-03-13 11:28 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Bulk DML performance
2025-03-13 11:29 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` RE: Bulk DML performance
2025-03-13 13:04 UTC bill.poole@ymail.com
` Re: Bulk DML performance
2025-03-13 21:25 UTC Renan Alves Fonseca <renanfonseca@gmail.com>
` RE: Bulk DML performance
2025-03-14 01:20 UTC bill.poole@ymail.com
` Re: Bulk DML performance
2025-03-17 10:53 UTC Álvaro Herrera <alvherre@alvh.no-ip.org>
` Re: Bulk DML performance
2025-03-17 14:14 UTC Greg Sabino Mullane <htamfids@gmail.com>
` Re: Bulk DML performance
2025-03-17 17:45 UTC Renan Alves Fonseca <renanfonseca@gmail.com>
[11+ messages in thread]
Asking for OK for a nasty trick to resolve PG CVE-2025-1094 i
2025-03-06 07:39 UTC Abraham, Danny <danny_abraham@bmc.com>
` Re: Asking for OK for a nasty trick to resolve PG CVE-2025-1094 i
2025-03-06 08:11 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Asking for OK for a nasty trick to resolve PG CVE-2025-1094 i
2025-03-06 08:27 UTC Ron Johnson <ronljohnsonjr@gmail.com>
` Re: [EXTERNAL] Re: Asking for OK for a nasty trick to resolve PG CVE-2025-1094 i
2025-03-06 09:33 UTC Abraham, Danny <danny_abraham@bmc.com>
` Re: [EXTERNAL] Re: Asking for OK for a nasty trick to resolve PG CVE-2025-1094 i
2025-03-06 10:08 UTC Ron Johnson <ronljohnsonjr@gmail.com>
` Re: [EXTERNAL] Re: Asking for OK for a nasty trick to resolve PG CVE-2025-1094 i
2025-03-06 12:32 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: [EXTERNAL] Re: Asking for OK for a nasty trick to resolve PG CVE-2025-1094 i
2025-03-07 13:24 UTC Greg Sabino Mullane <htamfids@gmail.com>
[7+ messages in thread]
Slow performance of collate "en_US.utf8"
2025-02-27 13:54 UTC Alexey Borschev <a.borschev@postgrespro.ru>
` Re: Slow performance of collate "en_US.utf8"
2025-02-28 12:59 UTC Achilleas Mantzios - cloud <a.mantzios@cloud.gatewaynet.com>
` Re: Slow performance of collate "en_US.utf8"
2025-02-28 14:16 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Slow performance of collate "en_US.utf8"
2025-02-28 20:02 UTC Joe Conway <mail@joeconway.com>
` Re: Slow performance of collate "en_US.utf8"
2025-02-28 22:49 UTC Thomas Munro <thomas.munro@gmail.com>
` Re: Slow performance of collate "en_US.utf8"
2025-03-01 00:11 UTC Joe Conway <mail@joeconway.com>
` Slow performance of collate "en_US.utf8"
2025-03-03 08:47 UTC Alexey Borschev <a.borschev@postgrespro.ru>
[7+ messages in thread]
Unused index influencing sequential scan plan
2012-10-18 16:11 UTC Thom Brown <thom@linux.com>
` Re: Unused index influencing sequential scan plan
2012-10-18 16:13 UTC Thom Brown <thom@linux.com>
` Re: Unused index influencing sequential scan plan
2012-10-18 16:24 UTC Peter Geoghegan <peter@2ndquadrant.com>
` Re: Unused index influencing sequential scan plan
2012-10-18 16:44 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Unused index influencing sequential scan plan
2012-10-18 16:46 UTC Thom Brown <thom@linux.com>
` Re: Unused index influencing sequential scan plan
2012-10-18 16:47 UTC Thom Brown <thom@linux.com>
` Re: Unused index influencing sequential scan plan
2012-10-18 16:52 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Unused index influencing sequential scan plan
2012-10-18 17:00 UTC Peter Geoghegan <peter@2ndquadrant.com>
` Re: Unused index influencing sequential scan plan
2012-10-18 17:01 UTC Thom Brown <thom@linux.com>
` Re: Unused index influencing sequential scan plan
2012-10-18 17:01 UTC Thom Brown <thom@linux.com>
` Re: Unused index influencing sequential scan plan
2012-10-18 17:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Unused index influencing sequential scan plan
2025-02-28 23:19 UTC Thom Brown <thom@linux.com>
[12+ messages in thread]
Unfortunate Nested Loop + Missing Autovacuum
2025-02-21 23:46 UTC Lincoln Swaine-Moore <lswainemoore@gmail.com>
` Re: Unfortunate Nested Loop + Missing Autovacuum
2025-02-22 08:37 UTC Andrei Lepikhov <lepihov@gmail.com>
` Re: Unfortunate Nested Loop + Missing Autovacuum
2025-02-23 22:49 UTC Lincoln Swaine-Moore <lswainemoore@gmail.com>
` Re: Unfortunate Nested Loop + Missing Autovacuum
2025-02-24 02:08 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Unfortunate Nested Loop + Missing Autovacuum
2025-02-24 14:01 UTC Andrei Lepikhov <lepihov@gmail.com>
` Re: Unfortunate Nested Loop + Missing Autovacuum
2025-02-25 02:17 UTC Lincoln Swaine-Moore <lswainemoore@gmail.com>
[6+ messages in thread]
Query planning read a large amount of buffers for partitioned tables
2025-01-15 18:29 UTC bruno vieira da silva <brunogiovs@gmail.com>
` Re: Query planning read a large amount of buffers for partitioned tables
2025-01-15 18:32 UTC bruno vieira da silva <brunogiovs@gmail.com>
` Re: Query planning read a large amount of buffers for partitioned tables
2025-01-15 20:01 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Query planning read a large amount of buffers for partitioned tables
2025-01-16 14:56 UTC bruno vieira da silva <brunogiovs@gmail.com>
` Re: Query planning read a large amount of buffers for partitioned tables
2025-02-17 20:18 UTC bruno vieira da silva <brunogiovs@gmail.com>
` Re: Query planning read a large amount of buffers for partitioned tables
2025-02-17 20:25 UTC bruno vieira da silva <brunogiovs@gmail.com>
` Re: Query planning read a large amount of buffers for partitioned tables
2025-02-17 20:27 UTC bruno vieira da silva <brunogiovs@gmail.com>
` Re: Query planning read a large amount of buffers for partitioned tables
2025-02-18 12:16 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Query planning read a large amount of buffers for partitioned tables
2025-02-18 15:48 UTC bruno vieira da silva <brunogiovs@gmail.com>
[9+ messages in thread]
lwlock:LockManager wait_events
2024-10-25 06:36 UTC James Pang <jamespang886@gmail.com>
` Re: lwlock:LockManager wait_events
2024-10-25 07:36 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: lwlock:LockManager wait_events
2024-10-25 08:37 UTC Sean Massey <sean.f.massey@gmail.com>
` Re: lwlock:LockManager wait_events
2024-10-25 12:09 UTC SAMEER KUMAR <sameer.kasi200x@gmail.com>
` Re: lwlock:LockManager wait_events
2025-02-08 19:41 UTC kyle Hailey <kylelf@gmail.com>
[5+ messages in thread]
Performance loss after upgrading from 12.15 to 17.2
2025-02-03 14:11 UTC Tobias Orlamünde <postgres@linux-guru.com>
` Re: Performance loss after upgrading from 12.15 to 17.2
2025-02-03 15:59 UTC Laurenz Albe <laurenz.albe@cybertec.at>
[2+ messages in thread]
High System CPU Usage on Selects Seemingly Caused By Vacuum of Same Table
2025-01-31 22:28 UTC Joshua Banton <bantonj@gmail.com>
` Re: High System CPU Usage on Selects Seemingly Caused By Vacuum of Same Table
2025-01-31 22:45 UTC Peter Geoghegan <pg@bowt.ie>
` Re: High System CPU Usage on Selects Seemingly Caused By Vacuum of Same Table
2025-01-31 22:59 UTC Joshua Banton <bantonj@gmail.com>
[3+ messages in thread]
Why ORing with a false one-time filter turns an Index-Lookup into a SeqScan
2025-01-28 14:58 UTC Clemens Eisserer <linuxhippy@gmail.com>
` Re: Why ORing with a false one-time filter turns an Index-Lookup into a SeqScan
2025-01-28 15:34 UTC Wetmore, Matthew (CTR) <Matthew.Wetmore@mdlive.com>
` Re: Why ORing with a false one-time filter turns an Index-Lookup into a SeqScan
2025-01-29 12:07 UTC Clemens Eisserer <linuxhippy@gmail.com>
` Re: Why ORing with a false one-time filter turns an Index-Lookup into a SeqScan
2025-01-29 15:10 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
Simple query with Planner underestimating rows.
2025-01-28 19:29 UTC Felipe López Montes <xocas89@gmail.com>
` Re: Simple query with Planner underestimating rows.
2025-01-29 02:12 UTC Greg Sabino Mullane <htamfids@gmail.com>
` Re: Simple query with Planner underestimating rows.
2025-01-29 03:05 UTC Andrei Lepikhov <lepihov@gmail.com>
` Re: Simple query with Planner underestimating rows.
2025-01-29 08:57 UTC Andrei Lepikhov <lepihov@gmail.com>
[4+ messages in thread]
Re: [EXTERNAL] - Re: Reg pg_restore taking more time in windows compare to linux
2025-01-27 12:29 UTC Praveen Kumar Mandula <pmandula@opentext.com>
` Re: [EXTERNAL] - Re: Reg pg_restore taking more time in windows compare to linux
2025-01-27 15:06 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: [EXTERNAL] - Re: Reg pg_restore taking more time in windows compare to linux
2025-01-28 17:12 UTC Laurenz Albe <laurenz.albe@cybertec.at>
[3+ messages in thread]
Read-only connectios optimizatios
2025-01-25 14:55 UTC Edson Richter <edsonrichter@hotmail.com>
` Re: Read-only connectios optimizatios
2025-01-25 18:01 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Read-only connectios optimizatios
2025-01-25 22:12 UTC peter plachta <pplachta@gmail.com>
` RE: [EXT] Re: Read-only connectios optimizatios
2025-01-27 17:41 UTC Wong, Kam Fook (TR Technology) <kamfook.wong@thomsonreuters.com>
[4+ messages in thread]
Reg pg_restore taking more time in windows compare to linux
2025-01-26 07:14 UTC Praveen Kumar Mandula <pmandula@opentext.com>
` Re: Reg pg_restore taking more time in windows compare to linux
2025-01-27 08:53 UTC Laurenz Albe <laurenz.albe@cybertec.at>
[2+ messages in thread]
Any risk or overhead considerations for frequently executing queries against catalog tables?
2025-01-25 11:23 UTC Frits Hoogland <frits.hoogland@gmail.com>
` Re: Any risk or overhead considerations for frequently executing queries against catalog tables?
2025-01-25 13:32 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Any risk or overhead considerations for frequently executing queries against catalog tables?
2025-01-25 16:59 UTC Frits Hoogland <frits.hoogland@gmail.com>
` Re: Any risk or overhead considerations for frequently executing queries against catalog tables?
2025-01-25 18:18 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Any risk or overhead considerations for frequently executing queries against catalog tables?
2025-01-25 20:01 UTC Frits Hoogland <frits.hoogland@gmail.com>
` Re: Any risk or overhead considerations for frequently executing queries against catalog tables?
2025-01-25 22:08 UTC peter plachta <pplachta@gmail.com>
` Re: Any risk or overhead considerations for frequently executing queries against catalog tables?
2025-01-25 22:42 UTC frits.hoogland@gmail.com
` Re: Any risk or overhead considerations for frequently executing queries against catalog tables?
2025-01-26 06:43 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Any risk or overhead considerations for frequently executing queries against catalog tables?
2025-01-26 17:56 UTC Jeremy Schneider <schneider@ardentperf.com>
[9+ messages in thread]
Question: consolidating strpos searches?
2025-01-04 17:16 UTC James Addison <jay@jp-hosting.net>
` Re: Question: consolidating strpos searches?
2025-01-04 17:45 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Question: consolidating strpos searches?
2025-01-04 19:03 UTC Greg Sabino Mullane <htamfids@gmail.com>
` Re: Question: consolidating strpos searches?
2025-01-15 23:58 UTC James Addison <jay@jp-hosting.net>
[4+ messages in thread]
Aggressive vacuum
2024-12-19 13:37 UTC Graham Hay <grahamrhay@gmail.com>
` Re: Aggressive vacuum
2025-01-06 23:18 UTC Slava Mudry <slava44@gmail.com>
` Re: Aggressive vacuum
2025-01-07 19:30 UTC Jeff Janes <jeff.janes@gmail.com>
[3+ messages in thread]
Reg. Postgres Unique contraint
2024-11-27 04:14 UTC Sajjad Abid <abidsajjad@gmail.com>
` Re: Reg. Postgres Unique contraint
2024-11-27 04:18 UTC Diomedes Dominguez <diomedes.dominguez@gmail.com>
` Re: Reg. Postgres Unique contraint
2024-11-27 04:27 UTC Sajjad Abid <abidsajjad@gmail.com>
` Re: Reg. Postgres Unique contraint
2024-11-27 06:22 UTC Burcin Yazici <burcinyazici@gmail.com>
` Re: Reg. Postgres Unique contraint
2024-11-27 07:13 UTC Vitalii Tymchyshyn <vit@tym.im>
` RE: Reg. Postgres Unique contraint
2024-12-27 11:54 UTC msalais@msym.fr
` Re: Reg. Postgres Unique contraint
2024-12-27 12:57 UTC shammat@gmx.net
[7+ messages in thread]
CTE Inline On TPC-DS Query 95
2024-11-25 21:02 UTC Ba Jinsheng <bajinsheng@u.nus.edu>
` Re: CTE Inline On TPC-DS Query 95
2024-11-26 04:03 UTC David Rowley <dgrowleyml@gmail.com>
` RE: CTE Inline On TPC-DS Query 95
2024-12-27 11:34 UTC msalais@msym.fr
` Re: CTE Inline On TPC-DS Query 95
2024-12-27 11:40 UTC David Rowley <dgrowleyml@gmail.com>
[4+ messages in thread]
huge shared_blocks_hit one select but manually run very fast
2024-12-21 11:50 UTC James Pang <jamespang886@gmail.com>
` Re: huge shared_blocks_hit one select but manually run very fast
2024-12-21 16:40 UTC David Mullineux <dmullx@gmail.com>
` Re: huge shared_blocks_hit one select but manually run very fast
2024-12-22 03:38 UTC James Pang <jamespang886@gmail.com>
` Re: huge shared_blocks_hit one select but manually run very fast
2024-12-25 14:07 UTC David Mullineux <dmullx@gmail.com>
[4+ messages in thread]
Why a bitmap scan in this case?
2024-12-19 17:52 UTC Jon Zeppieri <zeppieri@gmail.com>
` Re: Why a bitmap scan in this case?
2024-12-19 18:38 UTC Greg Sabino Mullane <htamfids@gmail.com>
` Re: Why a bitmap scan in this case?
2024-12-19 19:09 UTC Jon Zeppieri <zeppieri@gmail.com>
` Re: Why a bitmap scan in this case?
2024-12-19 19:19 UTC Jon Zeppieri <zeppieri@gmail.com>
` Re: Why a bitmap scan in this case?
2024-12-20 08:16 UTC Frédéric Yhuel <frederic.yhuel@dalibo.com>
` Re: Why a bitmap scan in this case?
2024-12-20 09:57 UTC Frédéric Yhuel <frederic.yhuel@dalibo.com>
` Re: Why a bitmap scan in this case?
2024-12-20 21:01 UTC Jon Zeppieri <zeppieri@gmail.com>
[7+ messages in thread]
PostgreSQL and a Catch-22 Issue related to dead rows
2024-12-09 11:02 UTC Lars Aksel Opsahl <Lars.Opsahl@nibio.no>
` Re: PostgreSQL and a Catch-22 Issue related to dead rows
2024-12-09 13:18 UTC MichaelDBA@sqlexec.com <michaeldba@sqlexec.com>
` Re: PostgreSQL and a Catch-22 Issue related to dead rows
2024-12-09 13:35 UTC Greg Sabino Mullane <htamfids@gmail.com>
` Re: PostgreSQL and a Catch-22 Issue related to dead rows
2024-12-09 13:37 UTC Lars Aksel Opsahl <Lars.Opsahl@nibio.no>
` Re: PostgreSQL and a Catch-22 Issue related to dead rows
2024-12-09 13:56 UTC Lars Aksel Opsahl <Lars.Opsahl@nibio.no>
` Re: PostgreSQL and a Catch-22 Issue related to dead rows
2024-12-09 14:25 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: PostgreSQL and a Catch-22 Issue related to dead rows
2024-12-09 14:32 UTC Christophe Pettus <xof@thebuild.com>
` Re: PostgreSQL and a Catch-22 Issue related to dead rows
2024-12-09 16:07 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: PostgreSQL and a Catch-22 Issue related to dead rows
2024-12-10 05:19 UTC Lars Aksel Opsahl <Lars.Opsahl@nibio.no>
` Re: PostgreSQL and a Catch-22 Issue related to dead rows
2024-12-10 05:32 UTC Lars Aksel Opsahl <Lars.Opsahl@nibio.no>
` Re: PostgreSQL and a Catch-22 Issue related to dead rows
2024-12-10 08:55 UTC Lars Aksel Opsahl <Lars.Opsahl@nibio.no>
` Re: PostgreSQL and a Catch-22 Issue related to dead rows
2024-12-10 13:03 UTC Greg Sabino Mullane <htamfids@gmail.com>
` Re: PostgreSQL and a Catch-22 Issue related to dead rows
2024-12-10 14:03 UTC Lars Aksel Opsahl <Lars.Opsahl@nibio.no>
` Re: PostgreSQL and a Catch-22 Issue related to dead rows
2024-12-10 15:31 UTC Greg Sabino Mullane <htamfids@gmail.com>
` Re: PostgreSQL and a Catch-22 Issue related to dead rows
2024-12-10 20:26 UTC Hannu Krosing <hannuk@google.com>
` Re: PostgreSQL and a Catch-22 Issue related to dead rows
2024-12-11 07:32 UTC Lars Aksel Opsahl <Lars.Opsahl@nibio.no>
` Re: PostgreSQL and a Catch-22 Issue related to dead rows
2024-12-11 13:29 UTC Lars Aksel Opsahl <Lars.Opsahl@nibio.no>
[17+ messages in thread]
can a blocked transaction affect the performance of one that is blocking it?
2024-12-09 18:42 UTC Eric Schwarzenbach <subscriber@blackbrook.org>
` Re: can a blocked transaction affect the performance of one that is blocking it?
2024-12-09 23:10 UTC Nikolay Samokhvalov <nik@postgres.ai>
` Re: can a blocked transaction affect the performance of one that is blocking it?
2024-12-10 09:22 UTC David Mullineux <dmullx@gmail.com>
[3+ 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