Архив рассылок [pgsql-performance]

4 июня 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 июня 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 июня 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 июня 2014 г.

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

8 июня 2014 г.

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

10 июня 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 июня 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 июня 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 июня 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 июня 2014 г.

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

17 июня 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 июня 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 июня 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 июня 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 июня 2014 г.

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

24 июня 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 июня 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 июня 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 июня 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 июня 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 июня 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