Home > mailing lists

Mailing lists [pgsql-performance]

2 May 2020

16:20 Best partition type for billions of addresses Arya F
17:00 Re: Best partition type for billions of addresses Justin Pryzby
17:01 Re: Best partition type for billions of addresses Stephen Frost
17:33 Re: Best partition type for billions of addresses Arya F
17:39 Re: Best partition type for billions of addresses Stephen Frost

3 May 2020

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

4 May 2020

06:27 600 million rows of data. Bad hardware or need partitioning? Arya F
06:45 Re: 600 million rows of data. Bad hardware or need partitioning? Michael Lewis
06:51 Re: 600 million rows of data. Bad hardware or need partitioning? Arya F
07:44 Re: 600 million rows of data. Bad hardware or need partitioning? David Rowley
12:21 Re: 600 million rows of data. Bad hardware or need partitioning? Justin Pryzby
19:12 Re: Recursive query slow on strange conditions Jean-Christophe Boggio
19:20 Re: Recursive query slow on strange conditions David G. Johnston
19:20 Re: NUMA settings Andres Freund
19:25 Re: Recursive query slow on strange conditions Jean-Christophe Boggio
20:11 Re: Duplicate WHERE condition changes performance and plan Michael Lewis
22:12 Re: Please help! Query jumps from 1s -> 4m Justin Pryzby
22:12 Re: Please help! Query jumps from 1s -> 4m James Thompson
23:12 Re: Please help! Query jumps from 1s -> 4m David Rowley

5 May 2020

02:41 Re: good book or any other resources for Postgresql Michael Lewis
02:45 Re: good book or any other resources for Postgresql Craig Jackson
06:37 Re: good book or any other resources for Postgresql Bhupendra Babu
08:56 Re: NUMA settings Marc Rechté
11:00 Re: NUMA settings Laurenz Albe
11:08 Re: Please help! Query jumps from 1s -> 4m Laurenz Albe
11:11 Re: NUMA settings Marc Rechté
11:25 Re: NUMA settings Laurenz Albe
22:28 Re: Please help! Query jumps from 1s -> 4m Justin Pryzby

6 May 2020

00:10 Re: Please help! Query jumps from 1s -> 4m James Thompson
00:35 Re: Please help! Query jumps from 1s -> 4m Justin Pryzby
00:42 Re: Please help! Query jumps from 1s -> 4m Tom Lane
03:15 Re: 600 million rows of data. Bad hardware or need partitioning? Arya F
03:31 Re: 600 million rows of data. Bad hardware or need partitioning? Arya F
04:37 Re: 600 million rows of data. Bad hardware or need partitioning? Justin Pryzby
19:19 Inaccurate Rows estimate for "Bitmap And" causes Planner to choosewrong join Steve Pritchard
19:34 Re: Inaccurate Rows estimate for "Bitmap And" causes Planner tochoose wrong join Justin Pryzby
21:24 Re: Inaccurate Rows estimate for "Bitmap And" causes Planner tochoose wrong join Jeff Janes

7 May 2020

14:19 Explain plan changes - IN CLAUSE ( Passing direct values Vs INNERQuery ) Amarendra Konda
14:19 Explain plan changes - IN CLAUSE ( Passing direct values Vs INNERQuery ) Amarendra Konda
17:40 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNERQuery ) Adrian Klaver
17:40 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNERQuery ) Adrian Klaver
18:46 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNERQuery ) David G. Johnston
18:46 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNERQuery ) David G. Johnston
20:10 pg_attribute, pg_class, pg_depend grow huge in count and size withmultiple tenants. samhitha g
20:36 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNERQuery ) Amarendra Konda
20:36 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNERQuery ) Amarendra Konda
20:49 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNERQuery ) Amarendra Konda
20:49 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNERQuery ) Amarendra Konda
21:07 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNERQuery ) Amarendra Konda
21:07 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNERQuery ) Amarendra Konda
21:51 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNERQuery ) Amarendra Konda
21:51 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNERQuery ) Amarendra Konda
22:25 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNERQuery ) Adrian Klaver
22:25 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNERQuery ) Adrian Klaver
22:30 Re: Explain plan changes - IN CLAUSE ( Passing direct values VsINNER Query ) Virendra Kumar
22:30 Re: Explain plan changes - IN CLAUSE ( Passing direct values VsINNER Query ) Virendra Kumar
23:17 Re: pg_attribute, pg_class, pg_depend grow huge in count and sizewith multiple tenants. David G. Johnston
23:28 Re: pg_attribute, pg_class, pg_depend grow huge in count and sizewith multiple tenants. Avinash Kumar

8 May 2020

