pgsql-performance since 2018-03-20 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

March 20, 2018

Thread Author Time
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 17:38

March 21, 2018

Thread Author Time
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 05:24
badly scaling performance with appending to bytea Gary Cowell 12:03
Re: badly scaling performance with appending to bytea Rick Otten 12:12
Re: badly scaling performance with appending to bytea Pavel Stehule 12:56
Re: badly scaling performance with appending to bytea Pavel Stehule 12:59
Re: badly scaling performance with appending to bytea Gary Cowell 13:04
Re: badly scaling performance with appending to bytea Pavel Stehule 13:09

March 23, 2018

Thread Author Time
Re: [HACKERS] proposal: schema variables Pavel Stehule 05:37
DB corruption Akshay Ballarpure 07:59
Re: DB corruption Michael Paquier 08:04
Should from_collapse be switched off? (queries 10 times faster) Peter 10:03
Re: Should from_collapse be switched off? (queries 10 times faster) Thomas Kellerer 11:39
Re: Should from_collapse be switched off? (queries 10 times faster) Laurenz Albe 11:41
Re: Should from_collapse be switched off? (queries 10 times faster) Tom Lane 14:14
Re: Should from_collapse be switched off? (queries 10 times faster) Peter 14:30
Re: Should from_collapse be switched off? (queries 10 times faster) Peter 14:30
Re: DB corruption Tom Lane 15:08
Re: Should from_collapse be switched off? (queries 10 times faster) Peter 17:36
Slow planning time for custom function bk 20:28

March 24, 2018

Thread Author Time
functions: VOLATILE performs better than STABLE Peter 01:27
Re: Slow planning time for custom function Andres Freund 01:35
Re: Slow planning time for custom function David Rowley 01:52

March 25, 2018

Thread Author Time
Re: functions: VOLATILE performs better than STABLE Laurenz Albe 05:00
Re: Should from_collapse be switched off? (queries 10 times faster) Laurenz Albe 05:12
Re: functions: VOLATILE performs better than STABLE David Rowley 12:24
Re: Slow planning time for custom function bk 18:18

March 26, 2018

Thread Author Time
Re: Should from_collapse be switched off? (queries 10 times faster) Peter 10:36
Re: Should from_collapse be switched off? (queries 10 times faster) Laurenz Albe 17:13

March 27, 2018

Thread Author Time
Slow query on partitioned table. Glenn Pierce 14:14
Re: Slow query on partitioned table. Justin Pryzby 14:43
Re: Slow query on partitioned table. Justin Pryzby 21:00

April 5, 2018

Thread Author Time
Re: functions: VOLATILE performs better than STABLE Merlin Moncure 14:18

April 6, 2018

Thread Author Time
[PERFORM] Dissuade the use of exclusion constraint index Adam Brusselback 16:30
citext performance Deepak Somaiya 16:51

April 8, 2018

Thread Author Time
Re: citext performance Nandakumar M 10:12
Re: citext performance Deepak Somaiya 20:14

April 10, 2018

Thread Author Time
Latest advice on SSD? Craig James 02:36
Sv: Latest advice on SSD? Andreas Joseph Krogh 07:21
Re: Latest advice on SSD? Craig James 17:41
Re: Latest advice on SSD? Benjamin Scherrey 17:54
Re: Latest advice on SSD? Aaron 19:00
Re: Latest advice on SSD? Dmitry Shalashov 19:11
Re: Latest advice on SSD? Charles Sprickman 19:58
Re: Latest advice on SSD? Frits Jalvingh 20:15
Re: Latest advice on SSD? Mark Kirkwood 22:56

April 11, 2018

Thread Author Time
Re: Latest advice on SSD? Matthew Hall 01:39
Re: [PERFORM] Dissuade the use of exclusion constraint index Adam Brusselback 05:59
Re: [PERFORM] Dissuade the use of exclusion constraint index Dave Cramer 09:41
Re: [PERFORM] Dissuade the use of exclusion constraint index Adam Brusselback 14:47

April 12, 2018

Thread Author Time
Re: Latest advice on SSD? Mark Kirkwood 05:11
Table order at FROM clause affects performance? Eduard Català 14:35
Re: Table order at FROM clause affects performance? Tom Lane 15:30
Re: Table order at FROM clause affects performance? Eduard Català 16:25

April 13, 2018

Thread Author Time
Re: Latest advice on SSD? Ants Aasma 09:55

April 16, 2018

Thread Author Time
Data migration from postgres 8.4 to 9.4 Akshay Ballarpure 07:03
Re: Data migration from postgres 8.4 to 9.4 Amitabh Kant 07:11
Re: Data migration from postgres 8.4 to 9.4 Gunnar "Nick" Bluth 08:09
Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...) Hackety Man 20:42

April 17, 2018

