Re: PostgreSQL performance issues

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

Merlin Moncure wrote:
> On 8/29/06, Willo van der Merwe <willo(at)studentvillage(dot)co(dot)za> wrote:
>
> >  and it has 743321 rows and a explain analyze select count(*) from
> > property_values;
>
> you have a number of options:
All good ideas and I'll be sure to implement them later.

> I am curious why you need to query the count of records in the log
> table to six digits of precision.
I'm not with you you here.
I'm drawing statistic for the my users on a per user basis in real-time, 
so there are a couple of where clauses attached.
> merlin
Hi Merlin,

This was just an example. All queries have slowed down. Could it be that 
I've reached some cut-off and now my disk is thrashing?

Currently the load looks like this:
Cpu0  : 96.8% us,  1.9% sy,  0.0% ni,  0.3% id,  0.0% wa,  0.0% hi,  1.0% si
Cpu1  : 97.8% us,  1.6% sy,  0.0% ni,  0.3% id,  0.0% wa,  0.0% hi,  0.3% si
Cpu2  : 96.8% us,  2.6% sy,  0.0% ni,  0.3% id,  0.0% wa,  0.0% hi,  0.3% si
Cpu3  : 96.2% us,  3.2% sy,  0.0% ni,  0.3% id,  0.0% wa,  0.0% hi,  0.3% si