Re: toast table growing indefinitely? Known problems?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: toast table growing indefinitely? Known problems?
Date: 2002-12-02 07:02:27
Message-ID: 12446.1038812547@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Philip Warner <pjw(at)rhyme(dot)com(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Teodor Sigaev 2002-12-02 09:02:31 Re: tsearch thoughts
Previous Message Philip Warner 2002-12-02 06:37:09 Re: toast table growing indefinitely? Known