Re: [Solved] Postgres performance problem

From: Vivek Khera <vivek(at)khera(dot)org>
To: Pgsql performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: [Solved] Postgres performance problem
Date: 2007-08-31 19:36:37
Message-ID: BB0FC482-905A-4E97-B81B-A6E21AE80CD4@khera.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


On Aug 30, 2007, at 2:08 PM, Mark Lewis wrote:

> If you're not running regular VACUUMs at all but are instead
> exclusively
> running VACUUM FULL, then I don't think you would see warnings about
> running out of fsm enties, which would explain why you did not notice
> the bloat. I haven't confirmed that though, so I might be wrong.

If you run vacuum full, your pages should be full so there should be
very small if any number of pages in the free space map. Thus, there
would be no warnings.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2007-08-31 19:48:43 Re: 8.2 Autovacuum BUG ?
Previous Message Erik Jones 2007-08-31 19:35:49 Re: 8.2 Autovacuum BUG ?