| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Bob Dusek <redusek(at)gmail(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: performance config help |
| Date: | 2010-01-11 13:50:48 |
| Message-ID: | dcc563d11001110550s2af6d559l5db495d5e0fc6a57@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Mon, Jan 11, 2010 at 6:44 AM, Bob Dusek <redusek(at)gmail(dot)com> wrote:
> Hello,
>
> We're running Postgres 8.4.2 on Red Hat 5, on pretty hefty hardware...
>
> 4X E7420 Xeon, Four cores (for a total of 16 cores)
> 2.13 GHz, 8M Cache, 1066 Mhz FSB
> 32 Gigs of RAM
> 15 K RPM drives in striped raid
What method of striped RAID? RAID-5? RAID-10? RAID-4? RAID-0?
> Things run fine, but when we get a lot of concurrent queries running, we see
> a pretty good slow down.
Definte "a lot".
> We don't have much experience with this sort of hardware. Does anyone have
> an example config file we could use as a good starting point for this sort
> of hardware?
>
> We have a fair amount of row-level inserts and deletes going on (probably as
> much data is inserted and deleted in a day than permanently resides in the
> db).
What do the following commands tell you?
iostat -x 10 (first iteration doesn't count)
vmstat 10 (again, first iteration doesn't count)
top
What you're looking for is iowait / utilization.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | A. Kretschmer | 2010-01-11 14:07:53 | Re: performance config help |
| Previous Message | Bob Dusek | 2010-01-11 13:44:04 | performance config help |