pgsql-performance - May 2020

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
Jump to day: 1 2 3 4 5 6 7 8 10 12 13 14 15 17 18 20 21 22 25 28 30

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
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

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 10 12 13 14 15 17 18 20 21 22 25 28 30