Home > mailing lists

Mailing lists [pgsql-performance]

1 June 2015

08:38 Re: Postgres is using 100% CPU Ashik S L
16:20 Re: Postgres is using 100% CPU Merlin Moncure
19:03 Slow hash join performance with many batches Alex Adriaanse
20:58 Re: Slow hash join performance with many batches Tom Lane
22:11 Re: Fastest way / best practice to calculate "next birthdays" Kevin Grittner
22:35 Re: Postgres is using 100% CPU Scott Marlowe
23:52 Connection time when using SSL Marco Di Cesare

2 June 2015

00:21 Re: Connection time when using SSL Tomas Vondra
10:47 Re: Postgres is using 100% CPU Graeme B. Bell
10:58 Re: Postgres is using 100% CPU Graeme B. Bell
11:20 Re: Postgres is using 100% CPU Ashik S L

3 June 2015

15:21 How to reduce writing on disk ? (90 gb on pgsql_tmp) ben.play
15:44 Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) David G. Johnston
16:11 Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) amulsul
16:27 Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) chiru r
16:51 Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Tomas Vondra
17:06 Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) ben.play
17:56 Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Tomas Vondra
18:09 Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Scott Marlowe
20:06 Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Claudio Freire
22:25 Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Tomas Vondra

4 June 2015

00:18 Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Scott Marlowe
00:59 Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Claudio Freire
01:16 Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Tomas Vondra
01:29 Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Joshua D. Drake
02:54 Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Yves Dorfsman
03:22 Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Tomas Vondra
03:53 Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Scott Marlowe
03:59 Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Scott Marlowe
04:19 Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Mark Kirkwood
14:07 Need more IOPS? This should get you drooling... (5xnvme drives) Graeme B. Bell
14:24 Re: Need more IOPS? This should get you drooling... (5xnvme drives) Graeme B. Bell
14:30 Re: Need more IOPS? This should get you drooling... (5xnvme drives) Dorian Hoxha
14:36 Re: Need more IOPS? This should get you drooling... (5xnvme drives) Graeme B. Bell
17:46 Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Tomas Vondra

5 June 2015

20:54 Query running slow for only one specific id. (Postgres 9.3) version Sheena, Prabhjot
21:05 Re: Query running slow for only one specific id. (Postgres 9.3) version Igor Neyman
21:24 Re: Query running slow for only one specific id. (Postgres 9.3) version Steve Crawford
21:43 Re: Query running slow for only one specific id. (Postgres 9.3) version Sheena, Prabhjot
21:46 Re: Query running slow for only one specific id. (Postgres 9.3) version Igor Neyman
22:28 Re: [GENERAL] Re: Query running slow for only one specific id. (Postgres 9.3) version Steve Crawford
22:34 Re: Re: [GENERAL] Re: Query running slow for only one specific id. (Postgres 9.3) version Steve Crawford

6 June 2015

01:35 Re: Query running slow for only one specific id. (Postgres 9.3) version Matheus de Oliveira

9 June 2015

18:58 Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) ben.play
19:04 Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Claudio Freire

10 June 2015

15:39 Slow query - lots of temporary files. Johann Spies
16:02 Re: Slow query - lots of temporary files. Claudio Freire
16:42 Re: Slow query - lots of temporary files. Johann Spies
17:53 Re: Slow query - lots of temporary files. Tomas Vondra
20:32 Row estimates off by two orders of magnitude with hstore Patrick Krecker
21:32 Re: Row estimates off by two orders of magnitude with hstore Merlin Moncure
22:40 Re: Row estimates off by two orders of magnitude with hstore Josh Berkus
23:01 Re: Row estimates off by two orders of magnitude with hstore Merlin Moncure
23:55 Re: Row estimates off by two orders of magnitude with hstore Patrick Krecker

11 June 2015

00:08 Re: Row estimates off by two orders of magnitude with hstore Merlin Moncure
00:37 Re: Row estimates off by two orders of magnitude with hstore Patrick Krecker
01:08 Re: Row estimates off by two orders of magnitude with hstore Merlin Moncure
11:56 Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) ben.play
15:48 Re: How to reduce writing on disk ? (90 gb on pgsql_tmp) Claudio Freire

12 June 2015

03:18 Slow query: Postgres chooses nested loop over hash join, whery by hash join is much faster, wrong number of rows estimated Sasa Vilic
18:04 Re: Slow query - lots of temporary files. Johann Spies
20:57 pg bouncer issue what does sv_used column means Sheena, Prabhjot
23:26 Re: pg bouncer issue what does sv_used column means Xenofon Papadopoulos
23:40 Are there tuning parameters that don't take effect immediately? Michael Nolan
23:52 Re: Are there tuning parameters that don't take effect immediately? David G. Johnston

13 June 2015

00:00 Re: Are there tuning parameters that don't take effect immediately? Joshua D. Drake
00:13 Re: Are there tuning parameters that don't take effect immediately? Michael Nolan
00:37 Re: pg bouncer issue what does sv_used column means Sheena, Prabhjot
00:50 Re: pg bouncer issue what does sv_used column means Andrew Dunstan
00:57 Re: pg bouncer issue what does sv_used column means ktm@rice.edu
20:27 Do work_mem and shared buffers have 1g or 2g limit on 64 bit linux? Kaijiang Chen
20:43 Re: Do work_mem and shared buffers have 1g or 2g limit on 64 bit linux? Joshua D. Drake
21:10 Re: Do work_mem and shared buffers have 1g or 2g limit on 64 bit linux? Joe Conway

15 June 2015

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

18 June 2015

20:09 PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) Sheena, Prabhjot
20:16 Re: PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) ktm@rice.edu
20:17 Re: PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) Will Platnick
20:41 Re: PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) Sheena, Prabhjot
20:52 How to calculate statistics for one column Irineu Ruiz
21:10 Re: PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) ktm@rice.edu
21:16 Re: How to calculate statistics for one column Igor Neyman
21:18 Re: How to calculate statistics for one column Irineu Ruiz
21:24 Re: How to calculate statistics for one column Igor Neyman
22:10 Re: How to calculate statistics for one column Irineu Ruiz
22:19 Re: PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) Sheena, Prabhjot
22:39 Techniques to Avoid Temp Files Duane Murphy
22:47 Re: PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) Jerry Sievers
22:53 Re: How to calculate statistics for one column Igor Neyman
22:59 Re: PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) Igor Neyman
23:02 Re: PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) ktm@rice.edu
23:26 Re: PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) Sheena, Prabhjot

19 June 2015

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

24 June 2015

00:05 Re: Slow query (planner insisting on using 'external merge' sort type) Jim Nasby
21:09 pgbouncer issue Sheena, Prabhjot

25 June 2015

07:07 Re: Slow query (planner insisting on using 'external merge' sort type) Mark Kirkwood

27 June 2015

22:29 Does anyone have python code which digests pgbench -r output? Josh Berkus

30 June 2015

17:52 Sudden connection and load average spikes with postgresql 9.3 eudald_v
18:37 Re: Sudden connection and load average spikes with postgresql 9.3 Tom Lane
19:09 Re: Sudden connection and load average spikes with postgresql 9.3 eudald_v