Re: PostgreSQL performance issues

[Willo van der Merwe <willo(at)studentvillage(dot)co(dot)za>]

Joshua D. Drake wrote:
> > 4 1/2 seconds for a count(*) ? This seems a bit rough - is there 
> > anything else I can try to optimize my Database? You can imagine that 
> > slightly more complex queries goes out the roof.
>
> Well a couple of things.
>
> 1. You put all your money in the wrong place.. 1 hard drive!!??!!
Yes, I realize 1 hard drive could cause a bottle neck, but on average 
I'm sitting on a 1-2% wait for IO.
> 2. What is your maintenance regimen? Vacuum, Analyze????
I'm doing a daily VACUUM ANALYZE, but just to be on the safe side, I 
performed one manually before I ran my test, thinking that I might have 
to up the frequency.
> Joshua D. Drake
>
> > Any help appreciated
> >
> > Regards
> >
> > Willo van der Merwe