pgsql-performance since 2020-04-10 00:00

Discussion of PostgreSQL's performance issues. Please see Guide to reporting problems and Slow Query Questions for some tips on how to write your performance question.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next

April 10, 2020

Thread Author Time
Re: proposal: schema variables 📎 Pavel Stehule 17:30

April 13, 2020

Thread Author Time
High kswapd Don Seiler 14:34
Re: High kswapd Justin Pryzby 14:42
Re: High kswapd Don Seiler 14:46
Re: High kswapd Justin Pryzby 14:58
Re: PostgreSQL DBA consulting Amol Tarte 15:04
Re: High kswapd Don Seiler 15:08

April 15, 2020

Thread Author Time
Duplicate WHERE condition changes performance and plan singh400@gmail.com 19:55
Using unlogged tables for web sessions Stephen Carboni 22:53
Re: Duplicate WHERE condition changes performance and plan David Rowley 23:57

April 17, 2020

Thread Author Time
RE: Postgres not using index on views Rick Vincent 14:28
Postgres not using index on views David G. Johnston 14:55
RE: Postgres not using index on views Rick Vincent 15:12

April 20, 2020

Thread Author Time
Re: Duplicate WHERE condition changes performance and plan singh400@gmail.com 00:50
Re: Duplicate WHERE condition changes performance and plan Justin Pryzby 02:33
RE: Postgres not using index on views Rick Vincent 11:10

April 23, 2020

Thread Author Time
PostgreSQL does not choose my indexes well Arcadio Ortega Reinoso 11:36
Re: PostgreSQL does not choose my indexes well Thomas Kellerer 11:43
Re: PostgreSQL does not choose my indexes well David G. Johnston 13:57
Re: PostgreSQL does not choose my indexes well Tom Lane 15:29
Re: PostgreSQL does not choose my indexes well Michael Lewis 16:20
Re: PostgreSQL does not choose my indexes well Tom Lane 16:31
Re: PostgreSQL does not choose my indexes well David G. Johnston 16:50
Re: PostgreSQL does not choose my indexes well Stephen Frost 17:18
Re: PostgreSQL does not choose my indexes well Stephen Frost 17:20
Re: PostgreSQL does not choose my indexes well Tom Lane 17:56
Re: PostgreSQL does not choose my indexes well Stephen Frost 20:01
Re: PostgreSQL does not choose my indexes well Tom Lane 20:33
Re: PostgreSQL does not choose my indexes well David G. Johnston 20:36
Re: PostgreSQL does not choose my indexes well Tom Lane 20:45
Re: PostgreSQL does not choose my indexes well Arcadio Ortega Reinoso 21:01

April 24, 2020

Thread Author Time
Re: Duplicate WHERE condition changes performance and plan singh400@gmail.com 16:33
Re: PostgreSQL does not choose my indexes well Jeff Janes 18:26
Re: PostgreSQL does not choose my indexes well Stephen Frost 18:33
Re: PostgreSQL does not choose my indexes well Tom Lane 19:39
The query plan get all columns but I'm using only one column. Moises Lopez 21:11
Re: PostgreSQL does not choose my indexes well Jeff Janes 22:59

April 25, 2020

Thread Author Time
Re: PostgreSQL does not choose my indexes well Stephen Frost 12:02
Re: The query plan get all columns but I'm using only one column. Tom Lane 14:24
Re: PostgreSQL does not choose my indexes well Arcadio Ortega Reinoso 19:47
Re: The query plan get all columns but I'm using only one column. Michael Lewis 20:40

April 27, 2020

Thread Author Time
Recursive query slow on strange conditions Jean-Christophe Boggio 17:49
Re: Recursive query slow on strange conditions Justin Pryzby 18:10
Re: Recursive query slow on strange conditions Andreas Joseph Krogh 19:37
Re: Recursive query slow on strange conditions Jean-Christophe Boggio 20:22

April 29, 2020

Thread Author Time
NUMA settings Marc Rechté 06:54
Re: NUMA settings Laurenz Albe 08:50
Re: The query plan get all columns but I'm using only one column. 📎 Moises Lopez 19:21
Re: The query plan get all columns but I'm using only one column. Michael Lewis 19:36

April 30, 2020

Thread Author Time
Re: The query plan get all columns but I'm using only one column. Michael Lewis 15:52
Re: The query plan get all columns but I'm using only one column. Moises Lopez 16:26

May 2, 2020

Thread Author Time
Best partition type for billions of addresses Arya F 13:20
Re: Best partition type for billions of addresses Justin Pryzby 14:00
Re: Best partition type for billions of addresses Stephen Frost 14:01
Re: Best partition type for billions of addresses Arya F 14:33
Re: Best partition type for billions of addresses Stephen Frost 14:39

May 3, 2020

Thread Author Time
Please help! Query jumps from 1s -> 4m James Thompson 08:58
Re: Duplicate WHERE condition changes performance and plan singh400@gmail.com 11:39
Re: Please help! Query jumps from 1s -> 4m Justin Pryzby 15:38

May 4, 2020

Thread Author Time
600 million rows of data. Bad hardware or need partitioning? Arya F 03:27
Re: 600 million rows of data. Bad hardware or need partitioning? Michael Lewis 03:45
Re: 600 million rows of data. Bad hardware or need partitioning? Arya F 03:51
Re: 600 million rows of data. Bad hardware or need partitioning? David Rowley 04:44
Re: 600 million rows of data. Bad hardware or need partitioning? Justin Pryzby 09:21
Re: Recursive query slow on strange conditions Jean-Christophe Boggio 16:12
Re: Recursive query slow on strange conditions David G. Johnston 16:20
Re: NUMA settings Andres Freund 16:20
Re: Recursive query slow on strange conditions Jean-Christophe Boggio 16:25
Re: Duplicate WHERE condition changes performance and plan Michael Lewis 17:11
Re: Please help! Query jumps from 1s -> 4m Justin Pryzby 19:12
Re: Please help! Query jumps from 1s -> 4m James Thompson 19:12
Re: Please help! Query jumps from 1s -> 4m David Rowley 20:12
good book or any other resources for Postgresql Bhupendra Babu 22:45
Re: good book or any other resources for Postgresql Michael Lewis 23:41
Re: good book or any other resources for Postgresql Craig Jackson 23:45

May 5, 2020

Thread Author Time
Re: good book or any other resources for Postgresql Bhupendra Babu 03:37
Re: NUMA settings Marc Rechté 05:56
Re: NUMA settings Laurenz Albe 08:00
Re: Please help! Query jumps from 1s -> 4m Laurenz Albe 08:08
Re: NUMA settings Marc Rechté 08:11
Re: NUMA settings Laurenz Albe 08:25
Re: Please help! Query jumps from 1s -> 4m Justin Pryzby 19:28
Re: Please help! Query jumps from 1s -> 4m James Thompson 21:10
Re: Please help! Query jumps from 1s -> 4m Justin Pryzby 21:35
Re: Please help! Query jumps from 1s -> 4m Tom Lane 21:42

May 6, 2020

Thread Author Time
Re: 600 million rows of data. Bad hardware or need partitioning? Arya F 00:15
Re: 600 million rows of data. Bad hardware or need partitioning? Arya F 00:31
Re: 600 million rows of data. Bad hardware or need partitioning? Justin Pryzby 01:37
Inaccurate Rows estimate for "Bitmap And" causes Planner to choose wrong join Steve Pritchard 16:19
Re: Inaccurate Rows estimate for "Bitmap And" causes Planner to choose wrong join Justin Pryzby 16:34
Re: Inaccurate Rows estimate for "Bitmap And" causes Planner to choose wrong join Jeff Janes 18:24

May 7, 2020

Thread Author Time
Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Amarendra Konda 11:19
Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Adrian Klaver 14:40
Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) David G. Johnston 15:46
pg_attribute, pg_class, pg_depend grow huge in count and size with multiple tenants. samhitha g 17:10
Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Amarendra Konda 17:36
Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Amarendra Konda 17:49
Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Amarendra Konda 18:07
AutoVacuum and growing transaction XID's github kran 18:23
Re: AutoVacuum and growing transaction XID's Michael Lewis 18:32
Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Amarendra Konda 18:51
Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Adrian Klaver 19:25
Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Virendra Kumar 19:30
Re: pg_attribute, pg_class, pg_depend grow huge in count and size with multiple tenants. David G. Johnston 20:17
Re: pg_attribute, pg_class, pg_depend grow huge in count and size with multiple tenants. Avinash Kumar 20:28
Re: pg_attribute, pg_class, pg_depend grow huge in count and size with multiple tenants. Rory Campbell-Lange 21:08
Re: pg_attribute, pg_class, pg_depend grow huge in count and size with multiple tenants. Avinash Kumar 21:17
Re: AutoVacuum and growing transaction XID's github kran 21:18
Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) David G. Johnston 21:21
Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Tom Lane 21:26
Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) David G. Johnston 21:59
Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) David Rowley 23:46

