pgsql-performance - June 2015

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 9 10 11 12 13 15 17 18 19 23 24 25 27 30

June 1, 2015

Thread Author Time
Re: Postgres is using 100% CPU Ashik S L 05:38
Re: Postgres is using 100% CPU Merlin Moncure 13:20
Slow hash join performance with many batches 📎 Alex Adriaanse 16:03
Re: Slow hash join performance with many batches Tom Lane 17:58
Re: Fastest way / best practice to calculate "next birthdays" Kevin Grittner 19:11
Re: Postgres is using 100% CPU Scott Marlowe 19:35
Connection time when using SSL Marco Di Cesare 20:51
Re: Connection time when using SSL Tomas Vondra 21:21

June 2, 2015

Thread Author Time
Re: Postgres is using 100% CPU Graeme B. Bell 07:47
Re: Postgres is using 100% CPU Graeme B. Bell 07:58
Re: Postgres is using 100% CPU Ashik S L 08:20

June 3, 2015

Thread Author Time
How to reduce writing on disk ? (90 gb on pgsql_tmp) ben.play 12:21
Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) David G. Johnston 12:44
Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) amulsul 13:11
Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) chiru r 13:27
Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Tomas Vondra 13:51
Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) ben.play 14:06
Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Tomas Vondra 14:56
Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Scott Marlowe 15:09
Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Claudio Freire 17:06
Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Tomas Vondra 19:24
Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Scott Marlowe 21:18
Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Claudio Freire 21:58
Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Tomas Vondra 22:16
Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Joshua D. Drake 22:29
Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Yves Dorfsman 23:54

June 4, 2015

Thread Author Time
Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Tomas Vondra 00:22
Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Scott Marlowe 00:53
Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Scott Marlowe 00:58
Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Mark Kirkwood 01:19
Need more IOPS? This should get you drooling... (5xnvme drives) Graeme B. Bell 11:07
Re: Need more IOPS? This should get you drooling... (5xnvme drives) Graeme B. Bell 11:23
Re: Need more IOPS? This should get you drooling... (5xnvme drives) Dorian Hoxha 11:29
Re: Need more IOPS? This should get you drooling... (5xnvme drives) Graeme B. Bell 11:35
Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Tomas Vondra 14:43

June 5, 2015

Thread Author Time
Query running slow for only one specific id. (Postgres 9.3) version Sheena, Prabhjot 17:54
Re: Query running slow for only one specific id. (Postgres 9.3) version Igor Neyman 18:05
Re: Query running slow for only one specific id. (Postgres 9.3) version Steve Crawford 18:24
Re: Query running slow for only one specific id. (Postgres 9.3) version Sheena, Prabhjot 18:38
Re: Query running slow for only one specific id. (Postgres 9.3) version Igor Neyman 18:46
Re: Re: Query running slow for only one specific id. (Postgres 9.3) version Steve Crawford 19:28
Re: Re: [GENERAL] Re: Query running slow for only one specific id. (Postgres 9.3) version Steve Crawford 19:34
Re: [PERFORM] Query running slow for only one specific id. (Postgres 9.3) version Matheus de Oliveira 22:34

June 9, 2015

Thread Author Time
Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) ben.play 15:58
Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Claudio Freire 16:04

June 10, 2015

Thread Author Time
Slow query - lots of temporary files. Johann Spies 12:39
Re: Slow query - lots of temporary files. Claudio Freire 13:02
Re: Slow query - lots of temporary files. Johann Spies 13:42
Re: Slow query - lots of temporary files. Tomas Vondra 14:50
Row estimates off by two orders of magnitude with hstore Patrick Krecker 17:32
Re: Row estimates off by two orders of magnitude with hstore Merlin Moncure 18:32
Re: Row estimates off by two orders of magnitude with hstore Josh Berkus 19:40
Re: Row estimates off by two orders of magnitude with hstore Merlin Moncure 20:01
Re: Row estimates off by two orders of magnitude with hstore Patrick Krecker 20:55
Re: Row estimates off by two orders of magnitude with hstore Merlin Moncure 21:08
Re: Row estimates off by two orders of magnitude with hstore Patrick Krecker 21:37
Re: Row estimates off by two orders of magnitude with hstore Merlin Moncure 22:08

June 11, 2015

Thread Author Time
Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) ben.play 08:56
Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Claudio Freire 12:48

June 12, 2015

