Re: [Solved] Postgres performance problem - Mailing list pgsql-performance

From Vivek Khera
Subject Re: [Solved] Postgres performance problem
Date
Msg-id BB0FC482-905A-4E97-B81B-A6E21AE80CD4@khera.org
Whole thread Raw
In response to Re: [Solved] Postgres performance problem  (Mark Lewis <mark.lewis@mir3.com>)
List 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.


pgsql-performance by date:

Previous
From: Erik Jones
Date:
Subject: Re: 8.2 Autovacuum BUG ?
Next
From: Tom Lane
Date:
Subject: Re: 8.2 Autovacuum BUG ?