extremely slow when execute select/delete for certain tables only...

From: kah_hang_ang(at)toray(dot)com(dot)my
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: extremely slow when execute select/delete for certain tables only...
Date: 2006-05-08 08:47:44
Message-ID: OFEE6DB213.EE330DAF-ON48257168.002AB1B5@pengroup.com.my
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I'm facing a very weird problem.
Recently our database run very slow when execute Delete/Select statement
for a few tables only..
The largest table only have 50K rows of data.

When I run the statement from pgAdmin although it is slow but not as slow
as run from webapp.
When I run the statement from webapp, it become extremely slow.
Even a simple delete statement will takes 20-40 minutes to complete.

I already vacuum those tables with full option but it still the same.

What could be the possible causes of this problem?
How can I solve it?

CPU - Intel Xeon 2.40 GHz
Memory - 1.5G
Postgresql version: 7.2.2

Thanks.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Markus Schaber 2006-05-08 09:21:16 Re: extremely slow when execute select/delete for certain
Previous Message Jim C. Nasby 2006-05-07 17:08:10 Re: pg_dump index creation order