2009/9/29 tomrevam <tomer(at)fabrix(dot)tv>:
> Brian Modra-2 wrote:
>> When did you last do an analyse and re-create indexes?
>> Is the table UPDATEd to or DELETEd from, or just INSERTed ?
>> Is your DB auto vacuuming?
> My DB is auto-vacuuming all the time. The specific table I'm talking about
> gets vacuumed at least every 2 hours (usually a little more frequently than
> Deletes are happening on the table at about the same rate as inserts (there
> are also some updates).
The index quite likely is in a poor state. You could try this:
create index ... (same parameters as existing index)
delete the old index.
rename the new index to the same name as the old one
repeat this for all indexes.
> View this message in context: http://www.nabble.com/query-is-taking-longer-time-after-a-while-tp25661219p25661758.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
Brian Modra Land line: +27 23 5411 462
Mobile: +27 79 69 77 082
5 Jan Louw Str, Prince Albert, 6930
Postal: P.O. Box 2, Prince Albert 6930
In response to
pgsql-general by date
|Next:||From: Mark Morgan Lloyd||Date: 2009-09-29 12:27:05|
|Subject: Re: Delphi connection ?|
|Previous:||From: Iain Barnett||Date: 2009-09-29 12:06:31|
|Subject: variables in ad hoc queries|