Skip site navigation (1) Skip section navigation (2)

Re: max_fsm_relations

From: Adam Radłowski <adamr(at)informatyka(dot)gdansk(dot)pl>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
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 16:43:19
Message-ID: 49341427.7020601@informatyka.gdansk.pl (view raw or flat)
Thread:
Lists: pgsql-admin
Now I got full information. Big thanks.
Adam

Alvaro Herrera pisze:
> 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.
> 

In response to

pgsql-admin by date

Next:From: Isabella GhiureaDate: 2008-12-01 20:50:59
Subject: change user passwd
Previous:From: Daniel Cristian CruzDate: 2008-12-01 15:21:15
Subject: Re: Not so simple query and a half million loop

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group