> -----Original Message-----
> From: Dave Page [mailto:dpage@vale-housing.co.uk]
> Sent: Sunday, January 15, 2006 8:41 AM
> To: John Hansen; Joshua D. Drake
> Cc: Guido Barosio; Marc G. Fournier; Josh Berkus;
> pgsql-www@postgresql.org; Jim C. Nasby
> Subject: Re: [pgsql-www] Infrastructure monitoring
>
>
>
>
> On 14/1/06 21:37, "John Hansen" <john@geeknet.com.au> wrote:
>
> > Joshua D. Drake [mailto:jd@commandprompt.com] Wrote
> >
> >> Sure we could help and we are happy to. John what types of
> machines
> >> are we talking about here?
> >
> > You will need an x86-32 (Preferably SMP) with at least 2G of ram
> > running linux.
> > (Gentoo is known to work).
> > ASPseek currently uses 11G of HD space for the search.
>
> What sort of storage are you currently running? How many spindles etc?
>
> Regards, Dave.
>
4x80G Seagate IDE (PATA ST380011A) Software Raid0 on 2 x Promise Ultra100 Controllers in 66Mhz slots.
The system has another 4x80 Seagate IDE (PATA ST380021A) but they are slower models, in Software Raid5, used for
backup.
Pgbench reports ~800tps with: pgbench -i -s50 test; reboot; pgbench -s50 -c25 -t1000 test;
(Reboot done to completely flush any cached data)
Systained thruput on the disk sybsystem is roughly 130Mbytes/second in both directions.
LVM on top of software raid, XFS filesystems.
... John