| From: | Joel Reymont <joelr1(at)gmail(dot)com> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: tuning on ec2 |
| Date: | 2011-04-26 15:34:32 |
| Message-ID: | 2289E29A-1A00-4B17-AD74-BDBE17A89485@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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?
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?
Thanks, Joel
--------------------------------------------------------------------------
- for hire: mac osx device driver ninja, kernel extensions and usb drivers
---------------------+------------+---------------------------------------
http://wagerlabs.com | @wagerlabs | http://www.linkedin.com/in/joelreymont
---------------------+------------+---------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Willy-Bas Loos | 2011-04-26 15:36:49 | [GENERAL]auto vacuum during restore |
| Previous Message | Scott Marlowe | 2011-04-26 15:31:33 | Re: tuning on ec2 |