On Thu, Apr 19, 2012 at 8:35 AM, Chris <bajasands@xxxxxxxxx> 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.So far, the only answers I can find by searching is to turn autovacuum on. But it should already by on by default. The only setting that I have modified was to increase shared buffer.I'm not really sure where to go from here. Anybody have any suggestions on what the problem(s) might be and how to rectify it?Thanks!
--
"Patriotism is the conviction that your country is superior to all others because you were born in it." -- George Bernard Shaw
