| From: | Hannu Krosing <hannu(at)tm(dot)ee> |
|---|---|
| To: | Josh Rovero <rovero(at)sonalysts(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: TOAST performance (was Re: [GENERAL] Delete Performance) |
| Date: | 2001-11-19 21:11:22 |
| Message-ID: | 3BF9757A.5070505@tm.ee |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Pilsl | 2001-11-19 21:20:35 | Re: cant alter/create tables via odbc |
| Previous Message | Bruce Momjian | 2001-11-19 21:06:39 | Re: [HACKERS] bug or change in functionality in 7.2? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-11-19 21:27:41 | Re: OCTET_LENGTH is wrong |
| Previous Message | Hannu Krosing | 2001-11-19 21:11:09 | Re: Further open item (Was: Status of 7.2) |