pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedSpecific objects backup in PostgreSQL
2024-07-10 18:05 UTC nikhil kumar <nikhil.dba97@gmail.com>
` Re: Specific objects backup in PostgreSQL
2024-07-10 18:41 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Specific objects backup in PostgreSQL
2024-07-10 18:42 UTC Olivier Gautherot <ogautherot@gautherot.net>
` Re: Specific objects backup in PostgreSQL
2024-07-10 20:04 UTC Anthony Sotolongo <asotolongo@gmail.com>
` Re: Specific objects backup in PostgreSQL
2024-07-11 03:29 UTC nikhil kumar <nikhil.dba97@gmail.com>
[5+ messages in thread]
Query performance issue
2007-07-24 07:48 UTC Jonathan Gray <jgray@streamy.com>
` Re: Query performance issue
2007-07-24 08:44 UTC Chris <dmagick@gmail.com>
` Re: Query performance issue
2007-07-24 08:50 UTC Chris <dmagick@gmail.com>
` Re: Query performance issue
2007-07-24 09:18 UTC Jonathan Gray <jgray@streamy.com>
` Re: Query performance issue
2007-07-24 09:36 UTC Chris <dmagick@gmail.com>
` Re: Query performance issue
2007-07-24 09:50 UTC Jonathan Gray <jgray@streamy.com>
` Query performance issue
2011-08-31 09:00 UTC Jayadevan M <Jayadevan.Maymala@ibsplc.com>
` Re: Query performance issue
2011-08-31 09:34 UTC Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
` Re: Query performance issue
2011-08-31 09:37 UTC Sushant Sinha <sushant354@gmail.com>
` Re: Query performance issue
2011-08-31 10:07 UTC Jayadevan M <Jayadevan.Maymala@ibsplc.com>
` Re: Query performance issue
2011-08-31 10:51 UTC Jayadevan M <Jayadevan.Maymala@ibsplc.com>
` Re: Query performance issue
2011-08-31 11:19 UTC Jayadevan M <Jayadevan.Maymala@ibsplc.com>
` Re: Query performance issue
2011-08-31 11:32 UTC Venkat Balaji <venkat.balaji@verse.in>
` Re: Query performance issue
2011-08-31 11:41 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Query performance issue
2011-08-31 11:57 UTC Jayadevan M <Jayadevan.Maymala@ibsplc.com>
` Re: Query performance issue
2011-08-31 12:40 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Query performance issue
2011-09-03 04:48 UTC Jayadevan <Jayadevan.Maymala@ibsplc.com>
` Re: Query performance issue
2011-09-04 10:38 UTC Grzegorz Jaśkiewicz <gryzman@gmail.com>
` Re: Query performance issue
2011-09-04 14:30 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Query performance issue
2011-09-04 15:18 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query performance issue
2011-09-04 18:06 UTC Jayadevan <Jayadevan.Maymala@ibsplc.com>
` Re: Query performance issue
2011-09-04 20:18 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Query performance issue
2011-09-05 04:19 UTC Jayadevan M <Jayadevan.Maymala@ibsplc.com>
` Re: Query performance issue
2011-09-06 03:30 UTC Jayadevan <Jayadevan.Maymala@ibsplc.com>
` query performance issue
2017-11-15 09:33 UTC Samir Magar <samirmagar8@gmail.com>
` Re: query performance issue
2017-11-15 09:43 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: query performance issue
2017-11-15 12:54 UTC Samir Magar <samirmagar8@gmail.com>
` Re: query performance issue
2017-11-15 13:12 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: query performance issue
2017-11-15 14:16 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: query performance issue
2017-11-15 19:58 UTC Gunther <raj@gusw.net>
` Re: query performance issue
2017-11-15 20:07 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Query Performance Issue
2018-12-27 19:25 UTC neslişah demirci <neslisah.demirci@gmail.com>
` Re: Query Performance Issue
2018-12-28 14:53 UTC Alexey Bashtanov <bashtanov@imap.cc>
` Re: Query Performance Issue
2018-12-28 15:32 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Query Performance Issue
2018-12-29 06:58 UTC David Rowley <david.rowley@2ndquadrant.com>
` Re: Query Performance Issue
2018-12-29 07:15 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Query Performance Issue
2018-12-29 12:00 UTC Jim Finnerty <jfinnert@amazon.com>
` Re: Query Performance Issue
2018-12-29 20:27 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Query Performance Issue
2018-12-29 22:00 UTC David Rowley <david.rowley@2ndquadrant.com>
` Query performance issue
2020-09-04 21:18 UTC Nagaraj Raj <nagaraj.sf@yahoo.com>
` Re: Query performance issue
2020-09-04 21:23 UTC Thomas Kellerer <shammat@gmx.net>
` Re: Query performance issue
2020-09-04 21:24 UTC Nagaraj Raj <nagaraj.sf@yahoo.com>
` Re: Query performance issue
2020-09-04 21:36 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Query performance issue
2020-09-04 21:39 UTC Michael Lewis <mlewis@entrata.com>
` Re: Query performance issue
2020-09-04 21:41 UTC Michael Lewis <mlewis@entrata.com>
` Re: Query performance issue
2020-09-04 21:44 UTC Nagaraj Raj <nagaraj.sf@yahoo.com>
` Re: Query performance issue
2020-09-04 21:55 UTC Michael Lewis <mlewis@entrata.com>
` Re: Query performance issue
2020-09-04 22:20 UTC Nagaraj Raj <nagaraj.sf@yahoo.com>
` Re: Query performance issue
2020-09-05 08:16 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Query performance issue
2020-09-05 13:42 UTC Michael Lewis <mlewis@entrata.com>
` Re: Query performance issue
2020-09-05 21:49 UTC Nagaraj Raj <nagaraj.sf@yahoo.com>
` Query performance issue
2021-01-22 01:53 UTC Nagaraj Raj <nagaraj.sf@yahoo.com>
` Re: Query performance issue
2021-01-22 02:35 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Query performance issue
2021-02-14 22:03 UTC Tomas Vondra <tomas.vondra@enterprisedb.com>
` Re: Query performance issue
2021-02-16 16:40 UTC Michael Lewis <mlewis@entrata.com>
` Query performance issue
2024-07-10 07:11 UTC Dheeraj Sonawane <Dheeraj.Sonawane@ethoca.com>
` Re: Query performance issue
2024-07-10 13:40 UTC Tom Lane <tgl@sss.pgh.pa.us>
[57+ messages in thread]
Low performance between datacenters
2024-07-07 18:17 UTC Tamás PAPP <tomposmiko@gmail.com>
` Re: Low performance between datacenters
2024-07-07 20:23 UTC Fernando Hevia <fhevia@gmail.com>
` Re: Low performance between datacenters
2024-07-08 00:42 UTC Vitalii Tymchyshyn <vit@tym.im>
` Re: Low performance between datacenters
2024-07-08 07:24 UTC Andrei Lepikhov <lepihov@gmail.com>
[4+ messages in thread]
Hash Right join and seq scan
2024-07-03 04:57 UTC James Pang <jamespang886@gmail.com>
` Re: Hash Right join and seq scan
2024-07-03 06:51 UTC James Pang <jamespang886@gmail.com>
` Re: Hash Right join and seq scan
2024-07-03 06:53 UTC James Pang <jamespang886@gmail.com>
` Re: Hash Right join and seq scan
2024-07-03 17:40 UTC Tomas Vondra <tomas.vondra@enterprisedb.com>
` Re: Hash Right join and seq scan
2024-07-05 00:50 UTC James Pang <jamespang886@gmail.com>
` Re: Hash Right join and seq scan
2024-07-05 02:15 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Hash Right join and seq scan
2024-07-05 14:43 UTC James Pang <jamespang886@gmail.com>
` Re: Hash Right join and seq scan
2024-07-06 00:32 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Hash Right join and seq scan
2024-07-08 02:21 UTC James Pang <jamespang886@gmail.com>
` Re: Hash Right join and seq scan
2024-07-08 02:26 UTC Justin Pryzby <pryzby@telsasoft.com>
[10+ messages in thread]
a lot of shared buffers hit when planning for a simple query with primary access path
2024-07-01 09:45 UTC James Pang <jamespang886@gmail.com>
` Re: a lot of shared buffers hit when planning for a simple query with primary access path
2024-07-01 10:10 UTC David Rowley <dgrowleyml@gmail.com>
` Re: a lot of shared buffers hit when planning for a simple query with primary access path
2024-07-01 10:20 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: a lot of shared buffers hit when planning for a simple query with primary access path
2024-07-01 10:52 UTC David Rowley <dgrowleyml@gmail.com>
` Re: a lot of shared buffers hit when planning for a simple query with primary access path
2024-07-01 10:58 UTC James Pang <jamespang886@gmail.com>
` Re: a lot of shared buffers hit when planning for a simple query with primary access path
2024-07-01 11:31 UTC Andrei Lepikhov <lepihov@gmail.com>
[6+ messages in thread]
Inconsistent query performance based on relation hit frequency
2024-06-27 00:50 UTC Laura Hausmann <laura@hausmann.dev>
` Re: Inconsistent query performance based on relation hit frequency
2024-06-27 10:31 UTC Andrei Lepikhov <lepihov@gmail.com>
` Re: Inconsistent query performance based on relation hit frequency
2024-06-27 13:27 UTC Achilleas Mantzios - cloud <a.mantzios@cloud.gatewaynet.com>
` Re: Inconsistent query performance based on relation hit frequency
2024-06-27 14:58 UTC Laura Hausmann <laura@hausmann.dev>
` Re: Inconsistent query performance based on relation hit frequency
2024-06-27 19:22 UTC Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
[5+ messages in thread]
Row level security
2024-06-24 22:28 UTC Thomas Simpson <ts@talentstack.to>
` Re: Row level security
2024-06-27 10:45 UTC Andrew Okhmat <andy@supportex.net>
[2+ messages in thread]
performance of sql and plpgsql functions
2024-06-17 09:35 UTC Julius Tuskenis <julius.tuskenis@gmail.com>
` Re: performance of sql and plpgsql functions
2024-06-17 09:44 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: performance of sql and plpgsql functions
2024-06-17 11:01 UTC Julius Tuskenis <julius.tuskenis@gmail.com>
` Re: performance of sql and plpgsql functions
2024-06-17 12:59 UTC Philip Semanchuk <philip@americanefficient.com>
` Re: performance of sql and plpgsql functions
2024-06-17 13:54 UTC Julius Tuskenis <julius.tuskenis@gmail.com>
` Re: performance of sql and plpgsql functions
2024-06-17 14:07 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: performance of sql and plpgsql functions
2024-06-17 14:24 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: performance of sql and plpgsql functions
2024-06-18 13:03 UTC Julius Tuskenis <julius.tuskenis@gmail.com>
[8+ messages in thread]
BDR that performs
2024-06-14 12:08 UTC Smith, Travis <Travis.Smith@circana.com>
` Re: BDR that performs
2024-06-14 12:35 UTC Bruce Momjian <bruce@momjian.us>
` Re: BDR that performs
2024-06-14 12:40 UTC Hari Kiran <hari@pgedge.com>
` Re: BDR that performs
2024-06-14 12:41 UTC P C <puravc@gmail.com>
` Re: BDR that performs
2024-06-14 14:57 UTC Bruce Momjian <bruce@momjian.us>
[5+ messages in thread]
Need help on configuration SMTP
2024-06-12 11:58 UTC nikhil kumar <nikhil.dba97@gmail.com>
` Re: Need help on configuration SMTP
2024-06-12 12:01 UTC Muhammad Ikram <mmikram@gmail.com>
` Re: Need help on configuration SMTP
2024-06-12 12:25 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Need help on configuration SMTP
2024-06-12 17:16 UTC nikhil kumar <nikhil.dba97@gmail.com>
[4+ messages in thread]
Distinct performance dropped by multiple times in v16
2024-06-10 06:59 UTC Vitaliy Litovskiy <vitaliy.litovskiy@gmail.com>
` Re: Distinct performance dropped by multiple times in v16
2024-06-10 16:24 UTC Greg Sabino Mullane <htamfids@gmail.com>
` Re: Distinct performance dropped by multiple times in v16
2024-06-11 07:10 UTC Andrei Lepikhov <a.lepikhov@postgrespro.ru>
` Re: Distinct performance dropped by multiple times in v16
2024-06-12 12:10 UTC Andrei Lepikhov <a.lepikhov@postgrespro.ru>
[4+ messages in thread]
Postgresql initialize error
2024-06-11 19:58 UTC nikhil kumar <nikhil.dba97@gmail.com>
` Re: Postgresql initialize error
2024-06-11 19:59 UTC nikhil kumar <nikhil.dba97@gmail.com>
` Re: Postgresql initialize error
2024-06-11 20:04 UTC Muhammad Salahuddin Manzoor <salahuddin.m@bitnine.net>
` Re: Postgresql initialize error
2024-06-11 20:05 UTC nikhil kumar <nikhil.dba97@gmail.com>
` Re: Postgresql initialize error
2024-06-11 20:23 UTC nikhil kumar <nikhil.dba97@gmail.com>
` RE: Postgresql initialize error
2024-06-11 20:25 UTC Smith, Travis <Travis.Smith@circana.com>
[6+ messages in thread]
query column in pg_stat_statements and pg_stat_activity
2024-06-04 06:46 UTC Satalabaha Postgres <satalabaha.postgres@gmail.com>
Plan selection based on worst case scenario
2024-05-30 01:03 UTC Darwin O'Connor <doconno@gmail.com>
` Re: Plan selection based on worst case scenario
2024-05-30 01:44 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Plan selection based on worst case scenario
2024-05-30 04:03 UTC Chema <chema@interneta.org>
[3+ messages in thread]
Extremely slow to establish connection when user has a high number of roles
2024-04-20 11:55 UTC Michal Charemza <michal@charemza.name>
` Re: Extremely slow to establish connection when user has a high number of roles
2024-04-20 12:57 UTC Tomas Vondra <tomas.vondra@enterprisedb.com>
` Re: Extremely slow to establish connection when user has a high number of roles
2024-04-20 14:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Extremely slow to establish connection when user has a high number of roles
2024-04-20 14:52 UTC Vijaykumar Jain <vijaykumarjain.github@gmail.com>
` Re: Extremely slow to establish connection when user has a high number of roles
2024-04-20 15:12 UTC Michal Charemza <michal@charemza.name>
` Re: Extremely slow to establish connection when user has a high number of roles
2024-04-20 15:22 UTC Michal Charemza <michal@charemza.name>
` Re: Extremely slow to establish connection when user has a high number of roles
2024-04-20 15:24 UTC Frits Hoogland <frits.hoogland@gmail.com>
` Re: Extremely slow to establish connection when user has a high number of roles
2024-04-20 15:34 UTC Michal Charemza <michal@charemza.name>
` Re: Extremely slow to establish connection when user has a high number of roles
2024-04-20 15:52 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Extremely slow to establish connection when user has a high number of roles
2024-04-21 11:08 UTC Michal Charemza <michal@charemza.name>
` Re: Extremely slow to establish connection when user has a high number of roles
2024-04-21 15:08 UTC Tom Lane <tgl@sss.pgh.pa.us>
[11+ messages in thread]
LWlock:LockManager waits
2024-04-09 03:07 UTC James Pang <jamespang886@gmail.com>
` Re: LWlock:LockManager waits
2024-04-09 04:31 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: LWlock:LockManager waits
2024-04-09 07:54 UTC James Pang <jamespang886@gmail.com>
` Re: LWlock:LockManager waits
2024-04-09 08:36 UTC Frits Hoogland <frits.hoogland@gmail.com>
` Re: LWlock:LockManager waits
2024-04-09 09:36 UTC Frits Hoogland <frits.hoogland@gmail.com>
` Re: LWlock:LockManager waits
2024-04-09 10:33 UTC Luiz Fernando G. Verona <nandoverona@gmail.com>
[6+ messages in thread]
IN subquery, many joins, very different plans
2024-04-05 15:20 UTC Dave Thorn <dave.thorn@gmail.com>
maintenance_work_mem impact?
2024-03-19 16:05 UTC Adithya Kumaranchath <akumaranchath@live.com>
` Re: maintenance_work_mem impact?
2024-03-19 17:54 UTC Laurenz Albe <laurenz.albe@cybertec.at>
[2+ messages in thread]
huge SubtransSLRU and SubtransBuffer wait_event
2024-02-01 11:50 UTC James Pang (chaolpan) <chaolpan@cisco.com>
` Re: huge SubtransSLRU and SubtransBuffer wait_event
2024-02-01 12:41 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` RE: huge SubtransSLRU and SubtransBuffer wait_event
2024-02-01 15:34 UTC James Pang (chaolpan) <chaolpan@cisco.com>
` RE: huge SubtransSLRU and SubtransBuffer wait_event
2024-02-02 06:47 UTC James Pang (chaolpan) <chaolpan@cisco.com>
` Re: huge SubtransSLRU and SubtransBuffer wait_event
2024-02-02 08:12 UTC Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: huge SubtransSLRU and SubtransBuffer wait_event
2024-02-02 09:26 UTC Lars Aksel Opsahl <Lars.Opsahl@nibio.no>
` Re: huge SubtransSLRU and SubtransBuffer wait_event
2024-02-02 10:04 UTC Nikolay Samokhvalov <samokhvalov@gmail.com>
` Re: huge SubtransSLRU and SubtransBuffer wait_event
2024-02-02 10:31 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` RE: huge SubtransSLRU and SubtransBuffer wait_event
2024-02-06 06:59 UTC James Pang (chaolpan) <chaolpan@cisco.com>
` Re: FW: huge SubtransSLRU and SubtransBuffer wait_event
2024-02-26 06:01 UTC James Pang <jamespang886@gmail.com>
` Re: FW: huge SubtransSLRU and SubtransBuffer wait_event
2024-03-01 06:56 UTC James Pang <jamespang886@gmail.com>
` Re: FW: huge SubtransSLRU and SubtransBuffer wait_event
2024-03-01 07:35 UTC Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: FW: huge SubtransSLRU and SubtransBuffer wait_event
2024-03-15 02:03 UTC James Pang <jamespang886@gmail.com>
[13+ messages in thread]
Is partition pruning impacted by data type
2024-03-04 19:39 UTC sud <suds1434@gmail.com>
` Re: Is partition pruning impacted by data type
2024-03-05 05:20 UTC sud <suds1434@gmail.com>
` Re: Is partition pruning impacted by data type
2024-03-05 19:05 UTC Lok P <loknath.73@gmail.com>
` Re: Is partition pruning impacted by data type
2024-03-05 19:29 UTC sud <suds1434@gmail.com>
` Re: Is partition pruning impacted by data type
2024-03-07 20:37 UTC sud <suds1434@gmail.com>
[5+ messages in thread]
Separate 100 M spatial data in 100 tables VS one big table
2024-03-05 07:44 UTC kimaidou <kimaidou@gmail.com>
` Re: Separate 100 M spatial data in 100 tables VS one big table
2024-03-05 12:47 UTC Marc Millas <marc.millas@mokadb.com>
` Re: Separate 100 M spatial data in 100 tables VS one big table
2024-03-05 20:13 UTC Tomas Vondra <tomas.vondra@enterprisedb.com>
` Re: Separate 100 M spatial data in 100 tables VS one big table
2024-03-06 16:13 UTC kimaidou <kimaidou@gmail.com>
[4+ messages in thread]
Optimizing count(), but Explain estimates wildly off
2024-02-27 00:25 UTC Chema <chema@interneta.org>
` Re: Optimizing count(), but Explain estimates wildly off
2024-02-27 04:36 UTC Vitalii Tymchyshyn <vit@tym.im>
` Re: Optimizing count(), but Explain estimates wildly off
2024-02-27 07:40 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Optimizing count(), but Explain estimates wildly off
2024-02-27 13:11 UTC Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: Optimizing count(), but Explain estimates wildly off
2024-02-29 23:15 UTC Chema <chema@interneta.org>
` Re: Optimizing count(), but Explain estimates wildly off
2024-03-01 08:57 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Optimizing count(), but Explain estimates wildly off
2024-03-04 19:13 UTC Chema <chema@interneta.org>
` Re: Optimizing count(), but Explain estimates wildly off
2024-03-05 01:50 UTC Greg Sabino Mullane <htamfids@gmail.com>
` Re: Optimizing count(), but Explain estimates wildly off
2024-03-05 14:00 UTC Chema <chema@interneta.org>
` Re: Optimizing count(), but Explain estimates wildly off
2024-03-05 17:04 UTC Greg Sabino Mullane <htamfids@gmail.com>
` Re: Optimizing count(), but Explain estimates wildly off
2024-03-06 14:00 UTC Chema <chema@interneta.org>
[11+ messages in thread]
(no subject)
2019-02-09 16:45 UTC Evandro Abreu <evandro.abreu@gmail.com>
` Re:
2019-02-10 18:43 UTC Tumasgiu Rossini <rossini.t@gmail.com>
` Table Partitioning and Indexes Performance Questions
2024-02-29 16:42 UTC David Kelly <dkelly123190@gmail.com>
` Re: Table Partitioning and Indexes Performance Questions
2024-02-29 17:32 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Table Partitioning and Indexes Performance Questions
2024-02-29 18:11 UTC Anupam b <abordia99@hotmail.com>
[5+ messages in thread]
generic plan generate poor performance
2024-02-29 14:27 UTC James Pang <jamespang886@gmail.com>
` Re: generic plan generate poor performance
2024-02-29 14:38 UTC Pavel Stehule <pavel.stehule@gmail.com>
[2+ messages in thread]
extend statistics help reduce index scan a lot of shared buffer hits.
2024-02-27 13:54 UTC James Pang <jamespang886@gmail.com>
` Fwd: extend statistics help reduce index scan a lot of shared buffer hits.
2024-02-27 13:58 UTC James Pang <jamespang886@gmail.com>
` Re: Fwd: extend statistics help reduce index scan a lot of shared buffer hits.
2024-02-28 14:53 UTC Tomas Vondra <tomas.vondra@enterprisedb.com>
[3+ messages in thread]
[next (older)]
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox