Re: max_fsm_relations

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Adam Radłowski <adamr(at)informatyka(dot)gdansk(dot)pl>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin(at)postgresql(dot)org
Subject: Re: max_fsm_relations
Date: 2008-12-01 13:17:31
Message-ID: 20081201131731.GB4459@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Daniel Cristian Cruz 2008-12-01 13:26:42 Not so simple query and a half million loop
Previous Message Adam Radłowski 2008-11-30 19:52:25 Re: max_fsm_relations