Re: TOAST performance (was Re: [GENERAL] Delete Performance) - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: TOAST performance (was Re: [GENERAL] Delete Performance)
Date
Msg-id 3BF9757A.5070505@tm.ee
Whole thread Raw
In response to TOAST performance (was Re: [GENERAL] Delete Performance)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: TOAST performance (was Re: [GENERAL] Delete
List pgsql-hackers

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 by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Further open item (Was: Status of 7.2)
Next
From: "Marc G. Fournier"
Date:
Subject: Re: beta3