Re: TOAST performance (was Re: [GENERAL] Delete Performance)

Поиск
Список
Период
Сортировка
Искать
От
Hannu Krosing
Тема
Re: TOAST performance (was Re: [GENERAL] Delete Performance)
Дата
Msg-id
3BF9757A.5070505@tm.ee
Список
Дерево обсуждения
Re: TOAST performance (was Re: [GENERAL] Delete Performance) "Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at>


Josh Rovero wrote:

> Tom Lane wrote
>
>>
>> I did some experimentation here and found a rather surprising
>> dependency: the time to delete a bunch of data is pretty much
>> directly proportional to the disk space it occupies.  This says
>> that we're paying through the nose for having XLOG make copies
>> of about-to-be-modified pages.
>
Can't we somehow WAL only metadata and not the actual pages for
DELETEs - as delete is essentially (though currently not technically)
just metadata it should be a possible thing to do.

>> ------------------
>
Hannu



В списке pgsql-hackers по дате отправления
От: Hannu Krosing
Дата:
От: Marc G. Fournier
Дата:
Сообщение: Re: beta3
FAQ