May 8, 2020

Thread Author Time
Re: AutoVacuum and growing transaction XID's github kran 01:51
Re: AutoVacuum and growing transaction XID's David Rowley 04:01
Re: AutoVacuum and growing transaction XID's David Rowley 04:04
Re: AutoVacuum and growing transaction XID's github kran 06:06
Re: AutoVacuum and growing transaction XID's github kran 06:17
Re: pg_attribute, pg_class, pg_depend grow huge in count and size with multiple tenants. Laurenz Albe 06:31
Re: pg_attribute, pg_class, pg_depend grow huge in count and size with multiple tenants. Avinash Kumar 06:47
Re: pg_attribute, pg_class, pg_depend grow huge in count and size with multiple tenants. Laurenz Albe 06:53
Re: pg_attribute, pg_class, pg_depend grow huge in count and size with multiple tenants. Avinash Kumar 10:14
Re: pg_attribute, pg_class, pg_depend grow huge in count and size with multiple tenants. MichaelDBA 13:01
Re: pg_attribute, pg_class, pg_depend grow huge in count and size with multiple tenants. Jeff Janes 13:44
Re: pg_attribute, pg_class, pg_depend grow huge in count and size with multiple tenants. Jeff Janes 13:54
Re: AutoVacuum and growing transaction XID's Michael Lewis 21:11

May 10, 2020

Thread Author Time
Re: 600 million rows of data. Bad hardware or need partitioning? Arya F 04:10

May 12, 2020

Thread Author Time
Re: AutoVacuum and growing transaction XID's github kran 15:40

May 13, 2020

Thread Author Time
Re: Inaccurate Rows estimate for "Bitmap And" causes Planner to choose wrong join Steve Pritchard 09:33
Re: Please help! Query jumps from 1s -> 4m James Thompson 14:17

May 14, 2020

Thread Author Time
Plan not skipping unnecessary inner join Matthew Nelson 05:44
Re: Plan not skipping unnecessary inner join David Wheeler 06:45

May 15, 2020

Thread Author Time
Re: Plan not skipping unnecessary inner join Matthew Nelson 17:36

May 17, 2020

Thread Author Time
Re: Plan not skipping unnecessary inner join Ranier Vilela 12:32
Re: Plan not skipping unnecessary inner join Justin Pryzby 13:31
Re: Plan not skipping unnecessary inner join Ranier Vilela 14:05

May 18, 2020

Thread Author Time
Execution time from >1s -> 80m+ when extra columns added in SELECT for sub-query 📎 A Guy Named Ryan 18:42
Re: Execution time from >1s -> 80m+ when extra columns added in SELECT for sub-query Pavel Stehule 19:17
Re: Execution time from >1s -> 80m+ when extra columns added in SELECT for sub-query A Guy Named Ryan 20:49
Re: Execution time from >1s -> 80m+ when extra columns added in SELECT for sub-query Tom Lane 21:58

May 20, 2020

Thread Author Time
OOM Killer kills PostgreSQL Piotr Włodarczyk 07:30
Re: OOM Killer kills PostgreSQL Laurenz Albe 08:22
Re: OOM Killer kills PostgreSQL Piotr Włodarczyk 08:28
Re: OOM Killer kills PostgreSQL Fabio Pardi 08:40
Re: OOM Killer kills PostgreSQL Justin Pryzby 08:46
Re: OOM Killer kills PostgreSQL Stephen Frost 16:54
Suggestion to improve query performance. postgann2020 s 18:20

May 21, 2020

