Postgres Pro
Downloads
Home   >   mailing lists

Re: toast table growing indefinitely? Known problems? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: toast table growing indefinitely? Known problems?
Date
Msg-id 12446.1038812547@sss.pgh.pa.us
Whole thread Raw
In response to Re: toast table growing indefinitely? Known  (Philip Warner <pjw@rhyme.com.au>)
List pgsql-hackers
Tree view 
Philip Warner <pjw@rhyme.com.au> writes:
> Is there any way (other than VACUUM FULL) to recover the current lost space?

Probably not.  Plain VACUUM will reclaim any empty pages it happens to
see at the end of the table, but without a VACUUM FULL you won't get any
proactive effort to make the end-pages empty.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Philip Warner
Date:
Subject: Re: toast table growing indefinitely? Known
Next
From: Teodor Sigaev
Date:
Subject: Re: tsearch thoughts