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
>> Willo van der Merwe
In response to
pgsql-performance by date
|Next:||From: PFC||Date: 2006-08-29 15:07:10|
|Subject: Re: PostgreSQL performance issues|
|Previous:||From: Jignesh K. Shah||Date: 2006-08-29 15:03:38|
|Subject: Re: slow i/o|