pgsql-performance

Messages by Date

2020/06/14 Re: Performance issue Justin Pryzby
2020/06/14 Re: Performance issue David Rowley
2020/06/14 Performance issue Nagaraj Raj
2020/06/13 Re: view reading information_schema is slow in PostgreSQL 12 Tom Lane
2020/06/13 Re: view reading information_schema is slow in PostgreSQL 12 David Rowley
2020/06/13 Re: view reading information_schema is slow in PostgreSQL 12 David Rowley
2020/06/12 Re: view reading information_schema is slow in PostgreSQL 12 Pavel Stehule
2020/06/12 Re: view reading information_schema is slow in PostgreSQL 12 Pavel Stehule
2020/06/12 Re: view reading information_schema is slow in PostgreSQL 12 Pavel Stehule
2020/06/12 Re: view reading information_schema is slow in PostgreSQL 12 Justin Pryzby
2020/06/12 Re: view reading information_schema is slow in PostgreSQL 12 Tom Lane
2020/06/12 Re: view reading information_schema is slow in PostgreSQL 12 David Rowley
2020/06/12 Re: view reading information_schema is slow in PostgreSQL 12 David Rowley
2020/06/12 Re: view reading information_schema is slow in PostgreSQL 12 Tom Lane
2020/06/12 Re: view reading information_schema is slow in PostgreSQL 12 Imre Samu
2020/06/12 view reading information_schema is slow in PostgreSQL 12 regrog
2020/06/10 Re: Windows slowness? Mikkel Lauritsen
2020/06/10 Re: Windows slowness? David Rowley
2020/06/10 Re: Windows slowness? mountain the blue
2020/06/10 Windows slowness? Mikkel Lauritsen
2020/06/09 Re: Postgresql server gets stuck at low load Justin Pryzby
2020/06/09 Re: Postgresql server gets stuck at low load Krzysztof Olszewski
2020/06/09 Re: Postgresql server gets stuck at low load Avinash Kumar
2020/06/09 Re: Postgresql server gets stuck at low load Krzysztof Olszewski
2020/06/09 Re: Postgresql server gets stuck at low load Krzysztof Olszewski
2020/06/08 Re: When to use PARTITION BY HASH? michael...@sqlexec.com
2020/06/07 Re: When to use PARTITION BY HASH? David Rowley
2020/06/07 Re: When to use PARTITION BY HASH? MichaelDBA
2020/06/05 Re: Date vs Timestamp without timezone Partition Key Cedric Leong
2020/06/05 Re: Date vs Timestamp without timezone Partition Key David Rowley
2020/06/05 Re: Date vs Timestamp without timezone Partition Key Cedric Leong
2020/06/05 Re: Date vs Timestamp without timezone Partition Key David Rowley
2020/06/05 Re: Date vs Timestamp without timezone Partition Key Cedric Leong
2020/06/05 Re: When to use PARTITION BY HASH? Imre Samu
2020/06/05 Re: Postgresql server gets stuck at low load Pavel Stehule
2020/06/05 Re: Postgresql server gets stuck at low load luis . roberto
2020/06/05 Postgresql server gets stuck at low load Krzysztof Olszewski
2020/06/04 Re: increased max_parallel_workers_per_gather results in fewer workers? Philip Semanchuk
2020/06/04 Re: increased max_parallel_workers_per_gather results in fewer workers? Sebastian Dressler
2020/06/04 Re: increased max_parallel_workers_per_gather results in fewer workers? Philip Semanchuk
2020/06/04 Re: increased max_parallel_workers_per_gather results in fewer workers? Sebastian Dressler
2020/06/04 Re: increased max_parallel_workers_per_gather results in fewer workers? Philip Semanchuk
2020/06/04 Re: increased max_parallel_workers_per_gather results in fewer workers? Magnus Hagander
2020/06/04 Re: increased max_parallel_workers_per_gather results in fewer workers? Tomas Vondra
2020/06/03 Re: increased max_parallel_workers_per_gather results in fewer workers? Luis Carril
2020/06/03 Re: increased max_parallel_workers_per_gather results in fewer workers? Sebastian Dressler
2020/06/03 Re: increased max_parallel_workers_per_gather results in fewer workers? Justin Pryzby
2020/06/03 Re: increased max_parallel_workers_per_gather results in fewer workers? Philip Semanchuk
2020/06/03 Re: increased max_parallel_workers_per_gather results in fewer workers? Justin Pryzby
2020/06/03 increased max_parallel_workers_per_gather results in fewer workers? Philip Semanchuk
2020/06/03 Re: When to use PARTITION BY HASH? Justin Pryzby
2020/06/03 Re: When to use PARTITION BY HASH? Oleksandr Shulgin
2020/06/02 Re: When to use PARTITION BY HASH? Michel Pelletier
2020/06/02 Re: When to use PARTITION BY HASH? David G. Johnston
2020/06/02 Re: When to use PARTITION BY HASH? MichaelDBA
2020/06/02 Re: When to use PARTITION BY HASH? Justin Pryzby
2020/06/02 When to use PARTITION BY HASH? Oleksandr Shulgin
2020/06/01 Re: Configuration Filip Rembiałkowski
2020/06/01 Configuration sugnathi hai
2020/05/30 Re: Performance tunning Jeff Janes
2020/05/30 Re: Performance tunning Justin Pryzby
2020/05/30 Re: Performance tunning Pavel Stehule
2020/05/30 Performance tunning sugnathi hai
2020/05/28 Re: PostgreSQL performance problem moving from 9.6.17 to 12.3 Tom Lane
2020/05/28 PostgreSQL performance problem moving from 9.6.17 to 12.3 Kenneth Marshall
2020/05/24 Re: Request to help on Query improvement suggestion. Laurenz Albe
2020/05/24 Re: Date vs Timestamp without timezone Partition Key Tom Lane
2020/05/24 Date vs Timestamp without timezone Partition Key Cedric Leong
2020/05/22 Strategy for materialisation and centralisation of data Rory Campbell-Lange
2020/05/22 Re: Request to help on GIS Query improvement suggestion. Michael Lewis
2020/05/22 Request to help on Query improvement suggestion. devchef2020 d
2020/05/22 Request to help on GIS Query improvement suggestion. postggen2020 s
2020/05/22 Re: Suggestion to improve query performance for GIS query. postgann2020 s
2020/05/22 Re: Suggestion to improve query performance for GIS query. Mohammed Afsar
2020/05/22 Re: Suggestion to improve query performance for GIS query. David G. Johnston
2020/05/22 Suggestion to improve query performance for GIS query. postgann2020 s
2020/05/21 Suggestion to improve query performance of data validation in proc. postgann2020 s
2020/05/21 Re: Suggestion on index creation for TEXT data field postgann2020 s
2020/05/21 Re: Suggestion on index creation for TEXT data field David G. Johnston
2020/05/21 Re: Suggestion on table analyze postgann2020 s
2020/05/21 Re: Suggestion on index creation for TEXT data field Adrian Klaver
2020/05/21 Re: Suggestion on index creation for TEXT data field postgann2020 s
2020/05/21 Re: Suggestion on table analyze Adrian Klaver
2020/05/21 Re: Suggestion on index creation for TEXT data field David G. Johnston
2020/05/21 Suggestion on index creation for TEXT data field postgann2020 s
2020/05/21 Suggestion on table analyze postgann2020 s
2020/05/20 Suggestion to improve query performance. postgann2020 s
2020/05/20 Re: OOM Killer kills PostgreSQL Stephen Frost
2020/05/20 Re: OOM Killer kills PostgreSQL Justin Pryzby
2020/05/20 Re: OOM Killer kills PostgreSQL Fabio Pardi
2020/05/20 Re: OOM Killer kills PostgreSQL Piotr Włodarczyk
2020/05/20 Re: OOM Killer kills PostgreSQL Laurenz Albe
2020/05/20 OOM Killer kills PostgreSQL Piotr Włodarczyk
2020/05/18 Re: Execution time from >1s -> 80m+ when extra columns added in SELECT for sub-query Tom Lane
2020/05/18 Re: Execution time from >1s -> 80m+ when extra columns added in SELECT for sub-query A Guy Named Ryan
2020/05/18 Re: Execution time from >1s -> 80m+ when extra columns added in SELECT for sub-query Pavel Stehule
2020/05/17 Re: Plan not skipping unnecessary inner join Ranier Vilela
2020/05/17 Re: Plan not skipping unnecessary inner join Justin Pryzby
2020/05/17 Re: Plan not skipping unnecessary inner join Ranier Vilela
2020/05/15 Re: Plan not skipping unnecessary inner join Matthew Nelson
2020/05/13 Re: Plan not skipping unnecessary inner join David Wheeler
2020/05/13 Plan not skipping unnecessary inner join Matthew Nelson
2020/05/13 Re: Please help! Query jumps from 1s -> 4m James Thompson
2020/05/13 Re: Inaccurate Rows estimate for "Bitmap And" causes Planner to choose wrong join Steve Pritchard
2020/05/12 Re: AutoVacuum and growing transaction XID's github kran
2020/05/09 Re: 600 million rows of data. Bad hardware or need partitioning? Arya F
2020/05/08 Re: AutoVacuum and growing transaction XID's Michael Lewis
2020/05/08 Re: pg_attribute, pg_class, pg_depend grow huge in count and size with multiple tenants. Jeff Janes
2020/05/08 Re: pg_attribute, pg_class, pg_depend grow huge in count and size with multiple tenants. Jeff Janes
2020/05/08 Re: pg_attribute, pg_class, pg_depend grow huge in count and size with multiple tenants. MichaelDBA
2020/05/08 Re: pg_attribute, pg_class, pg_depend grow huge in count and size with multiple tenants. Avinash Kumar
2020/05/07 Re: pg_attribute, pg_class, pg_depend grow huge in count and size with multiple tenants. Laurenz Albe
2020/05/07 Re: pg_attribute, pg_class, pg_depend grow huge in count and size with multiple tenants. Avinash Kumar
2020/05/07 Re: pg_attribute, pg_class, pg_depend grow huge in count and size with multiple tenants. Laurenz Albe
2020/05/07 Re: AutoVacuum and growing transaction XID's github kran
2020/05/07 Re: AutoVacuum and growing transaction XID's github kran
2020/05/07 Re: AutoVacuum and growing transaction XID's David Rowley
2020/05/07 Re: AutoVacuum and growing transaction XID's David Rowley
2020/05/07 Re: AutoVacuum and growing transaction XID's github kran
2020/05/07 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) David Rowley
2020/05/07 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) David G. Johnston
2020/05/07 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Tom Lane
2020/05/07 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) David G. Johnston
2020/05/07 Re: AutoVacuum and growing transaction XID's github kran
2020/05/07 Re: pg_attribute, pg_class, pg_depend grow huge in count and size with multiple tenants. Avinash Kumar
2020/05/07 Re: pg_attribute, pg_class, pg_depend grow huge in count and size with multiple tenants. Rory Campbell-Lange
2020/05/07 Re: pg_attribute, pg_class, pg_depend grow huge in count and size with multiple tenants. Avinash Kumar
2020/05/07 Re: pg_attribute, pg_class, pg_depend grow huge in count and size with multiple tenants. David G. Johnston
2020/05/07 pg_attribute, pg_class, pg_depend grow huge in count and size with multiple tenants. samhitha g
2020/05/07 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Virendra Kumar
2020/05/07 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Adrian Klaver
2020/05/07 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Amarendra Konda
2020/05/07 Re: AutoVacuum and growing transaction XID's Michael Lewis
2020/05/07 AutoVacuum and growing transaction XID's github kran
2020/05/07 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Amarendra Konda
2020/05/07 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Amarendra Konda
2020/05/07 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Amarendra Konda
2020/05/07 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) David G. Johnston
2020/05/07 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Adrian Klaver
2020/05/07 Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Amarendra Konda
2020/05/06 Re: Inaccurate Rows estimate for "Bitmap And" causes Planner to choose wrong join Jeff Janes
2020/05/06 Re: Inaccurate Rows estimate for "Bitmap And" causes Planner to choose wrong join Justin Pryzby
2020/05/06 Inaccurate Rows estimate for "Bitmap And" causes Planner to choose wrong join Steve Pritchard
2020/05/05 Re: 600 million rows of data. Bad hardware or need partitioning? Justin Pryzby
2020/05/05 Re: 600 million rows of data. Bad hardware or need partitioning? Arya F
2020/05/05 Re: 600 million rows of data. Bad hardware or need partitioning? Arya F
2020/05/05 Re: Please help! Query jumps from 1s -> 4m Tom Lane
2020/05/05 Re: Please help! Query jumps from 1s -> 4m Justin Pryzby
2020/05/05 Re: Please help! Query jumps from 1s -> 4m James Thompson
2020/05/05 Re: Please help! Query jumps from 1s -> 4m Justin Pryzby
2020/05/05 Re: NUMA settings Laurenz Albe
2020/05/05 Re: NUMA settings Marc Rechté
2020/05/05 Re: Please help! Query jumps from 1s -> 4m Laurenz Albe
2020/05/05 Re: NUMA settings Laurenz Albe
2020/05/04 Re: NUMA settings Marc Rechté
2020/05/04 Re: good book or any other resources for Postgresql Bhupendra Babu
2020/05/04 Re: good book or any other resources for Postgresql Craig Jackson
2020/05/04 Re: good book or any other resources for Postgresql Michael Lewis
2020/05/04 good book or any other resources for Postgresql Bhupendra Babu
2020/05/04 Re: Please help! Query jumps from 1s -> 4m James Thompson
2020/05/04 Re: Please help! Query jumps from 1s -> 4m David Rowley
2020/05/04 Re: Please help! Query jumps from 1s -> 4m Justin Pryzby
2020/05/04 Re: Duplicate WHERE condition changes performance and plan Michael Lewis
2020/05/04 Re: Recursive query slow on strange conditions Jean-Christophe Boggio
2020/05/04 Re: NUMA settings Andres Freund
2020/05/04 Re: Recursive query slow on strange conditions David G. Johnston
2020/05/04 Re: Recursive query slow on strange conditions Jean-Christophe Boggio
2020/05/04 Re: 600 million rows of data. Bad hardware or need partitioning? Justin Pryzby
2020/05/03 Re: 600 million rows of data. Bad hardware or need partitioning? David Rowley
2020/05/03 Re: 600 million rows of data. Bad hardware or need partitioning? Arya F
2020/05/03 Re: 600 million rows of data. Bad hardware or need partitioning? Michael Lewis
2020/05/03 600 million rows of data. Bad hardware or need partitioning? Arya F
2020/05/03 Re: Please help! Query jumps from 1s -> 4m Justin Pryzby
2020/05/03 Please help! Query jumps from 1s -> 4m James Thompson
2020/05/03 Re: Duplicate WHERE condition changes performance and plan singh...@gmail.com
2020/05/02 Re: Best partition type for billions of addresses Stephen Frost
2020/05/02 Re: Best partition type for billions of addresses Arya F
2020/05/02 Re: Best partition type for billions of addresses Stephen Frost
2020/05/02 Re: Best partition type for billions of addresses Justin Pryzby
2020/05/02 Best partition type for billions of addresses Arya F
2020/04/30 Re: The query plan get all columns but I'm using only one column. Moises Lopez
2020/04/30 Re: The query plan get all columns but I'm using only one column. Michael Lewis
2020/04/29 Re: The query plan get all columns but I'm using only one column. Michael Lewis
2020/04/29 Re: NUMA settings Laurenz Albe
2020/04/28 NUMA settings Marc Rechté
2020/04/27 Re: Recursive query slow on strange conditions Jean-Christophe Boggio
2020/04/27 Re: Recursive query slow on strange conditions Andreas Joseph Krogh
2020/04/27 Re: Recursive query slow on strange conditions Justin Pryzby
2020/04/27 Recursive query slow on strange conditions Jean-Christophe Boggio
2020/04/25 Re: The query plan get all columns but I'm using only one column. Michael Lewis
2020/04/25 Re: PostgreSQL does not choose my indexes well Arcadio Ortega Reinoso
2020/04/25 Re: The query plan get all columns but I'm using only one column. Tom Lane
2020/04/25 Re: PostgreSQL does not choose my indexes well Stephen Frost
2020/04/25 The query plan get all columns but I'm using only one column. Moises Lopez
2020/04/24 Re: PostgreSQL does not choose my indexes well Jeff Janes
2020/04/24 Re: PostgreSQL does not choose my indexes well Tom Lane
2020/04/24 Re: PostgreSQL does not choose my indexes well Stephen Frost
2020/04/24 Re: PostgreSQL does not choose my indexes well Jeff Janes
2020/04/24 Re: Duplicate WHERE condition changes performance and plan singh...@gmail.com
2020/04/23 Re: PostgreSQL does not choose my indexes well Arcadio Ortega Reinoso

Later messages