pgsql-performance since 2020-04-02 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 2, 2020

Thread Author Time
BUG #16334: We recently upgraded PG version from 9.5 to 10.10 and system performance is not so good PG Bug reporting form 03:52
Re: BUG #16334: We recently upgraded PG version from 9.5 to 10.10 and system performance is not so good Julien Rouhaud 08:46
Re: BUG #16334: We recently upgraded PG version from 9.5 to 10.10 and system performance is not so good Tejaswini GC 10:22
Re: BUG #16334: We recently upgraded PG version from 9.5 to 10.10 and system performance is not so good Julien Rouhaud 11:04
Re: BUG #16334: We recently upgraded PG version from 9.5 to 10.10 and system performance is not so good Tejaswini GC 11:09
Could someone please help us share the procedure to troubleshoot the locks on proc issues. 📎 postgann2020 s 19:37
Re: Could someone please help us share the procedure to troubleshoot the locks on proc issues. Adrian Klaver 23:00

April 3, 2020

Thread Author Time
Re: Could someone please help us share the procedure to troubleshoot the locks on proc issues. postgann2020 s 05:11
slow query dangal 16:03
Re: slow query Justin Pryzby 16:07
Re: slow query dangal 16:18
Re: Increasing work_mem slows down query, why? Silvio Moioli 21:46

April 4, 2020

Thread Author Time
Re: BUG #16334: We recently upgraded PG version from 9.5 to 10.10 and system performance is not so good Tejaswini GC 06:27
Re: BUG #16334: We recently upgraded PG version from 9.5 to 10.10 and system performance is not so good Julien Rouhaud 07:06

April 5, 2020

Thread Author Time
Postgresql 12, 512 partition by hash. Slow select Arya F 17:48
Re: Postgresql 12, 512 partition by hash. Slow select Andreas Kretschmer 18:41
Re: Postgresql 12, 512 partition by hash. Slow select Tom Lane 18:55
Re: Postgresql 12, 512 partition by hash. Slow select Arya F 19:50
Re: Postgresql 12, 512 partition by hash. Slow select Neil 20:48

April 6, 2020

Thread Author Time
Postgres not using index on views Rick Vincent 14:19

April 7, 2020

Thread Author Time
Re: Postgres not using index on views Justin Pryzby 04:59
Re: Postgres not using index on views Tom Lane 05:09
Re: Postgres not using index on views Laurenz Albe 06:42
RE: Postgres not using index on views Rick Vincent 07:53
RE: Postgres not using index on views Rick Vincent 09:08
Re: Postgres not using index on views Thomas Kellerer 09:18
Re: Postgres not using index on views Thomas Kellerer 09:24
Re: slow query Michael Christofides 10:20
PostgreSQL DBA consulting daya airody 11:50
Re: PostgreSQL DBA consulting Justin Pryzby 11:56

April 9, 2020

Thread Author Time
High insert rate server, unstable insert latency and load peaks with buffer_content and XidGenLock LWlocks with Postgresql 12 version Maxim Boguk 14:51
Re: High insert rate server, unstable insert latency and load peaks with buffer_content and XidGenLock LWlocks with Postgresql 12 version Justin Pryzby 15:16
Re: High insert rate server, unstable insert latency and load peaks with buffer_content and XidGenLock LWlocks with Postgresql 12 version Maxim Boguk 15:29

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 [email protected] 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 [email protected] 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 [email protected] 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 [email protected] 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

Browse Archives

Prev | Next