Re: Deleting bytea, autovacuum, and 8.2/8.4 differences - Mailing list pgsql-performance

From Tom Lane
Subject Re: Deleting bytea, autovacuum, and 8.2/8.4 differences
Date
Msg-id 18524.1268666782@sss.pgh.pa.us
Whole thread Raw
In response to Deleting bytea, autovacuum, and 8.2/8.4 differences  ("fkater@googlemail.com" <fkater@googlemail.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Deleting bytea, autovacuum, and 8.2/8.4 differences
Next
From: VJK
Date:
Subject: Re: Deleting bytea, autovacuum, and 8.2/8.4 differences