random slow query

From: Sean Ma <seanxma(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: random slow query
Date: 2009-06-29 13:33:40
Message-ID: 8c38075e0906290633k27a94661w7e1395fea41e00d9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I have a table about 50 million rows. There are a few writers to pump
data into the table at the rate of 40000 row/hours. Most the time, the
SELECT is less than 100 ms. However sometime it is very slow, from 30
seconds to 500 seconds. The database is vacuum analyze regularly.

One months ago, this type of slow query happened about a few time per
day. But recently, the slow query happens more frequent at the rate of
once every 10 minutes or less. There seesm not relation to the
database loading or the type of query. If I manually execute these
query, it is returns in less than 1 seconds.

I just wonder where should I start to look?

Thanks

Shawn.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andres Freund 2009-06-29 13:36:05 Re: random slow query
Previous Message Scott Mead 2009-06-29 12:54:40 Re: Terrible Write Performance of a Stored Procedure