Thread Author Time
Re: proposal: schema variables Pavel Stehule 10:10
Re: proposal: schema variables Amit Kapila 11:34
Re: proposal: schema variables 📎 Pavel Stehule 12:49
Suggestion on table analyze postgann2020 s 14:18
Suggestion on index creation for TEXT data field postgann2020 s 14:27
Re: Suggestion on index creation for TEXT data field David G. Johnston 14:36
Re: Suggestion on table analyze Adrian Klaver 14:41
Re: Suggestion on index creation for TEXT data field postgann2020 s 14:44
Re: Suggestion on index creation for TEXT data field Adrian Klaver 14:45
Re: Suggestion on table analyze postgann2020 s 14:48
Re: Suggestion on index creation for TEXT data field David G. Johnston 14:51
Re: Suggestion on index creation for TEXT data field postgann2020 s 14:53

May 22, 2020

Thread Author Time
Suggestion to improve query performance of data validation in proc. postgann2020 s 06:41
Suggestion to improve query performance for GIS query. postgann2020 s 06:59
Re: Suggestion to improve query performance of data validation in proc. David G. Johnston 07:06
Re: Suggestion to improve query performance for GIS query. David G. Johnston 07:14
Re: Suggestion to improve query performance for GIS query. Mohammed Afsar 07:16
Re: Suggestion to improve query performance for GIS query. postgann2020 s 07:34
Re: Suggestion to improve query performance of data validation in proc. postgann2020 s 07:44
Re: Suggestion to improve query performance of data validation in proc. David G. Johnston 08:09
Request to help on Query improvement suggestion. devchef2020 d 10:45
Request to help on GIS Query improvement suggestion. postggen2020 s 10:53
Re: Request to help on GIS Query improvement suggestion. Michael Lewis 14:14
Re: Suggestion to improve query performance of data validation in proc. Michael Lewis 14:26
Strategy for materialisation and centralisation of data Rory Campbell-Lange 14:48

May 25, 2020

Thread Author Time
Date vs Timestamp without timezone Partition Key Cedric Leong 03:50
Re: Date vs Timestamp without timezone Partition Key Tom Lane 04:48
Re: Request to help on Query improvement suggestion. Laurenz Albe 06:47

May 28, 2020

Thread Author Time
PostgreSQL performance problem moving from 9.6.17 to 12.3 Kenneth Marshall 15:56
Re: PostgreSQL performance problem moving from 9.6.17 to 12.3 Tom Lane 16:42

May 30, 2020

Thread Author Time
Performance tunning sugnathi hai 07:36
Re: Performance tunning Pavel Stehule 07:43
Re: Performance tunning Justin Pryzby 14:19
Re: Performance tunning Jeff Janes 14:55

June 1, 2020

Thread Author Time
Configuration sugnathi hai 12:09
Re: Configuration Filip Rembiałkowski 13:24

June 2, 2020

Thread Author Time
When to use PARTITION BY HASH? Oleksandr Shulgin 17:17
Re: When to use PARTITION BY HASH? Justin Pryzby 17:33
Re: When to use PARTITION BY HASH? MichaelDBA 17:39
Re: When to use PARTITION BY HASH? David G. Johnston 17:43
Re: When to use PARTITION BY HASH? Michel Pelletier 17:45
Re: When to use PARTITION BY HASH? Stephen Frost 17:47

June 3, 2020

Thread Author Time
Re: When to use PARTITION BY HASH? Oleksandr Shulgin 07:38
Re: When to use PARTITION BY HASH? Oleksandr Shulgin 07:45
Re: When to use PARTITION BY HASH? Oleksandr Shulgin 11:55
Re: When to use PARTITION BY HASH? Justin Pryzby 15:09
increased max_parallel_workers_per_gather results in fewer workers? Philip Semanchuk 20:04
Re: increased max_parallel_workers_per_gather results in fewer workers? Justin Pryzby 21:15
Re: increased max_parallel_workers_per_gather results in fewer workers? Philip Semanchuk 22:23
Re: increased max_parallel_workers_per_gather results in fewer workers? Justin Pryzby 22:36

June 4, 2020

Thread Author Time
Re: increased max_parallel_workers_per_gather results in fewer workers? Sebastian Dressler 06:28
Re: increased max_parallel_workers_per_gather results in fewer workers? Luis Carril 06:41
Re: increased max_parallel_workers_per_gather results in fewer workers? Tomas Vondra 08:56
Re: increased max_parallel_workers_per_gather results in fewer workers? Magnus Hagander 09:30

Browse Archives

Prev | Next