| From: | Decibel! <decibel(at)decibel(dot)org> |
|---|---|
| To: | Ruben Rubio <ruben(at)rentalia(dot)com> |
| Cc: | Bill Moran <wmoran(at)collaborativefusion(dot)com>, Chris Mair <chris(at)1006(dot)org>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: [Solved] Postgres performance problem |
| Date: | 2007-08-30 17:31:51 |
| Message-ID: | 20070830173151.GP38801@decibel.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Thu, Aug 30, 2007 at 11:50:04AM +0200, Ruben Rubio wrote:
> As you may know, I do a vacuum full and a reindex database each day. I
> have logs that confirm that its done and I can check that everything was
> fine.
>
> So, this morning, I stopped the website, I stopped database, started it
> again. (I was around 200 days without restarting), then I vacuum
> database and reindex it (Same command as everyday) . Restart again, and
> run again the website.
>
> Now seems its working fine. But I really does not know where is the
> problem. Seems vacuum its not working fine? Maybe database should need
> a restart? I really don't know.
No, it sounds to me like you just weren't vacuuming aggressively enough
to keep up with demand.
--
Decibel!, aka Jim Nasby decibel(at)decibel(dot)org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2007-08-30 18:07:20 | Re: [Solved] Postgres performance problem |
| Previous Message | Ruben Rubio | 2007-08-30 09:50:04 | Re: [Solved] Postgres performance problem |