Home > mailing lists

Mailing lists [pgsql-performance]

4 June 2014

13:56 Possible performance regression in PostgreSQL 9.2/9.3? Linos
18:44 group commit Evgeny Shishkin
19:36 Re: Possible performance regression in PostgreSQL 9.2/9.3? Merlin Moncure
19:37 Re: group commit David G Johnston
19:58 Re: Possible performance regression in PostgreSQL 9.2/9.3? Linos
20:57 Re: Possible performance regression in PostgreSQL 9.2/9.3? Merlin Moncure
22:09 Re: Possible performance regression in PostgreSQL 9.2/9.3? Linos

5 June 2014

00:27 CPU load spikes when CentOS tries to reclaim 'cached' memory vlasmarias
01:32 parse/bind/execute Huang, Suya
01:58 Re: parse/bind/execute David G Johnston
02:20 Re: parse/bind/execute Huang, Suya
02:34 Re: parse/bind/execute David Johnston
05:22 High CPU load when 'free -m' shows low 'free' memory even though large 'cached' memory still available Vince Lasmarias
13:30 Re: Possible performance regression in PostgreSQL 9.2/9.3? Igor Neyman
13:36 Re: Possible performance regression in PostgreSQL 9.2/9.3? Linos
13:47 Re: High CPU load when 'free -m' shows low 'free' memory even though large 'cached' memory still available Tom Lane
15:58 Re: CPU load spikes when CentOS tries to reclaim 'cached' memory Jeff Janes
19:23 Re: CPU load spikes when CentOS tries to reclaim 'cached' memory Merlin Moncure
19:35 Seqscan on big table, when an Index-Usage should be possible Weinzierl Stefan
19:47 Re: CPU load spikes when CentOS tries to reclaim 'cached' memory Deron
19:57 Re: CPU load spikes when CentOS tries to reclaim 'cached' memory Merlin Moncure
20:03 Re: High CPU load when 'free -m' shows low 'free' memory even though large 'cached' memory still available Merlin Moncure
20:22 Re: Seqscan on big table, when an Index-Usage should be possible Igor Neyman
21:32 postgres files in use not staying in linux file cache Brio
23:57 Re: CPU load spikes when CentOS tries to reclaim 'cached' memory Vincent Lasmarias

6 June 2014

00:55 Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0 tim_wilson
02:02 Re: Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0 Tom Lane
06:43 Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0 tim_wilson
09:17 Re: CPU load spikes when CentOS tries to reclaim 'cached' memory Steven Crandell
11:22 Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0 tim_wilson
21:32 Re: CPU load spikes when CentOS tries to reclaim 'cached' memory Merlin Moncure
22:16 Scott Marlowe

7 June 2014

01:39 Re: Tom Lane
01:45 Re: Scott Marlowe

8 June 2014

15:53 Re: UNION and bad performance David G Johnston

10 June 2014

21:07 Re: postgres files in use not staying in linux file cache Shaun Thomas
21:37 Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0 tim_wilson
22:07 Re: Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0 Tom Lane
22:41 Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0 tim_wilson

12 June 2014

07:08 OFFSET/LIMIT - Disparate Performance w/ Go application Matt Silverlock
14:58 Re: OFFSET/LIMIT - Disparate Performance w/ Go application Tom Lane
16:15 Re: OFFSET/LIMIT - Disparate Performance w/ Go application Merlin Moncure
19:49 Re: OFFSET/LIMIT - Disparate Performance w/ Go application Andreas Joseph Krogh
19:58 Re: OFFSET/LIMIT - Disparate Performance w/ Go application Merlin Moncure
20:46 Re: OFFSET/LIMIT - Disparate Performance w/ Go application Jeff Janes
22:39 Re: OFFSET/LIMIT - Disparate Performance w/ Go application Matt Silverlock

13 June 2014

07:19 Re: postgres files in use not staying in linux file cache Tim Kane
16:11 Re: postgres files in use not staying in linux file cache Shaun Thomas

14 June 2014

02:10 Re: UNION and bad performance pinker
02:10 Query memory usage greatly in excess of work_mem * query plan steps Timothy Garnett
02:19 Re: Query memory usage greatly in excess of work_mem * query plan steps Franklin, Dan
14:26 Re: Query memory usage greatly in excess of work_mem * query plan steps Tom Lane

16 June 2014

18:14 Re: postgres files in use not staying in linux file cache Jeff Janes

17 June 2014

00:25 1 machine + master DB with postgres_fdw + multiple DB instances on different ports Gezeala M. Bacuño II
07:17 Re: 1 machine + master DB with postgres_fdw + multiple DB instances on different ports Albe Laurenz
16:42 Re: 1 machine + master DB with postgres_fdw + multiple DB instances on different ports Gezeala M. Bacuño II

18 June 2014

19:01 Unable to allocate 2G of shared memory on wheezy Dave Cramer
19:15 Re: Unable to allocate 2G of shared memory on wheezy Tom Lane
19:25 Re: Unable to allocate 2G of shared memory on wheezy Dave Cramer
19:34 Re: Unable to allocate 2G of shared memory on wheezy Dave Cramer
19:37 Re: Unable to allocate 2G of shared memory on wheezy Tom Lane

19 June 2014

04:39 huge pgstat.stat file on PostgreSQL 8.3.24 Huang, Suya
05:29 Re: huge pgstat.stat file on PostgreSQL 8.3.24 Pavel Stehule
05:35 Re: huge pgstat.stat file on PostgreSQL 8.3.24 Huang, Suya
05:42 Re: huge pgstat.stat file on PostgreSQL 8.3.24 Pavel Stehule
10:01 Re: huge pgstat.stat file on PostgreSQL 8.3.24 Tomas Vondra
23:44 Re: huge pgstat.stat file on PostgreSQL 8.3.24 Huang, Suya

20 June 2014

03:34 Re: huge pgstat.stat file on PostgreSQL 8.3.24 Pavel Stehule
10:14 Re: huge pgstat.stat file on PostgreSQL 8.3.24 Tomas Vondra

23 June 2014

07:20 GIST optimization to limit calls to operator on sub nodes Pujol Mathieu

24 June 2014

00:39 Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0 tim_wilson
07:07 Re: huge pgstat.stat file on PostgreSQL 8.3.24 Huang, Suya

25 June 2014

00:13 Re: postgres files in use not staying in linux file cache Brio
08:48 Guidelines on best indexing strategy for varying searches on 20+ columns Niels Kristian Schjødt
20:10 how to improve perf of 131MM row table? AJ Weber
20:49 Re: how to improve perf of 131MM row table? Shaun Thomas
21:40 Re: how to improve perf of 131MM row table? Aaron Weber
21:48 Re: Guidelines on best indexing strategy for varying searches on 20+ columns Merlin Moncure
21:55 Re: how to improve perf of 131MM row table? Shaun Thomas
22:30 Re: how to improve perf of 131MM row table? Aaron Weber

26 June 2014

13:26 Re: how to improve perf of 131MM row table? AJ Weber
13:57 Re: how to improve perf of 131MM row table? Matheus de Oliveira
14:05 Re: how to improve perf of 131MM row table? Shaun Thomas
14:07 Re: how to improve perf of 131MM row table? AJ Weber
14:14 Re: how to improve perf of 131MM row table? Matheus de Oliveira
14:23 Re: how to improve perf of 131MM row table? AJ Weber
14:37 Re: how to improve perf of 131MM row table? Shaun Thomas
14:50 Re: how to improve perf of 131MM row table? AJ Weber
15:35 Re: how to improve perf of 131MM row table? Claudio Freire
15:39 Re: how to improve perf of 131MM row table? AJ Weber
15:44 Re: how to improve perf of 131MM row table? Claudio Freire
15:48 Re: how to improve perf of 131MM row table? AJ Weber
16:19 Re: how to improve perf of 131MM row table? Claudio Freire
16:24 Re: how to improve perf of 131MM row table? Shaun Thomas
17:05 Re: how to improve perf of 131MM row table? Sébastien Lorion
18:02 Re: how to improve perf of 131MM row table? AJ Weber
20:15 Re: how to improve perf of 131MM row table? Jeff Janes
20:26 Re: how to improve perf of 131MM row table? Shaun Thomas
20:41 Re: how to improve perf of 131MM row table? Aaron Weber
20:43 Re: how to improve perf of 131MM row table? Aaron Weber
23:46 60 core performance with 9.3 Mark Kirkwood

