pgsql-performance since 2017-10-19 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

Oct. 19, 2017

Thread Author Time
Re: memory allocation Laurenz Albe 12:51
Low priority batch insert Jean Baro 16:10
Re: Low priority batch insert Michael Paquier 22:54

Oct. 23, 2017

Thread Author Time
postgresql tuning with perf Purav Chovatia 19:19
Re: postgresql tuning with perf legrand legrand 20:29
Re: postgresql tuning with perf Tomas Vondra 20:55
Re: postgresql tuning with perf Steve Atkins 21:59

Oct. 24, 2017

Thread Author Time
Row-level security performance Jason Borg 02:51
Re: postgresql tuning with perf Purav Chovatia 07:36
Re: postgresql tuning with perf 📎 Purav Chovatia 11:33
Re: postgresql tuning with perf Purav Chovatia 11:39
Re: performance drop after upgrade (9.6 > 10) johannes graën 14:15
Re: postgresql tuning with perf legrand legrand 14:51
Re: postgresql tuning with perf Purav Chovatia 15:06
Re: postgresql tuning with perf Purav Chovatia 15:08
Re: performance drop after upgrade (9.6 > 10) Justin Pryzby 15:18
Re: postgresql tuning with perf legrand legrand 15:21
Re: performance drop after upgrade (9.6 > 10) Johannes Graën 15:57
Re: performance drop after upgrade (9.6 > 10) Alvaro Herrera 16:17

Oct. 26, 2017

Thread Author Time
proposal: schema variables Pavel Stehule 07:21
Re: performance drop after upgrade (9.6 > 10) Justin Pryzby 19:45
Re: proposal: schema variables Nico Williams 22:07

Oct. 27, 2017

Thread Author Time
Re: proposal: schema variables Pavel Stehule 05:08
Re: proposal: schema variables Tatsuo Ishii 05:30
Re: proposal: schema variables Tsunakawa, Takayuki 05:47
Re: proposal: schema variables Pavel Stehule 06:16
WAL still kept in pg_xlog even long after heavy workload is done Stefan Petrea 11:28
Re: WAL still kept in pg_xlog even long after heavy workload is done MichaelDBA 12:50
Re: proposal: schema variables Gilles Darold 13:38
Re: proposal: schema variables Pavel Stehule 14:09

Oct. 28, 2017

Thread Author Time
Re: proposal: schema variables Chris Travers 14:24
Re: proposal: schema variables Pavel Stehule 14:56

Oct. 29, 2017

Thread Author Time
Re: proposal: schema variables Chris Travers 08:51
Re: proposal: schema variables Hannu Krosing 10:47
Cheaper subquery scan not considered unless offset 0 Benjamin Coutu 11:24
Re: Cheaper subquery scan not considered unless offset 0 David Rowley 11:46
Re: Cheaper subquery scan not considered unless offset 0 Benjamin Coutu 13:17
Re: Cheaper subquery scan not considered unless offset 0 Benjamin Coutu 14:41
Re: Cheaper subquery scan not considered unless offset 0 Tom Lane 14:58

Oct. 30, 2017

Thread Author Time
Re: proposal: schema variables srielau 21:42
Cursor vs Set Operation patibandlakoshal 22:51

Oct. 31, 2017

Thread Author Time
Massive insert vs heavy contention in LWLock:buffer_content luisfpg 16:30
Index-Advisor Tools Neto pr 17:12
Re: Index-Advisor Tools Anthony Sotolongo 17:19
Re: Index-Advisor Tools Neto pr 17:25
Re: Index-Advisor Tools Alexandre de Arruda Paes 19:25
Re: Index-Advisor Tools Yves Dorfsman 20:04
Re: Index-Advisor Tools Julien Rouhaud 20:04
Re: proposal: schema variables Pavel Stehule 20:33
Re: proposal: schema variables Serge Rielau 21:08
Re: proposal: schema variables Pavel Stehule 21:10
Re: proposal: schema variables srielau 21:28
Re: proposal: schema variables Gilles Darold 22:36
Re: proposal: schema variables Gilles Darold 23:02

Nov. 1, 2017

Thread Author Time
Re: proposal: schema variables Pavel Stehule 04:15
Re: proposal: schema variables Serge Rielau 05:07
Re: proposal: schema variables Pavel Stehule 05:56
Re: Cursor vs Set Operation Merlin Moncure 16:28
Re: proposal: schema variables Mark Dilger 18:03
Re: proposal: schema variables Pavel Stehule 19:19
Re: proposal: schema variables Gilles Darold 22:13

Nov. 2, 2017

Thread Author Time
OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices Gunther 00:28
Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices [email protected] 02:44
Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices Laurenz Albe 08:30
Re: proposal: schema variables Robert Haas 12:35
Re: proposal: schema variables Craig Ringer 15:07
Re: proposal: schema variables Nico Williams 15:35
Re: proposal: schema variables Pavel Stehule 15:40
Re: proposal: schema variables Pavel Stehule 15:42
Re: proposal: schema variables Tom Lane 15:48
Re: proposal: schema variables Pavel Stehule 15:49
Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices Gunther 16:36
Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices Gunther 17:14
Re: proposal: schema variables Robert Haas 17:21
Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices legrand legrand 18:03
Re: proposal: schema variables Nico Williams 18:52

