From: | Willy-Bas Loos <willybas(at)gmail(dot)com> |
---|---|
To: | |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Performance degrades until dump/restore |
Date: | 2012-04-19 06:48:37 |
Message-ID: | CAHnozTi=1+eVE-2ErNve7WFXWKPpNWZzo5_vc++4y=d4Xonkug@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
what performance, insert or select?
On Thu, Apr 19, 2012 at 8:35 AM, Chris <bajasands(at)gmail(dot)com> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Willy-Bas Loos | 2012-04-19 06:59:26 | Re: remove some rows from resultset |
Previous Message | Chris Travers | 2012-04-19 06:47:39 | Re: Performance degrades until dump/restore |