Re: Database size

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Database size
Дата
Msg-id 4B4B71D2.5090405@hogranch.com
обсуждение исходный текст
Ответ на Re: Database size  (Francisco Reyes <lists@stringsutils.com>)
Список pgsql-general
Francisco Reyes wrote:
> I say "don't believe" because I don't recall if byteA was stored in
> the table itself or was stored outside using TOAST.. so I am not sure
> about how/when space is released for it.

like all other data, that depends on the size of the data.    if the
entire row (tuple) is under 4K (I think, don't quote me), it will be
stored in the table, otherwise it will be toasted and stored in the
PG_TOAST tables.... which also need vacuuming....



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

Предыдущее
От: Raymond O'Donnell
Дата:
Сообщение: Re: Database size
Следующее
От: Steve Crawford
Дата:
Сообщение: Re: Database size