Thread Author Time
Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...) Pavel Stehule 05:17
Installing PostgreSQL 9.5 in centos 6 using YUM Dinesh Chandra 12108 09:25
Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...) Tomas Vondra 10:49
Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...) Tomas Vondra 10:52
RE: Data migration from postgres 8.4 to 9.4 Akshay Ballarpure 12:24
Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...) Hackety Man 14:01
Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...) Hackety Man 14:05
Re: [HACKERS] proposal: schema variables Arthur Zakirov 14:14
Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...) Tomas Vondra 14:23
Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...) Hackety Man 15:43
Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...) Pavel Stehule 16:13
Re: [HACKERS] proposal: schema variables Pavel Stehule 16:28
Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...) Pavel Stehule 16:41
Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...) Tomas Vondra 20:29
Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...) Tomas Vondra 20:30
Citext Performance Deepak Somaiya 21:05

April 18, 2018

Thread Author Time
pg_upgrade help Akshay Ballarpure 07:30
Re: pg_upgrade help Fabio Pardi 07:35
RE: Installing PostgreSQL 9.5 in centos 6 using YUM Ahmed, Nawaz 07:47
RE: Data migration from postgres 8.4 to 9.4 Ahmed, Nawaz 08:06
Re: pg_upgrade help Akshay Ballarpure 08:34
Re: pg_upgrade help Sergei Kornilov 08:39
Re: pg_upgrade help Fabio Pardi 09:05
Re: [HACKERS] proposal: schema variables Arthur Zakirov 11:37
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 11:54
Re: pg_upgrade help Akshay Ballarpure 12:02
Re: pg_upgrade help Fabio Pardi 12:47
Re: pg_upgrade help Adrian Klaver 14:02
SeqScan vs. IndexScan Vitaliy Garnashevich 22:14
Re: SeqScan vs. IndexScan Tom Lane 22:33

April 19, 2018

Thread Author Time
Re: pg_upgrade help Rajni Baliyan 00:12
Re: pg_upgrade help Akshay Ballarpure 07:37
Re: pg_upgrade help Fabio Pardi 10:14
Re: pg_upgrade help Akshay Ballarpure 12:56

April 20, 2018

Thread Author Time
Re: pg_upgrade help Akshay Ballarpure 09:24
Re: pg_upgrade help Fabio Pardi 09:48
Re: [HACKERS] proposal: schema variables Robert Haas 15:32
Re: [HACKERS] proposal: schema variables Pavel Stehule 17:45

April 29, 2018

Thread Author Time
Performance issues while running select sql query Kaushal Shriyan 04:35
Re: Performance issues while running select sql query Justin Pryzby 04:40
Re: Performance issues while running select sql query Kaushal Shriyan 05:03
Re: Performance issues while running select sql query Kaushal Shriyan 05:18
Performance issues while running select sql query David G. Johnston 06:10
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 12:34
Re: Performance issues while running select sql query Justin Pryzby 14:18
Re: Performance issues while running select sql query Kaushal Shriyan 18:10

April 30, 2018

Thread Author Time
Re: proposal: schema variables Fabrízio Mello 17:28
Why doesn't the second query use the index for sorting? Alf Lervåg 19:43

May 1, 2018

Thread Author Time
Re: [HACKERS] proposal: schema variables Peter Eisentraut 01:56
Re: [HACKERS] proposal: schema variables Pavel Stehule 03:11

May 5, 2018

Thread Author Time
help in analysis of execution plans Neto pr 15:16
Re: help in analysis of execution plans Neto pr 18:07

May 6, 2018

Thread Author Time
Re: help in analysis of execution plans David Rowley 00:33

May 7, 2018

Thread Author Time
Time bucketing query performance Julian Wilson 23:33

May 8, 2018

Thread Author Time
Re: Time bucketing query performance Justin Pryzby 01:08

May 9, 2018

Thread Author Time
Sv: Re: Latest advice on SSD? Andreas Joseph Krogh 20:00

May 11, 2018

Thread Author Time
Sv: Sv: Re: Latest advice on SSD? Andreas Joseph Krogh 11:23
Re: Sv: Sv: Re: Latest advice on SSD? Mark Kirkwood 12:11
Sv: Re: Sv: Sv: Re: Latest advice on SSD? Andreas Joseph Krogh 14:00
Sv: Re: Sv: Sv: Re: Latest advice on SSD? Andreas Joseph Krogh 14:17
Re: Latest advice on SSD? Evgeniy Shishkin 14:48

May 12, 2018

Thread Author Time
Re: Latest advice on SSD? Mark Kirkwood 05:19

May 18, 2018

Thread Author Time
Help with tuning slow query Kotapati, Anil 20:32

May 19, 2018

Thread Author Time
Re: Help with tuning slow query Justin Pryzby 15:57

May 21, 2018

Thread Author Time
Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!! pavan95 06:15
Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!! mlunnon 08:03
Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!! pavan95 11:13
Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!! Abbas 11:28
Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!! pavan95 13:39
Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!! David G. Johnston 14:03
Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!! Abbas 14:12
Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!! pavan95 14:34
Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!! pavan95 14:43
Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!! David G. Johnston 15:06
Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!! mlunnon 15:48

May 22, 2018

