On 27/04/11 01:34, Joel Reymont wrote:
On Apr 26, 2011, at 4:31 PM, Scott Marlowe wrote:
What's your work_mem and max_connections set to?
I have the default settings, e.g. work_mem = 1MB and max_connections = 100.
I'm looking to process 400 requests per second, though. What should I use for
On Tue, Apr 26, 2011 at 9:34 AM, Joel Reymont wrote:
>
> On Apr 26, 2011, at 4:31 PM, Scott Marlowe wrote:
>
>> It's a reasonable start. However, if you consistently using less than
>> that in aggregate then lowering it is fine.
>
> Is there a way to tell if I consistently use less than that in a
On Apr 26, 2011, at 4:31 PM, Scott Marlowe wrote:
> It's a reasonable start. However, if you consistently using less than
> that in aggregate then lowering it is fine.
Is there a way to tell if I consistently use less than that in aggregate?
> What's your work_mem and max_connections set to?
On Tue, Apr 26, 2011 at 8:59 AM, Joel Reymont wrote:
> I'm running pgsql on an m1.large EC2 instance with 7.5gb available memory.
>
> The free command shows 7gb of free+cached. My understand from the docs is
> that I should dedicate 1.75gb to shared_buffers (25%) and set
> effective_cache_size t
I'm running pgsql on an m1.large EC2 instance with 7.5gb available memory.
The free command shows 7gb of free+cached. My understand from the docs is that
I should dedicate 1.75gb to shared_buffers (25%) and set effective_cache_size
to 7gb.
Is this correct? I'm running 64-bit Ubuntu 10.10, e.g