27 June 2014

02:01 Re: 60 core performance with 9.3 Scott Marlowe
02:25 Re: 60 core performance with 9.3 Mark Kirkwood
07:31 Can improve 'limit 1' ? with slow function songtebo
09:20 Re: 60 core performance with 9.3 Andres Freund
09:31 Re: 60 core performance with 9.3 Mark Kirkwood

29 June 2014

08:14 Postgres Replaying WAL slowly Soni M
08:32 Re: Postgres Replaying WAL slowly Heikki Linnakangas
12:44 Re: Postgres Replaying WAL slowly Soni M
13:05 Re: Postgres Replaying WAL slowly Soni M
20:14 Re: GIST optimization to limit calls to operator on sub nodes Emre Hasegeli
20:30 Re: GIST optimization to limit calls to operator on sub nodes Tom Lane

30 June 2014

07:06 Re: Postgres Replaying WAL slowly Heikki Linnakangas
07:26 Re: GIST optimization to limit calls to operator on sub nodes Pujol Mathieu
07:33 Re: Guidelines on best indexing strategy for varying searches on 20+ columns Niels Kristian Schjødt
07:40 Re: GIST optimization to limit calls to operator on sub nodes Pujol Mathieu
09:25 Volatility - docs vs behaviour? Craig Ringer
14:04 Re: GIST optimization to limit calls to operator on sub nodes Tom Lane
14:46 Re: Postgres Replaying WAL slowly Soni M
15:49 Re: Volatility - docs vs behaviour? Tom Lane
16:14 Re: Postgres Replaying WAL slowly Heikki Linnakangas
17:04 Re: Postgres Replaying WAL slowly Jeff Frost
17:14 Re: Postgres Replaying WAL slowly Andres Freund
17:29 Re: Postgres Replaying WAL slowly Soni M
18:04 Re: Guidelines on best indexing strategy for varying searches on 20+ columns Jeff Janes
18:35 Re: Postgres Replaying WAL slowly Jeff Frost
18:39 Re: Postgres Replaying WAL slowly Andres Freund
18:41 Re: Postgres Replaying WAL slowly Pavel Stehule
19:17 Re: Postgres Replaying WAL slowly Jeff Frost
19:25 Re: Postgres Replaying WAL slowly Jeff Frost
19:32 Re: Postgres Replaying WAL slowly Tom Lane
19:42 Re: Postgres Replaying WAL slowly Jeff Frost
19:55 Re: Postgres Replaying WAL slowly Matheus de Oliveira
19:58 Re: Postgres Replaying WAL slowly Jeff Frost
20:15 Re: Postgres Replaying WAL slowly Andres Freund
20:21 Re: Postgres Replaying WAL slowly Jeff Frost
20:39 Re: Postgres Replaying WAL slowly Tom Lane
20:46 Re: Postgres Replaying WAL slowly Jeff Frost
21:52 Re: Postgres Replaying WAL slowly Jeff Frost
23:04 Re: Postgres Replaying WAL slowly Tom Lane
23:17 Re: Postgres Replaying WAL slowly Andres Freund
23:57 Re: Postgres Replaying WAL slowly Jeff Frost