Thread Author Time
Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!! pavan95 10:32
Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!! pavan95 10:32
Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!! Justin Pryzby 10:39
Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!! pavan95 10:51
Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!! Justin Pryzby 18:23
Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!! Pavan Teja 18:25

May 23, 2018

Thread Author Time
Re: dsa_allocate() faliure Sand Stone 04:10
Re: dsa_allocate() faliure Thomas Munro 04:44
Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!! pavan95 07:01
Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!! mlunnon 11:12
Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!! pavan95 13:39
Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!! Justin Pryzby 13:43
Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!! pavan95 14:03
Re: dsa_allocate() faliure Sand Stone 14:06
Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!! Justin Pryzby 20:01

May 24, 2018

Thread Author Time
Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!! pavan95 05:20
Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!! Justin Pryzby 06:06
propose web form for submission of performance problems Justin Pryzby 23:57

May 25, 2018

Thread Author Time
add default parallel query to v10 release notes? (Re: [PERFORM] performance drop after upgrade (9.6 > 10)) Justin Pryzby 01:00
Re: propose web form for submission of performance problems Craig James 01:27
Re: propose web form for submission of performance problems Justin Pryzby 01:52
Re: propose web form for submission of performance problems Thomas Kellerer 05:45

May 30, 2018

Thread Author Time
Possible optimisation: push down SORT and LIMIT nodes Christopher Wilson 15:46
Re: Possible optimisation: push down SORT and LIMIT nodes Justin Pryzby 19:02
Re: Possible optimisation: push down SORT and LIMIT nodes Justin Pryzby 19:09

May 31, 2018

Thread Author Time
Sort is generating rows Nicolas Seinlet 11:22
Re: Sort is generating rows Jeff Janes 13:10
Re: Sort is generating rows Nicolas Seinlet 13:16

June 5, 2018

Thread Author Time
Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan Fred Habash 14:17
Re: Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan Sergei Kornilov 14:26
Re: Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan Matthew Hall 14:42
Re: Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan Tom Lane 14:42
RE: Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan Fd Habash 17:18

June 7, 2018

Thread Author Time
Re: Client Server performance & UDS e-blokos 09:40

June 12, 2018

Thread Author Time
pg_upgrade 10.2 Murthy Nunna 20:34
Re: pg_upgrade 10.2 Adrian Klaver 20:47
RE: pg_upgrade 10.2 Murthy Nunna 20:58
Re: pg_upgrade 10.2 Adrian Klaver 21:13
RE: pg_upgrade 10.2 Murthy Nunna 21:18
Re: pg_upgrade 10.2 Adrian Klaver 21:34
RE: pg_upgrade 10.2 Murthy Nunna 21:49
Re: pg_upgrade 10.2 Jerry Sievers 23:24
RE: pg_upgrade 10.2 Murthy Nunna 23:41
Re: pg_upgrade 10.2 Adrian Klaver 23:50
Re: pg_upgrade 10.2 Jerry Sievers 23:56
Re: pg_upgrade 10.2 Jerry Sievers 23:59

June 13, 2018

Thread Author Time
Re: [PERFORM] Dissuade the use of exclusion constraint index Adam Brusselback 15:59

June 14, 2018

Thread Author Time
Small query plan change, big performance difference Michael Sacket 18:02
Re: Small query plan change, big performance difference Adam Brusselback 18:24
Re: Small query plan change, big performance difference Michael Sacket 18:49

June 19, 2018

Thread Author Time
Re: [PERFORM] Dissuade the use of exclusion constraint index Adam Brusselback 19:50

June 20, 2018

Thread Author Time
Slow query when pg_trgm is in inner lopp Sasa Vilic 13:21
Re: Slow query when pg_trgm is in inner lopp Matthew Hall 13:29
Re: Slow query when pg_trgm is in inner lopp Sasa Vilic 14:13
Re: Slow query when pg_trgm is in inner lopp Jeff Janes 14:53
Re: add default parallel query to v10 release notes? (Re: [PERFORM] performance drop after upgrade (9.6 > 10)) 📎 Bruce Momjian 15:13
Re: Slow query when pg_trgm is in inner lopp Sasa Vilic 15:38

June 22, 2018

Thread Author Time
Re: add default parallel query to v10 release notes? (Re: [PERFORM] performance drop after upgrade (9.6 > 10)) Amit Kapila 09:23

June 25, 2018

Thread Author Time
Slow join Roman Kushnir 15:55
Re: Slow join Justin Pryzby 16:45
Re: Slow join Roman Kushnir 19:39

June 26, 2018

Thread Author Time
"set primary keys..." is missing when using hight values for transactions / scaling factor with pgbench Elvir Kurić 12:21
Re: "set primary keys..." is missing when using hight values for transactions / scaling factor with pgbench David Rowley 12:41
Re: "set primary keys..." is missing when using hight values for transactions / scaling factor with pgbench Elvir Kurić 12:51

June 27, 2018

Thread Author Time
Queue table that quickly grows causes query planner to choose poor plan David Wheeler 03:45
Re: Slow join Laurenz Albe 08:19

Browse Archives

Prev | Next