pgsql-performance

Messages by Date

2022/04/17 Re: Query Planner not taking advantage of HASH PARTITION Tom Lane
2022/04/17 RE: Query Tunning related to function Kumar, Mukesh
2022/04/17 RE: Query Tunning related to function Kumar, Mukesh
2022/04/17 Query Planner not taking advantage of HASH PARTITION Benjamin Tingle
2022/04/16 Re: Query Tunning related to function Justin Pryzby
2022/04/14 Re: Query Tunning related to function Bhupendra Babu
2022/04/14 Re: Performance for SQL queries on Azure PostgreSQL PaaS instance overland
2022/04/14 RE: Query Tunning related to function Kumar, Mukesh
2022/04/14 RE: Query Tunning related to function Michel SALAIS
2022/04/14 RE: Query Tunning related to function Kumar, Mukesh
2022/04/14 Re: SQL performance issue after migration from Oracle to Aurora postgres Andrew Dunstan
2022/04/14 Re: Query Tunning related to function Ranier Vilela
2022/04/14 Query Tunning related to function Kumar, Mukesh
2022/04/14 SQL performance issue after migration from Oracle to Aurora postgres Goti
2022/04/13 Re: An I/O error occurred while sending to the backend (PG 13.4) Justin Pryzby
2022/04/13 RE: An I/O error occurred while sending to the backend (PG 13.4) l...@laurent-hasson.com
2022/04/13 Re: Performance for SQL queries on Azure PostgreSQL PaaS instance andrew cooke
2022/04/13 RE: Performance for SQL queries on Azure PostgreSQL PaaS instance Kumar, Mukesh
2022/04/13 Re: Performance for SQL queries on Azure PostgreSQL PaaS instance Laurenz Albe
2022/04/12 Re: Performance for SQL queries on Azure PostgreSQL PaaS instance Tomas Vondra
2022/04/12 Re: Performance for SQL queries on Azure PostgreSQL PaaS instance Frits Jalvingh
2022/04/12 Performance for SQL queries on Azure PostgreSQL PaaS instance Kumar, Mukesh
2022/04/06 Re: Slow Planning Times Saurabh Sehgal
2022/04/06 Re: Slow Planning Times Tom Lane
2022/04/06 Re: Slow Planning Times Saurabh Sehgal
2022/04/06 Re: Slow Planning Times David G. Johnston
2022/04/06 Re: Slow Planning Times Saurabh Sehgal
2022/04/06 Slow Planning Times Saurabh Sehgal
2022/04/04 Re: HIGH IO and Less CPU utilization Rambabu g
2022/03/31 Re: Postgresql TPS Bottleneck Mladen Gogala
2022/03/31 Re: Postgresql TPS Bottleneck Tomas Vondra
2022/03/31 Re: Postgresql TPS Bottleneck MichaelDBA
2022/03/31 Re: HIGH IO and Less CPU utilization Mladen Gogala
2022/03/31 Re: Postgresql TPS Bottleneck Guillaume Cottenceau
2022/03/31 Postgresql TPS Bottleneck wakandavision
2022/03/30 Re: HIGH IO and Less CPU utilization Justin Pryzby
2022/03/30 RE: High process memory consumption when running sort Shai Shapira
2022/03/29 Re: HIGH IO and Less CPU utilization Rambabu g
2022/03/29 Re: HIGH IO and Less CPU utilization Justin Pryzby
2022/03/29 Re: HIGH IO and Less CPU utilization Rambabu g
2022/03/29 Re: HIGH IO and Less CPU utilization Justin Pryzby
2022/03/29 HIGH IO and Less CPU utilization Rambabu g
2022/03/26 RE: View taking time to show records Kumar, Mukesh
2022/03/26 Re: Performance issue post upgrade on Version 13 - Incorrect Estimation Cost choosing Hash Aggregate-Nested Left Loop Join Tomas Vondra
2022/03/25 Re: View taking time to show records Laurenz Albe
2022/03/25 Re: View taking time to show records Laurenz Albe
2022/03/25 Re: View taking time to show records hubert depesz lubaczewski
2022/03/25 Re: View taking time to show records aditya desai
2022/03/25 View taking time to show records Kumar, Mukesh
2022/03/24 Re: Performance issue post upgrade on Version 13 - Incorrect Estimation Cost choosing Hash Aggregate-Nested Left Loop Join Justin Pryzby
2022/03/24 Performance issue post upgrade on Version 13 - Incorrect Estimation Cost choosing Hash Aggregate-Nested Left Loop Join Prajna Shetty
2022/03/24 Re: Using system tables directly takes many hours, using temp tables with no indexes takes a few seconds for geometry_columns view. Lars Aksel Opsahl
2022/03/23 Re: High process memory consumption when running sort Justin Pryzby
2022/03/23 Re: Using system tables directly takes many hours, using temp tables with no indexes takes a few seconds for geometry_columns view. Lars Aksel Opsahl
2022/03/23 High process memory consumption when running sort Shai Shapira
2022/03/23 Re: Using system tables directly takes many hours, using temp tables with no indexes takes a few seconds for geometry_columns view. Justin Pryzby
2022/03/23 Re: Using system tables directly takes many hours, using temp tables with no indexes takes a few seconds for geometry_columns view. Lars Aksel Opsahl
2022/03/23 Using system tables directly takes many hours, using temp tables with no indexes takes a few seconds for geometry_columns view. Lars Aksel Opsahl
2022/03/16 RE: Optimal configuration for server Michel SALAIS
2022/03/12 Re: Optimal configuration for server Moises Lopez
2022/03/09 Re: Explain analyse with track_io_timing Jayadevan M
2022/03/09 Re: Explain analyse with track_io_timing Julien Rouhaud
2022/03/09 Explain analyse with track_io_timing Jayadevan M
2022/03/08 Re: Any way to speed up INSERT INTO aditya desai
2022/03/08 Re: Any way to speed up INSERT INTO Bruce Momjian
2022/03/08 Re: Any way to speed up INSERT INTO aditya desai
2022/03/07 Re: Optimal configuration for server Justin Pryzby
2022/03/07 Re: Optimal configuration for server Ranier Vilela
2022/03/07 Re: Optimal configuration for server Luiz Felipph
2022/03/07 Re: Optimal configuration for server Tomas Vondra
2022/03/07 Re: Optimal configuration for server Ranier Vilela
2022/03/07 Re: Optimal configuration for server Luiz Felipph
2022/03/07 Re: Optimal configuration for server Ranier Vilela
2022/03/07 Optimal configuration for server Luiz Felipph
2022/03/05 Re: OOM killer while pg_restore Ranier Vilela
2022/03/05 Re: OOM killer while pg_restore Marc Rechté
2022/03/04 Re: Any way to speed up INSERT INTO aditya desai
2022/03/04 Re: XA transactions much slower on 14.2 than on 13.5 Tom Lane
2022/03/04 XA transactions much slower on 14.2 than on 13.5 Mladen Gogala
2022/03/04 Re: Any way to speed up INSERT INTO Imre Samu
2022/03/04 RES: Any way to speed up INSERT INTO Edson Richter
2022/03/04 Re: Any way to speed up INSERT INTO Andres Freund
2022/03/04 Re: Any way to speed up INSERT INTO Bruce Momjian
2022/03/04 Re: Any way to speed up INSERT INTO aditya desai
2022/03/04 Re: Any way to speed up INSERT INTO Tom Lane
2022/03/04 Re: Any way to speed up INSERT INTO Bruce Momjian
2022/03/04 Any way to speed up INSERT INTO aditya desai
2022/03/03 Re: OOM killer while pg_restore Tom Lane
2022/03/03 Re: OOM killer while pg_restore Marc Rechté
2022/03/03 Re: An I/O error occurred while sending to the backend (PG 13.4) Ranier Vilela
2022/03/03 RE: An I/O error occurred while sending to the backend (PG 13.4) l...@laurent-hasson.com
2022/03/03 Re: An I/O error occurred while sending to the backend (PG 13.4) Ranier Vilela
2022/03/03 Re: An I/O error occurred while sending to the backend (PG 13.4) Justin Pryzby
2022/03/03 Re: An I/O error occurred while sending to the backend (PG 13.4) Ranier Vilela
2022/03/03 Re: OOM killer while pg_restore Tom Lane
2022/03/03 RE: An I/O error occurred while sending to the backend (PG 13.4) l...@laurent-hasson.com
2022/03/03 Re: OOM killer while pg_restore Justin Pryzby
2022/03/03 Re: OOM killer while pg_restore Ranier Vilela
2022/03/03 Re: OOM killer while pg_restore Marc Rechté
2022/03/03 Re: OOM killer while pg_restore Ranier Vilela
2022/03/03 OOM killer while pg_restore Marc Rechté
2022/03/02 Re: Simple task with partitioning which I can't realize Mladen Gogala
2022/03/02 Re: Simple task with partitioning which I can't realize Geri Wright
2022/03/01 RE: Simple task with partitioning which I can't realize Michel SALAIS
2022/03/01 Re: Advice needed: query performance deteriorates by 2000% within 1 minute Michael Lewis
2022/03/01 Re: Advice needed: query performance deteriorates by 2000% within 1 minute Michael Lewis
2022/03/01 Re: An I/O error occurred while sending to the backend (PG 13.4) Ranier Vilela
2022/03/01 Re: An I/O error occurred while sending to the backend (PG 13.4) Justin Pryzby
2022/03/01 RE: Simple task with partitioning which I can't realize Andrew Zakharov
2022/03/01 Re: Simple task with partitioning which I can't realize Marc Millas
2022/03/01 RE: Simple task with partitioning which I can't realize Andrew Zakharov
2022/03/01 Re: Simple task with partitioning which I can't realize David G. Johnston
2022/03/01 RE: Simple task with partitioning which I can't realize Andrew Zakharov
2022/03/01 Re: Simple task with partitioning which I can't realize Marc Millas
2022/03/01 RE: An I/O error occurred while sending to the backend (PG 13.4) l...@laurent-hasson.com
2022/03/01 Re: Simple task with partitioning which I can't realize David G. Johnston
2022/03/01 Re: Never Ending query in PostgreSQL Tomas Vondra
2022/03/01 Simple task with partitioning which I can't realize Andrew Zakharov
2022/03/01 RE: Never Ending query in PostgreSQL Kumar, Mukesh
2022/03/01 Re: Never Ending query in PostgreSQL Tomas Vondra
2022/03/01 RLS not using index scan but seq scan when condition gets a bit complicated Charles Huang
2022/02/28 Re: Advice needed: query performance deteriorates by 2000% within 1 minute Peter Adlersburg
2022/02/28 Re: Never Ending query in PostgreSQL Mladen Gogala
2022/02/28 Re: Never Ending query in PostgreSQL Mladen Gogala
2022/02/28 Re: An I/O error occurred while sending to the backend (PG 13.4) Justin Pryzby
2022/02/28 RE: An I/O error occurred while sending to the backend (PG 13.4) l...@laurent-hasson.com
2022/02/28 RE: An I/O error occurred while sending to the backend (PG 13.4) l...@laurent-hasson.com
2022/02/27 Re: slow query to improve performace Jeff Janes
2022/02/27 Re: Never Ending query in PostgreSQL Jeff Janes
2022/02/27 Re: Never Ending query in PostgreSQL Julien Rouhaud
2022/02/27 Never Ending query in PostgreSQL Kumar, Mukesh
2022/02/25 Re: slow query to improve performace Justin Pryzby
2022/02/25 slow query to improve performace Ayub Khan
2022/02/25 RE: Slow Running Queries in Azure PostgreSQL Kumar, Mukesh
2022/02/25 Re: An I/O error occurred while sending to the backend (PG 13.4) Justin Pryzby
2022/02/24 Re: Slow plan choice with prepared query MichaelDBA
2022/02/24 Re: Slow plan choice with prepared query MichaelDBA
2022/02/24 Re: Advice needed: query performance deteriorates by 2000% within 1 minute Tom Lane
2022/02/24 Re: Advice needed: query performance deteriorates by 2000% within 1 minute Michael Lewis
2022/02/24 Advice needed: query performance deteriorates by 2000% within 1 minute Peter Adlersburg
2022/02/24 Re: An I/O error occurred while sending to the backend (PG 13.4) Ranier Vilela
2022/02/24 Re: An I/O error occurred while sending to the backend (PG 13.4) Justin Pryzby
2022/02/24 Re: An I/O error occurred while sending to the backend (PG 13.4) Ranier Vilela
2022/02/23 Slow plan choice with prepared query Mark Saward
2022/02/23 Re: An I/O error occurred while sending to the backend (PG 13.4) Justin Pryzby
2022/02/23 Re: An I/O error occurred while sending to the backend (PG 13.4) Justin Pryzby
2022/02/23 RE: An I/O error occurred while sending to the backend (PG 13.4) l...@laurent-hasson.com
2022/02/22 Re: Slow Running Queries in Azure PostgreSQL Justin Pryzby
2022/02/18 Re: Poor performance PostgreSQL 13/ PostGIS 3.x Merlin Moncure
2022/02/09 Re: Query chooses Bad Index Path Tomas Vondra
2022/02/08 Query chooses Bad Index Path Valli Annamalai
2022/02/08 Re: Query choosing Bad Index Path (ASC/DESC ordering). Mind Body Nature
2022/02/07 Query choosing Bad Index Path (ASC/DESC ordering). Valli Annamalai
2022/02/07 Re: slow "select count(*) from information_schema.tables;" in some cases Imre Samu
2022/02/07 Re: slow "select count(*) from information_schema.tables;" in some cases Lars Aksel Opsahl
2022/02/07 Re: slow "select count(*) from information_schema.tables;" in some cases Tom Lane
2022/02/07 Re: slow "select count(*) from information_schema.tables;" in some cases Lars Aksel Opsahl
2022/02/07 Re: slow "select count(*) from information_schema.tables;" in some cases Vijaykumar Jain
2022/02/07 Re: slow "select count(*) from information_schema.tables;" in some cases Lars Aksel Opsahl
2022/02/07 Re: slow "select count(*) from information_schema.tables;" in some cases Justin Pryzby
2022/02/07 slow "select count(*) from information_schema.tables;" in some cases Lars Aksel Opsahl
2022/02/05 Re: Terribly slow query with very good plan? Vijaykumar Jain
2022/02/04 Re: Terribly slow query with very good plan? Les
2022/02/04 Re: Terribly slow query with very good plan? Thomas Kellerer
2022/02/04 Re: Terribly slow query with very good plan? Nick Cleaton
2022/02/04 Re: Terribly slow query with very good plan? Les
2022/02/04 Re: Terribly slow query with very good plan? Nick Cleaton
2022/02/04 Re: Terribly slow query with very good plan? Ninad Shah
2022/02/04 Re: Terribly slow query with very good plan? Les
2022/02/04 Re: Terribly slow query with very good plan? Nick Cleaton
2022/02/04 Re: Terribly slow query with very good plan? Les
2022/02/04 Re: Terribly slow query with very good plan? Nick Cleaton
2022/02/04 Re: Terribly slow query with very good plan? Les
2022/02/04 Re: Terribly slow query with very good plan? Nick Cleaton
2022/02/04 Re: Terribly slow query with very good plan? Les
2022/02/04 Re: Terribly slow query with very good plan? Les
2022/02/04 Re: Terribly slow query with very good plan? Les
2022/02/04 Re: Terribly slow query with very good plan? Les
2022/02/04 Re: Terribly slow query with very good plan? Nick Cleaton
2022/02/04 Re: Terribly slow query with very good plan? Les
2022/02/04 Re: Terribly slow query with very good plan? Pavel Stehule
2022/02/04 Re: Terribly slow query with very good plan? Laurenz Albe
2022/02/04 Terribly slow query with very good plan? Les
2022/01/25 Query runs slower as prepared statement - identical execution plans Thomas Kellerer
2022/01/24 Re: Slow query fixed by replacing equality with a nested query Michael Lewis
2022/01/24 Re: Slow query fixed by replacing equality with a nested query Michael Lewis
2022/01/24 Re: Slow query fixed by replacing equality with a nested query Valentin Janeiko
2022/01/21 RE: Slow query fixed by replacing equality with a nested query val.janeiko
2022/01/20 Re: Slow query fixed by replacing equality with a nested query Michael Lewis
2022/01/20 Re: PostgreSQL and Linux CPU's David G. Johnston
2022/01/20 PostgreSQL and Linux CPU's Sbob
2022/01/20 Poor performance PostgreSQL 13/ PostGIS 3.x Lugosi, Jim
2022/01/20 Slow query fixed by replacing equality with a nested query Valentin Janeiko
2022/01/20 RE: PostgreSQL 12.8 Same Query Same Execution Plan Different Time Michel SALAIS
2022/01/19 Re: PostgreSQL 12.8 Same Query Same Execution Plan Different Time David G. Johnston
2022/01/19 PostgreSQL 12.8 Same Query Same Execution Plan Different Time Ludwig Isaac Lim
2022/01/18 Re: Unique constraint blues David G. Johnston
2022/01/18 Unique constraint blues Mladen Gogala
2022/01/18 Re: PostgreSQLv14 TPC-H performance GCC vs Clang arjun shetty
2022/01/12 PGBench connection issue with -C option only T T