Re: questions on toast tables

Поиск
Список
Период
Сортировка
От Warren Little
Тема Re: questions on toast tables
Дата
Msg-id 1146255429.16696.10.camel@wlittle.meridias.local
обсуждение исходный текст
Ответ на Re: questions on toast tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Tom,

I'll run the vacuum over the weekend and see how that goes.

And, yes, large pdf documents (4-24mb a piece).

thanks

On Fri, 2006-04-28 at 16:03 -0400, Tom Lane wrote:
> 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
--
Warren Little
Chief Technology Officer
Meridias Capital Inc
1018 W Atherton Dr
Salt Lake City, UT 84123
ph: 866.369.7763

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: questions on toast tables
Следующее
От: Rafael Martinez
Дата:
Сообщение: Re: Backing up large databases