Re: Deleting bytea, autovacuum, and 8.2/8.4 differences

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Deleting bytea, autovacuum, and 8.2/8.4 differences
Дата
Msg-id 18524.1268666782@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Deleting bytea, autovacuum, and 8.2/8.4 differences  ("fkater@googlemail.com" <fkater@googlemail.com>)
Список pgsql-performance
Matthew Wakeling <matthew@flymine.org> writes:
> On Mon, 15 Mar 2010, Tom Lane wrote:
>> If deleting a whole table is significant for you performance-wise,
>> you might look into using TRUNCATE instead.

> Might you still end up with a normal delete operation
> on the TOAST table when performing a TRUNCATE on the owner table?

No, you get a TRUNCATE on its toast table too.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Deleting bytea, autovacuum, and 8.2/8.4 differences
Следующее
От: VJK
Дата:
Сообщение: Re: Deleting bytea, autovacuum, and 8.2/8.4 differences