pgsql-performance - November 2016

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

Nov. 1, 2016

Thread	Author	Time
Refresh materialized view vs recreate	Антон Мазунин	06:26
Re: Refresh materialized view vs recreate	Kevin Grittner	15:25

Nov. 2, 2016

Thread	Author	Time
Perf decreased although server is better	Benjamin Toueg	13:26
Re: Perf decreased although server is better	Tomas Vondra	14:36
Re: Perf decreased although server is better	Kevin Grittner	14:38
Re: Perf decreased although server is better	Rick Otten	14:55
no MCV list of tiny table with unique columns	Justin Pryzby	18:53
archive_command too slow.	Joao Junior	19:06
Re: no MCV list of tiny table with unique columns	Tom Lane	20:05
Re: no MCV list of tiny table with unique columns	Justin Pryzby	20:19
Re: limit 1 on view never finishes	Jim Nasby	23:37
Re: query slowdown after 9.0 -> 9.4 migration	Jim Nasby	23:43
Re: Big Memory Boxes and pgtune	Jim Nasby	23:46
Re: no MCV list of tiny table with unique columns	Tom Lane	23:48

Nov. 3, 2016

Thread	Author	Time
Re: Perf decreased although server is better	Benjamin Toueg	14:51
Hot migration of tables	YueLi	18:07

Nov. 4, 2016

Thread	Author	Time
Re: Perf decreased although server is better	Kevin Grittner	00:05
Re: Big Memory Boxes and pgtune	Scott Marlowe	02:24
Re: Perf decreased although server is better	Benjamin Toueg	11:53
Re: Perf decreased although server is better	Will Platnick	13:27
Re: Perf decreased although server is better	Rick Otten	13:29
Re: Perf decreased although server is better	Kevin Grittner	14:05
Re: archive_command too slow.	Jeff Janes	16:19
Re: archive_command too slow.	Claudio Freire	22:30

Nov. 5, 2016

Thread	Author	Time
Re: no MCV list of tiny table with unique columns	Justin Pryzby	22:36

Nov. 7, 2016

Thread	Author	Time
Query much slower after upgrade to 9.6.1	Adam Brusselback	15:52
Re: Query much slower after upgrade to 9.6.1	Adam Brusselback	18:05
Re: Query much slower after upgrade to 9.6.1	Tom Lane	19:16
Re: Query much slower after upgrade to 9.6.1	Adam Brusselback	19:26
Re: Query much slower after upgrade to 9.6.1	Tom Lane	19:32
Re: Query much slower after upgrade to 9.6.1	Adam Brusselback	20:31

Nov. 8, 2016

Thread	Author	Time
Re: archive_command too slow.	Stephen Frost	15:47

Nov. 9, 2016

Thread	Author	Time
Tuning one Recurcive CTE	Henrik Ekenberg	13:05
Re: Tuning one Recurcive CTE	Andreas Joseph Krogh	13:29
Re: Tuning one Recurcive CTE	Henrik Ekenberg	14:30
Re: Tuning one Recurcive CTE	Andreas Joseph Krogh	16:22

Nov. 10, 2016

Thread	Author	Time
Re: Perf decreased although server is better	Benjamin Toueg	09:52

Nov. 11, 2016

Thread	Author	Time
Inlining of functions (doing LIKE on an array)	[email protected]	06:54
Re: Inlining of functions (doing LIKE on an array)	Marc Mamin	12:43
Any advice tuning this query ?	Henrik Ekenberg	15:19
Re: Any advice tuning this query ?	Devrim Gündüz	15:55
Re: Inlining of functions (doing LIKE on an array)	[email protected]	16:14
Re: Any advice tuning this query ?	Andreas Karlsson	16:22
Re: Inlining of functions (doing LIKE on an array)	Tom Lane	16:46
Re: Inlining of functions (doing LIKE on an array)	Jeff Janes	23:32

Nov. 12, 2016

Thread	Author	Time
Re: Inlining of functions (doing LIKE on an array)	[email protected]	00:41
Re: Any advice tuning this query ?	Jeff Janes	19:25
Re: Inlining of functions (doing LIKE on an array)	Tom Lane	19:59
Re: Inlining of functions (doing LIKE on an array)	[email protected]	20:17

Nov. 14, 2016

Thread	Author	Time
Some tuning suggestions on a Red Hat 6.7 - PG 9.5.3 production environment	Pietro Pugni	11:45
Query planner chooses index scan backward instead of better index option	Seckin Pulatkan	12:01
Re: Query planner chooses index scan backward instead of better index option	Jeff Janes	16:50
Re: Some tuning suggestions on a Red Hat 6.7 - PG 9.5.3 production environment	domenico febbo	17:36
Why is the optimiser choosing a sub-optimal plan?	Stephen Cresswell	17:53
Re: Why is the optimiser choosing a sub-optimal plan?	Tom Lane	19:37
Re: Some tuning suggestions on a Red Hat 6.7 - PG 9.5.3 production environment	Pietro Pugni	20:50
Re: Some tuning suggestions on a Red Hat 6.7 - PG 9.5.3 production environment	Merlin Moncure	21:24

Nov. 15, 2016

Thread	Author	Time
Re: Query planner chooses index scan backward instead of better index option	Seckin Pulatkan	08:44
Sql Query :: Any advice ?	Henrik Ekenberg	13:27
Re: Sql Query :: Any advice ?	vinny	13:50
Re: Sql Query :: Any advice ?	Henrik Ekenberg	14:30
Re: Sql Query :: Any advice ?	vinny	15:44
Re: Sql Query :: Any advice ? 📎	Henrik	17:23
Performance decrease after upgrade to 9.6.1	Gabriela Serventi	21:57
Re: Performance decrease after upgrade to 9.6.1	Tom Lane	22:35
Re: Some tuning suggestions on a Red Hat 6.7 - PG 9.5.3 production environment	Jeff Janes	23:47

Nov. 16, 2016

Thread	Author	Time
Re: Performance decrease after upgrade to 9.6.1	Gabriela Serventi	00:50
Run one query and execution time is very different	Metatrader EA	09:10

Nov. 17, 2016

Thread	Author	Time
Query hangs sometimes	Metatrader EA	10:43
Re: Query hangs sometimes	Guillaume Cottenceau	11:02
Re: Query hangs sometimes	Metatrader EA	11:55
Re: Query planner chooses index scan backward instead of better index option	Seckin Pulatkan	12:33
materialized view order by and clustering	Rick Otten	16:36
Re: materialized view order by and clustering	David G. Johnston	17:06
Re: Query hangs sometimes	Michael Paquier	21:49

Nov. 18, 2016

Thread	Author	Time
DO I miss something ?	Metatrader EA	13:52
Re: DO I miss something ?	vinny	14:04

Nov. 23, 2016

Thread	Author	Time
How to tune Postgres to take advantage of 256GB RAM hardware	Carmen Mardiros	22:15

Nov. 24, 2016

Thread	Author	Time
Re: How to tune Postgres to take advantage of 256GB RAM hardware	Andreas Kretschmer	04:19
Re: How to tune Postgres to take advantage of 256GB RAM hardware	Carmen Mardiros	08:17
Re: How to tune Postgres to take advantage of 256GB RAM hardware	Imre Samu	11:46
Re: How to tune Postgres to take advantage of 256GB RAM hardware	Carmen Mardiros	15:31
Re: How to tune Postgres to take advantage of 256GB RAM hardware	Tom Lane	18:40

Nov. 25, 2016

Thread	Author	Time
Re: Millions of tables	Robert Klemme	17:14

Nov. 26, 2016

Thread	Author	Time
Slow UPDATE in logs that's usually fast	Aldo Sarmiento	05:13

Nov. 28, 2016

Thread	Author	Time
can trigger monitor two tables?	zhangkai.gis	08:59
Re: can trigger monitor two tables?	Andreas Kretschmer	10:49

Nov. 30, 2016

Thread	Author	Time
performance issue with bitmap index scans on huge amounts of big jsonb documents	Marc-Olaf Jaschke	12:26

Browse Archives

Prev | Next