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 по дате отправления