On 4/19/2012 1:35 AM, Chris wrote:
> Hello,
> I'm using PG 9.1. Data is streaming into one particularly large table
> (at 11 million rows currently) on a constant basis. It is pretty much
> all inserts, very little updates or deletes (if any).
> After a week or so, query performance on this table turns abysmal. If I
> dump the db, then restore, performance turns great for a while before it
> starts to bog down again in the following days.
Can you post an "explain analyze" when its fast, and then again when its
slow?
Are you leaving transactions open? (does "select * from
pg_stat_activity" show any "idle in transaction"?)
Does memory usage increase during the week so it starts using swap?
-Andy