Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group