Home > mailing lists

Mailing lists [pgsql-performance]

4 June 2014

16:56 Possible performance regression in PostgreSQL 9.2/9.3? Linos
21:44 group commit Evgeny Shishkin
22:36 Re: Possible performance regression in PostgreSQL 9.2/9.3? Merlin Moncure
22:37 Re: group commit David G Johnston
22:58 Re: Possible performance regression in PostgreSQL 9.2/9.3? Linos
23:57 Re: Possible performance regression in PostgreSQL 9.2/9.3? Merlin Moncure

5 June 2014

01:09 Re: Possible performance regression in PostgreSQL 9.2/9.3? Linos
03:27 CPU load spikes when CentOS tries to reclaim 'cached' memory vlasmarias
04:32 parse/bind/execute Huang, Suya
04:58 Re: parse/bind/execute David G Johnston
05:20 Re: parse/bind/execute Huang, Suya
05:34 Re: parse/bind/execute David Johnston
08:22 High CPU load when 'free -m' shows low 'free' memory even though large 'cached' memory still available Vince Lasmarias
16:30 Re: Possible performance regression in PostgreSQL 9.2/9.3? Igor Neyman
16:36 Re: Possible performance regression in PostgreSQL 9.2/9.3? Linos
16:47 Re: High CPU load when 'free -m' shows low 'free' memory even though large 'cached' memory still available Tom Lane
18:58 Re: CPU load spikes when CentOS tries to reclaim 'cached' memory Jeff Janes
22:23 Re: CPU load spikes when CentOS tries to reclaim 'cached' memory Merlin Moncure
22:35 Seqscan on big table, when an Index-Usage should be possible Weinzierl Stefan
22:47 Re: CPU load spikes when CentOS tries to reclaim 'cached' memory Deron
22:57 Re: CPU load spikes when CentOS tries to reclaim 'cached' memory Merlin Moncure
23:03 Re: High CPU load when 'free -m' shows low 'free' memory even though large 'cached' memory still available Merlin Moncure
23:22 Re: Seqscan on big table, when an Index-Usage should be possible Igor Neyman

6 June 2014

00:32 postgres files in use not staying in linux file cache Brio
02:57 Re: CPU load spikes when CentOS tries to reclaim 'cached' memory Vincent Lasmarias
03:55 Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0 tim_wilson
05:02 Re: Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0 Tom Lane
09:43 Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0 tim_wilson
12:17 Re: CPU load spikes when CentOS tries to reclaim 'cached' memory Steven Crandell
14:22 Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0 tim_wilson

7 June 2014

00:32 Re: CPU load spikes when CentOS tries to reclaim 'cached' memory Merlin Moncure
01:16 Scott Marlowe
04:39 Re: Tom Lane
04:45 Re: Scott Marlowe

8 June 2014

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

11 June 2014

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

12 June 2014

10:08 OFFSET/LIMIT - Disparate Performance w/ Go application Matt Silverlock
17:58 Re: OFFSET/LIMIT - Disparate Performance w/ Go application Tom Lane
19:15 Re: OFFSET/LIMIT - Disparate Performance w/ Go application Merlin Moncure
22:49 Re: OFFSET/LIMIT - Disparate Performance w/ Go application Andreas Joseph Krogh
22:58 Re: OFFSET/LIMIT - Disparate Performance w/ Go application Merlin Moncure
23:46 Re: OFFSET/LIMIT - Disparate Performance w/ Go application Jeff Janes

13 June 2014

01:39 Re: OFFSET/LIMIT - Disparate Performance w/ Go application Matt Silverlock
10:19 Re: postgres files in use not staying in linux file cache Tim Kane
19:11 Re: postgres files in use not staying in linux file cache Shaun Thomas

14 June 2014

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

16 June 2014

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

17 June 2014

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

18 June 2014

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

19 June 2014

07:39 huge pgstat.stat file on PostgreSQL 8.3.24 Huang, Suya
08:29 Re: huge pgstat.stat file on PostgreSQL 8.3.24 Pavel Stehule
08:35 Re: huge pgstat.stat file on PostgreSQL 8.3.24 Huang, Suya
08:42 Re: huge pgstat.stat file on PostgreSQL 8.3.24 Pavel Stehule
13:01 Re: huge pgstat.stat file on PostgreSQL 8.3.24 Tomas Vondra

20 June 2014

02:44 Re: huge pgstat.stat file on PostgreSQL 8.3.24 Huang, Suya
06:34 Re: huge pgstat.stat file on PostgreSQL 8.3.24 Pavel Stehule
13:14 Re: huge pgstat.stat file on PostgreSQL 8.3.24 Tomas Vondra

23 June 2014

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

24 June 2014

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

25 June 2014

03:13 Re: postgres files in use not staying in linux file cache Brio
11:48 Guidelines on best indexing strategy for varying searches on 20+ columns Niels Kristian Schjødt
23:10 how to improve perf of 131MM row table? AJ Weber
23:49 Re: how to improve perf of 131MM row table? Shaun Thomas

26 June 2014

00:40 Re: how to improve perf of 131MM row table? Aaron Weber
00:48 Re: Guidelines on best indexing strategy for varying searches on 20+ columns Merlin Moncure
00:55 Re: how to improve perf of 131MM row table? Shaun Thomas
01:30 Re: how to improve perf of 131MM row table? Aaron Weber
16:26 Re: how to improve perf of 131MM row table? AJ Weber
16:57 Re: how to improve perf of 131MM row table? Matheus de Oliveira
17:05 Re: how to improve perf of 131MM row table? Shaun Thomas
17:07 Re: how to improve perf of 131MM row table? AJ Weber
17:14 Re: how to improve perf of 131MM row table? Matheus de Oliveira
17:23 Re: how to improve perf of 131MM row table? AJ Weber
17:37 Re: how to improve perf of 131MM row table? Shaun Thomas
17:50 Re: how to improve perf of 131MM row table? AJ Weber
18:35 Re: how to improve perf of 131MM row table? Claudio Freire
18:39 Re: how to improve perf of 131MM row table? AJ Weber
18:44 Re: how to improve perf of 131MM row table? Claudio Freire
18:48 Re: how to improve perf of 131MM row table? AJ Weber
19:19 Re: how to improve perf of 131MM row table? Claudio Freire
19:24 Re: how to improve perf of 131MM row table? Shaun Thomas
20:05 Re: how to improve perf of 131MM row table? Sébastien Lorion
21:02 Re: how to improve perf of 131MM row table? AJ Weber
23:15 Re: how to improve perf of 131MM row table? Jeff Janes
23:26 Re: how to improve perf of 131MM row table? Shaun Thomas
23:41 Re: how to improve perf of 131MM row table? Aaron Weber
23:43 Re: how to improve perf of 131MM row table? Aaron Weber

27 June 2014

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

29 June 2014

11:14 Postgres Replaying WAL slowly Soni M
11:32 Re: Postgres Replaying WAL slowly Heikki Linnakangas
15:44 Re: Postgres Replaying WAL slowly Soni M
16:05 Re: Postgres Replaying WAL slowly Soni M
23:14 Re: GIST optimization to limit calls to operator on sub nodes Emre Hasegeli
23:30 Re: GIST optimization to limit calls to operator on sub nodes Tom Lane

30 June 2014

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