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).
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.
In response to
pgsql-general by date
|Next:||From: Iain Barnett||Date: 2009-09-29 12:06:31|
|Subject: variables in ad hoc queries|
|Previous:||From: Merlin Moncure||Date: 2009-09-29 11:54:37|
|Subject: Re: computed values in plpgsql|