Search Postgresql Archives

Re: Performance degrades until dump/restore

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



what performance, insert or select?

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux