Re: [Re] Need help with postgresql/apache/php optimisation

On Wed, 18 Feb 2004, Richard Huxton wrote:

> On Wednesday 18 February 2004 21:53, scott.marlowe wrote:
> >
> > If you could just get them to add some more memory you'd probably be ok.
> > 256 meg would be ok if it was nothing but a pgsql server, but having to
> > host apache and whatever else it's really slim pickins.
> >
> > Plus if you could get another IDE drive put in and mirror the first one it
> > might help, especially for parallel access.
>
> You're all spoilt - why when I was a lad we had 1 floppy disk between 12 of
> us, and we were happy...
>
> Seriously though Scott, he's only handling 3000 hits per day, with a target of
> 5000. I'm not saying it's a speed machine, but we should be good for that in
> 256MB.

Oh my god, I just saw that.  I thought it was like 5000 an hour or maybe a
minute.

I am spoilt.  our newest server, which is a LAPP server, can do something
like 1,000,000 transactions an hour under pgbench, and it's not heavily
tuned, and is running 7.2.4.

I wonder how complex the queries must be to be that slow...