Re: PostgreSQL performance issues

From: Willo van der Merwe <willo(at)studentvillage(dot)co(dot)za>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL performance issues
Date: 2006-08-29 15:06:02
Message-ID: 44F457DA.7060200@studentvillage.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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
>>
>
>

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message PFC 2006-08-29 15:07:10 Re: PostgreSQL performance issues
Previous Message Jignesh K. Shah 2006-08-29 15:03:38 Re: slow i/o