This is a discussion on Postgres performance problem within the Pgsql Performance forums, part of the PostgreSQL category; --> On Aug 30, 2007, at 2:08 PM, Mark Lewis wrote: > If you're not running regular VACUUMs at all ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster |