Postgres Pro
Downloads
Home   >   mailing lists

Re: questions on toast tables - Mailing list pgsql-admin

From Tom Lane
Subject Re: questions on toast tables
Date
Msg-id 15655.1146254635@sss.pgh.pa.us
Whole thread Raw
In response to questions on toast tables  (Warren Little <warren.little@meridiascapital.com>)
Responses Re: questions on toast tables  (Warren Little <warren.little@meridiascapital.com>)
Re: questions on toast tables  (Warren Little <warren.little@meridiascapital.com>)
List pgsql-admin
Tree view 
Warren Little <warren.little@meridiascapital.com> writes:
> 3) I know that once upon a time the table had a bytea column, but that
> was dropped.  Do I need to do a full vacuum on that table to get rid of
> the related toast data?

Yup.  (I take it it was a pretty darn bulky bytea column, too)

            regards, tom lane

pgsql-admin by date:

Previous
From: Robin Iddon
Date:
Subject: Re: Backing up large databases
Next
From: Warren Little
Date:
Subject: Re: questions on toast tables