From: | Willo van der Merwe <willo(at)studentvillage(dot)co(dot)za> |
---|---|
To: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: PostgreSQL performance issues |
Date: | 2006-08-30 10:19:53 |
Message-ID: | 44F56649.9050604@studentvillage.co.za |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Luke Lonergan | 2006-08-30 10:34:03 | Re: PostgreSQL performance issues |
Previous Message | Matthew Sullivan | 2006-08-30 09:29:35 | performance problems. |