Re: tuning on ec2

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 the above?

Those two options don't really affect the number of requests per second,
as I understand things.. They're more about how many simultaneous
requests you can have going.

Make sure you have sensible SQL for the queries you're making, and have
some fast disks. If you're doing a lot of read-only queries, consider
whether you can cache the results in your application rather than
requesting them from the DB every time.

-Toby