| From: | "Stefano Nichele" <stefano(dot)nichele(at)gmail(dot)com> |
|---|---|
| To: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: understanding postgres issues/bottlenecks |
| Date: | 2009-01-07 21:02:05 |
| Message-ID: | bdb13b210901071302t1ef71ad0wb17408e7cca00a2d@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tue, Jan 6, 2009 at 7:45 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>wrote:
> I concur with Merlin you're I/O bound.
>
> Adding to his post, what RAID controller are you running, does it have
> cache, does the cache have battery backup, is the cache set to write
> back or write through?
At the moment I don't have such information. It's a "standard" RAID
controller coming with a DELL server. Is there any information I can have
asking to the SO ?
>
> Also, what do you get for this (need contrib module pgbench installed)
>
> pgbench -i -s 100
> pgbench -c 50 -n 10000
>
> ? Specifically transactions per second?
I'll run pgbench in the next days.
Cheers,
ste
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2009-01-07 21:31:10 | Re: understanding postgres issues/bottlenecks |
| Previous Message | david | 2009-01-07 19:54:45 | Re: Are random writes optimized sequentially by Linux kernel? |