00:08 Re: pg_attribute, pg_class, pg_depend grow huge in count and sizewith multiple tenants. Rory Campbell-Lange
00:17 Re: pg_attribute, pg_class, pg_depend grow huge in count and sizewith multiple tenants. Avinash Kumar
00:21 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNERQuery ) David G. Johnston
00:21 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNERQuery ) David G. Johnston
00:26 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Tom Lane
00:26 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Tom Lane
00:59 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNERQuery ) David G. Johnston
00:59 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNERQuery ) David G. Johnston
02:46 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNERQuery ) David Rowley
02:46 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNERQuery ) David Rowley
09:31 Re: pg_attribute, pg_class, pg_depend grow huge in count and sizewith multiple tenants. Laurenz Albe
09:47 Re: pg_attribute, pg_class, pg_depend grow huge in count and sizewith multiple tenants. Avinash Kumar
09:53 Re: pg_attribute, pg_class, pg_depend grow huge in count and sizewith multiple tenants. Laurenz Albe
13:14 Re: pg_attribute, pg_class, pg_depend grow huge in count and sizewith multiple tenants. Avinash Kumar
16:01 Re: pg_attribute, pg_class, pg_depend grow huge in count and sizewith multiple tenants. MichaelDBA
16:44 Re: pg_attribute, pg_class, pg_depend grow huge in count and sizewith multiple tenants. Jeff Janes
16:54 Re: pg_attribute, pg_class, pg_depend grow huge in count and sizewith multiple tenants. Jeff Janes

10 May 2020

07:10 Re: 600 million rows of data. Bad hardware or need partitioning? Arya F

13 May 2020

12:33 Re: Inaccurate Rows estimate for "Bitmap And" causes Planner tochoose wrong join Steve Pritchard
17:17 Re: Please help! Query jumps from 1s -> 4m James Thompson

14 May 2020

08:44 Plan not skipping unnecessary inner join Matthew Nelson
09:45 Re: Plan not skipping unnecessary inner join David Wheeler

15 May 2020

20:36 Re: Plan not skipping unnecessary inner join Matthew Nelson

17 May 2020

15:32 Re: Plan not skipping unnecessary inner join Ranier Vilela
16:31 Re: Plan not skipping unnecessary inner join Justin Pryzby
17:05 Re: Plan not skipping unnecessary inner join Ranier Vilela

18 May 2020

21:42 Execution time from >1s -> 80m+ when extra columns added in SELECTfor sub-query A Guy Named Ryan
22:17 Re: Execution time from >1s -> 80m+ when extra columns added inSELECT for sub-query Pavel Stehule
23:49 Re: Execution time from >1s -> 80m+ when extra columns added inSELECT for sub-query A Guy Named Ryan

19 May 2020

00:58 Re: Execution time from >1s -> 80m+ when extra columns added in SELECT for sub-query Tom Lane

20 May 2020

10:30 OOM Killer kills PostgreSQL Piotr Włodarczyk
11:22 Re: OOM Killer kills PostgreSQL Laurenz Albe
11:28 Re: OOM Killer kills PostgreSQL Piotr Włodarczyk
11:40 Re: OOM Killer kills PostgreSQL Fabio Pardi
11:46 Re: OOM Killer kills PostgreSQL Justin Pryzby
19:54 Re: OOM Killer kills PostgreSQL Stephen Frost

22 May 2020

09:59 Suggestion to improve query performance for GIS query. postgann2020 s
09:59 Suggestion to improve query performance for GIS query. postgann2020 s
10:14 Re: Suggestion to improve query performance for GIS query. David G. Johnston
10:16 Re: Suggestion to improve query performance for GIS query. Mohammed Afsar
10:16 Re: Suggestion to improve query performance for GIS query. Mohammed Afsar
10:34 Re: Suggestion to improve query performance for GIS query. postgann2020 s
10:34 Re: Suggestion to improve query performance for GIS query. postgann2020 s
17:48 Strategy for materialisation and centralisation of data Rory Campbell-Lange

25 May 2020

06:50 Date vs Timestamp without timezone Partition Key Cedric Leong
07:48 Re: Date vs Timestamp without timezone Partition Key Tom Lane

28 May 2020

18:56 PostgreSQL performance problem moving from 9.6.17 to 12.3 Kenneth Marshall
19:42 Re: PostgreSQL performance problem moving from 9.6.17 to 12.3 Tom Lane

30 May 2020

10:36 Performance tunning sugnathi hai
10:43 Re: Performance tunning Pavel Stehule
17:19 Re: Performance tunning Justin Pryzby
17:55 Re: Performance tunning Jeff Janes