Nov. 3, 2017

Thread Author Time
Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices Laurenz Albe 08:01
Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices Thomas Kellerer 09:28
Re: Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices Adam Brusselback 12:07
Re: proposal: schema variables Chris Travers 12:58
Re: Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices Gunther 14:36
Re: Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices Gunther 14:51
Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices legrand legrand 14:55
Re: Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices Gunther 15:13
Re: Re: OLAP/reporting queries fall into nested loops over seq scans or other horrible planner choices Dave Nicponski 15:56

Nov. 4, 2017

Thread Author Time
Unnecessary DISTINCT while primary key in SQL 刘瑞 15:20

Nov. 6, 2017

Thread Author Time
Re: Unnecessary DISTINCT while primary key in SQL David Rowley 00:34
Performance loss upgrading from 9.3 to 9.6 Adam Torres 13:18
Re: Performance loss upgrading from 9.3 to 9.6 Justin Pryzby 14:21
Re: Index-Advisor Tools Baron Schwartz 18:52
Dynamic performance issues 📎 Arne Roland 20:05
Re: Performance loss upgrading from 9.3 to 9.6 Adam Torres 21:12

Nov. 7, 2017

Thread Author Time
Re: Performance loss upgrading from 9.3 to 9.6 Adam Brusselback 02:59
Re: Performance loss upgrading from 9.3 to 9.6 Justin Pryzby 05:11
Slow execution of SET ROLE, SET search_path and RESET ROLE Ulf Lohbrügge 10:11
Re: Slow execution of SET ROLE, SET search_path and RESET ROLE Andres Freund 15:11
Re: Slow execution of SET ROLE, SET search_path and RESET ROLE Ulf Lohbrügge 17:48
Re: Slow execution of SET ROLE, SET search_path and RESET ROLE Andres Freund 19:45
Re: Slow execution of SET ROLE, SET search_path and RESET ROLE Ulf Lohbrügge 21:25
Re: Slow execution of SET ROLE, SET search_path and RESET ROLE Scott Marlowe 21:39
Re: Slow execution of SET ROLE, SET search_path and RESET ROLE Ulf Lohbrügge 23:04
Re: Slow execution of SET ROLE, SET search_path and RESET ROLE Tom Lane 23:45

Nov. 8, 2017

Thread Author Time
Re: Slow execution of SET ROLE, SET search_path and RESET ROLE Ulf Lohbrügge 09:31

Nov. 10, 2017

Thread Author Time
DB slowness after upgrade from Postgres 9.1 to 9.4 p kirti 10:58
overestimate on empty table Justin Pryzby 20:40
Re: overestimate on empty table Tom Lane 21:19

Nov. 11, 2017

Thread Author Time
Re: overestimate on empty table Justin Pryzby 17:19
Re: overestimate on empty table Tom Lane 17:43

Nov. 12, 2017

Thread Author Time
Re: DB slowness after upgrade from Postgres 9.1 to 9.4 Tom Lane 19:37

Nov. 13, 2017

Thread Author Time
Re: proposal: schema variables Pavel Golub 12:15
Re: proposal: schema variables Pavel Stehule 12:30
Query planner gaining the ability to replanning after start of query execution. Oliver Mattos 16:44
Re: Query planner gaining the ability to replanning after start of query execution. Arne Roland 20:06
Re: Query planner gaining the ability to replanning after start of query execution. Oliver Mattos 21:51
Re: Query planner gaining the ability to replanning after start of query execution. Arne Roland 22:48
Re: Query planner gaining the ability to replanning after start of query execution. Tom Lane 22:49
Re: Query planner gaining the ability to replanning after start of query execution. Oliver Mattos 23:20

Nov. 14, 2017

Thread Author Time
Re: Query planner gaining the ability to replanning after start of query execution. legrand legrand 21:26

Nov. 15, 2017

Thread Author Time
query performance issue 📎 Samir Magar 09:33
Re: query performance issue Pavel Stehule 09:43
Re: query performance issue 📎 Samir Magar 12:54
Re: query performance issue Pavel Stehule 13:12
Re: query performance issue Justin Pryzby 14:16
Re: Query planner gaining the ability to replanning after start of query execution. Gunter 19:57
Re: query performance issue Gunther 19:58
Re: query performance issue Pavel Stehule 20:07
CREATE STATISTICS and join selectivity Justin Pryzby 20:19
Re: CREATE STATISTICS and join selectivity David Rowley 23:47

Nov. 18, 2017

Thread Author Time
POWA doesn't show queries executed Neto pr 01:52

Nov. 20, 2017

