Hell, Robert wrote:
> I tried different other tools for random IO (including a self written one
> which does random lseek and read).
>
> This tool, started during one of our tests, achieves 2 iops (8k each).
> Started alone I get something about 1,500 iops with an avg latency of 100 ms.
1500 iop
PROTECTED] On Behalf Of Ivan Voras
Sent: Dienstag, 08. April 2008 11:03
To: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Looking for bottleneck during load test
Hell, Robert wrote:
> > I tried different other tools for random IO (including a self
written one which does random lse
Hell, Robert wrote:
> > I tried different other tools for random IO (including a self
written one which does random lseek and read).
> >
> > This tool, started during one of our tests, achieves 2 iops (8k each).
> > Started alone I get something about 1,500 iops with an avg latency
of 100 ms.
1500
In response to Greg Smith <[EMAIL PROTECTED]>:
> On Mon, 7 Apr 2008, Bill Moran wrote:
>
> > You know, with all the performance problems people have been bringing up
> > with regard to SANs, I'm putting SAN in the same category as RAID-5 ...
>
> Not really fair, because unlike RAID5 it's at leas
On Mon, 7 Apr 2008, Bill Moran wrote:
You know, with all the performance problems people have been bringing up
with regard to SANs, I'm putting SAN in the same category as RAID-5 ...
Not really fair, because unlike RAID5 it's at least *possible* to get good
write performance out of a SAN. Ju
x27;m putting SAN in the same category as RAID-5 ...
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ivan Voras
> Sent: Montag, 07. April 2008 14:38
> To: pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] Looking for bottleneck during load test
&
) - are those ~7 MB/s really our
bottleneck?
Any other tuning ideas?
Regards,
Robert
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ivan Voras
Sent: Montag, 07. April 2008 14:38
To: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Looking for
Hell, Robert wrote:
> We have a PostgreSQL 8.2.7 database (~230 GB) running on a machine with 8
> Intel Xeon Cores and 32 GB RAM (64-bit Linux 2.6.18). Data is stored on an
> EMC² CLARiiON on RAID 1/0 (8 x 146 GB 15k rpm).
> When we do random I/O with a small test tool (reading random 8k blocks
