Re: Infrastructure monitoring

> -----Original Message-----
> From: Dave Page [mailto:dpage(at)vale-housing(dot)co(dot)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(at)postgresql(dot)org; Jim C. Nasby
> Subject: Re: [pgsql-www] Infrastructure monitoring
>
>
>
>
> On 14/1/06 21:37, "John Hansen" <john(at)geeknet(dot)com(dot)au> wrote:
>
> > Joshua D. Drake [mailto:jd(at)commandprompt(dot)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