Thread Author Time
PostgreSQL 9.6 wals management Mariel Cherkassky 09:02
Re: PostgreSQL 9.6 wals management Michael Paquier 12:28
Re: PostgreSQL 9.6 wals management Mariel Cherkassky 12:56
Migration to pglister - Before Stephen Frost 14:33
Migration to PGLister - After Stephen Frost 15:03
Re: [ADMIN] Migration to pglister - Before Achilleas Mantzios 15:30
Re: [ADMIN] Migration to pglister - Before Stephen Frost 15:34
insert and query performance on big string table with pg_trgm Matthew Hall 22:54

Nov. 21, 2017

Thread Author Time
Re: insert and query performance on big string table with pg_trgm Jeff Janes 01:42
Re: [PERFORM] POWA doesn't show queries executed phb07 08:00
Re: insert and query performance on big string table with pg_trgm Matthew Hall 08:05
Using GROUPING SETS with more than one set disables predicate pushdown? Zakhar Shapurau 11:04
pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Henrik Cednert (Filmlance) 14:28
Re: Using GROUPING SETS with more than one set disables predicate pushdown? Tom Lane 14:49
Re: [PERFORM] POWA doesn't show queries executed Marco Nietz 15:29
RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Igor Neyman 16:25
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Henrik Cednert (Filmlance) 16:27
RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Igor Neyman 16:34
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Henrik Cednert (Filmlance) 16:37
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Shaul Dar 16:44
RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Igor Neyman 16:44
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Henrik Cednert (Filmlance) 16:48
RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Igor Neyman 16:57
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Tom Lane 17:01
Re: Using GROUPING SETS with more than one set disables predicate pushdown? Andres Freund 18:16
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Robert Haas 18:39
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Tom Lane 18:46
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Henrik Cednert (Filmlance) 18:53
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Henrik Cednert (Filmlance) 18:59
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Tom Lane 21:01

Nov. 22, 2017

Thread Author Time
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Henrik Cednert (Filmlance) 03:48
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Henrik Cednert (Filmlance) 06:18
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Matthew Hall 10:32
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Henrik Cednert (Filmlance) 12:17
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Henrik Cednert (Filmlance) 13:06
Query became very slow after 9.6 -> 10 upgrade Dmitry Shalashov 14:13
RE: Query became very slow after 9.6 -> 10 upgrade Alex Ignatov 14:24
Re: Query became very slow after 9.6 -> 10 upgrade Dmitry Shalashov 14:29
Bad estimates Artur Zając 14:29
RE: Query became very slow after 9.6 -> 10 upgrade Alex Ignatov 14:44
Re: Bad estimates Don Seiler 14:49
Re: Query became very slow after 9.6 -> 10 upgrade Dmitry Shalashov 14:51
Re: Bad estimates (DEFAULT_UNK_SEL) Justin Pryzby 14:57
Re: Bad estimates Tom Lane 15:01
RE: Bad estimates Alex Ignatov 15:05
Re: Query became very slow after 9.6 -> 10 upgrade Tomas Vondra 15:07
Re: Bad estimates Laurenz Albe 15:09
Re: Query became very slow after 9.6 -> 10 upgrade Tom Lane 15:19
RE: Bad estimates Artur Zając 16:52
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Andres Freund 16:56
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Matthew Hall 19:52
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Henrik Cednert (Filmlance) 20:06
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Patrick KUI-LI 21:07
Re: Query became very slow after 9.6 -> 10 upgrade Dmitry Shalashov 21:34
Re: Query became very slow after 9.6 -> 10 upgrade 📎 Tom Lane 23:07

Nov. 23, 2017

Thread Author Time
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Henrik Cednert (Filmlance) 09:26
Re: Query became very slow after 9.6 -> 10 upgrade Dmitry Shalashov 14:58
Re: Query became very slow after 9.6 -> 10 upgrade Tom Lane 17:00
pgpool + repmgr - who should be responsible for failover Mariel Cherkassky 18:14

Nov. 24, 2017

Thread Author Time
Issue with postgres login Daulat Ram 03:27
Re: Issue with postgres login Bob Strecansky 03:37
RE: Re: Issue with postgres login Daulat Ram 04:04
Re: Re: Issue with postgres login Bob Strecansky 04:07
RE: Re: Re: Issue with postgres login Daulat Ram 04:23
Re: Re: Re: Issue with postgres login Bob Strecansky 04:25
RE: Re: Re: Re: Issue with postgres login Daulat Ram 06:49
Re: Query became very slow after 9.6 -> 10 upgrade Dmitry Shalashov 15:44
Re: Query became very slow after 9.6 -> 10 upgrade Tom Lane 16:39

Nov. 25, 2017

Thread Author Time
Re: insert and query performance on big string table with pg_trgm Jeff Janes 06:35
Re: insert and query performance on big string table with pg_trgm Gábor SZŰCS 09:19
Re: Query became very slow after 9.6 -> 10 upgrade Dmitry Shalashov 11:54

Browse Archives

Prev | Next