| From: | Toby Corkindale <toby(dot)corkindale(at)strategicdata(dot)com(dot)au> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: tuning on ec2 |
| Date: | 2011-04-27 07:46:45 |
| Message-ID: | 4DB7C9E5.707@strategicdata.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hirenlad | 2011-04-27 07:47:46 | Create Database automatacally after silent installation of postgresql. ? |
| Previous Message | Joel Reymont | 2011-04-27 06:59:47 | Re: optimizing a cpu-heavy query |