Thread Author Time
Slow query: Postgres chooses nested loop over hash join, whery by hash join is much faster, wrong number of rows estimated Sasa Vilic 00:18
Re: Slow query - lots of temporary files. Johann Spies 15:04
pg bouncer issue what does sv_used column means Sheena, Prabhjot 17:57
Re: pg bouncer issue what does sv_used column means Glyn Astill 19:01
Re: pg bouncer issue what does sv_used column means Xenofon Papadopoulos 20:26
Are there tuning parameters that don't take effect immediately? Michael Nolan 20:37
Re: Are there tuning parameters that don't take effect immediately? David G. Johnston 20:52
Re: Are there tuning parameters that don't take effect immediately? Joshua D. Drake 21:00
Re: Are there tuning parameters that don't take effect immediately? Michael Nolan 21:13
Re: pg bouncer issue what does sv_used column means Sheena, Prabhjot 21:37
Re: pg bouncer issue what does sv_used column means Andrew Dunstan 21:49
Re: pg bouncer issue what does sv_used column means [email protected] 21:57

June 13, 2015

Thread Author Time
Do work_mem and shared buffers have 1g or 2g limit on 64 bit linux? Kaijiang Chen 17:27
Re: Do work_mem and shared buffers have 1g or 2g limit on 64 bit linux? Joshua D. Drake 17:43
Re: Do work_mem and shared buffers have 1g or 2g limit on 64 bit linux? Joe Conway 18:10

June 15, 2015

Thread Author Time
Re: Do work_mem and shared buffers have 1g or 2g limit on 64 bit linux? Kaijiang Chen 03:44
Re: Slow query: Postgres chooses nested loop over hash join, whery by hash join is much faster, wrong number of rows estimated Merlin Moncure 14:25
Re: Do work_mem and shared buffers have 1g or 2g limit on 64 bit linux? Tomas Vondra 14:57

June 17, 2015

Thread Author Time
Re: PATCH: adaptive ndistinct estimator v4 📎 Tomas Vondra 14:47

June 18, 2015

Thread Author Time
PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) Sheena, Prabhjot 17:09
Re: [PERFORM] PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) [email protected] 17:16
Re: PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) Will Platnick 17:17
Re: PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) Sheena, Prabhjot 17:41
How to calculate statistics for one column Irineu Ruiz 17:52
Re: [PERFORM] PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) [email protected] 18:10
Re: How to calculate statistics for one column Igor Neyman 18:16
Re: How to calculate statistics for one column Irineu Ruiz 18:18
Re: How to calculate statistics for one column Igor Neyman 18:24
Re: How to calculate statistics for one column Irineu Ruiz 19:09
Re: PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) Sheena, Prabhjot 19:19
Techniques to Avoid Temp Files Duane Murphy 19:38
Re: [PERFORM] PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) Jerry Sievers 19:46
Re: How to calculate statistics for one column Igor Neyman 19:52
Re: PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) Igor Neyman 19:59
Re: PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) [email protected] 20:02
Re: [PERFORM] PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) Sheena, Prabhjot 20:26

June 19, 2015

Thread Author Time
Re: Techniques to Avoid Temp Files Albe Laurenz 08:17
Slow query (planner insisting on using 'external merge' sort type) Ian Pushee 14:34
Re: Slow query (planner insisting on using 'external merge' sort type) Igor Neyman 14:46
Re: Slow query (planner insisting on using 'external merge' sort type) Andreas Kretschmer 14:47
Re: Slow query (planner insisting on using 'external merge' sort type) Ian Pushee 14:53
Re: Slow query (planner insisting on using 'external merge' sort type) Ian Pushee 14:57
Re: Slow query (planner insisting on using 'external merge' sort type) Igor Neyman 15:06
Re: Slow query (planner insisting on using 'external merge' sort type) Igor Neyman 15:18
Re: Techniques to Avoid Temp Files Jeff Janes 18:26

June 23, 2015

Thread Author Time
Re: Slow query (planner insisting on using 'external merge' sort type) Jim Nasby 21:05

June 24, 2015

Thread Author Time
pgbouncer issue Sheena, Prabhjot 18:09

June 25, 2015

Thread Author Time
Re: Slow query (planner insisting on using 'external merge' sort type) Mark Kirkwood 02:01

June 27, 2015

Thread Author Time
Does anyone have python code which digests pgbench -r output? Josh Berkus 19:29

June 30, 2015

Thread Author Time
Sudden connection and load average spikes with postgresql 9.3 eudald_v 14:52
Re: Sudden connection and load average spikes with postgresql 9.3 Tom Lane 15:37
Re: Sudden connection and load average spikes with postgresql 9.3 eudald_v 16:08
Re: Sudden connection and load average spikes with postgresql 9.3 Josh Berkus 22:56

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 9 10 11 12 13 15 17 18 19 23 24 25 27 30