Re: max_fsm_relations - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: max_fsm_relations
Date
Msg-id 20081201131731.GB4459@alvh.no-ip.org
Whole thread Raw
In response to Re: max_fsm_relations  (Adam Radłowski <adamr@informatyka.gdansk.pl>)
Responses Re: max_fsm_relations  (Adam Radłowski <adamr@informatyka.gdansk.pl>)
List pgsql-admin
Adam Radłowski wrote:
> So, are You suggesting, that at the time of full database vacuuming,
> some of tables are not vacuumed, when "max_fsm_relations" is to small ?

No.  They will all be vacuumed.  The difference is that the space
reclaimed by vacuum will not be reused unless it is recorded by the FSM.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-admin by date:

Previous
From: Adam Radłowski
Date:
Subject: Re: max_fsm_relations
Next
From: "Daniel Cristian Cruz"
Date:
Subject: Not so simple query and a half million loop