Re: Rather large LA

[Damon Snyder <damon@xxxxxxxxxxxxxxx>]

If you are not doing so already, another approach to preventing the slam at startup would be to implement some form of caching either in memcache or an http accelerator such as varnish (https://www.varnish-cache.org/). Depending on your application and the usage patterns, you might be able to fairly easily insert varnish into your web stack.

Damon

On Tue, Sep 6, 2011 at 12:47 PM, Alan Hodgson <ahodgson@xxxxxxxxx> wrote:

On September 6, 2011 12:35:35 PM Richard Shaw wrote:
> Thanks for the advice, It's one under consideration at the moment.   What
> are your thoughts on increasing RAM and shared_buffers?
>

If it's running OK after the startup rush, and it seems to be, I would leave
them alone. More RAM is always good, but I don't see it helping with this
particular issue.

--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance