Matthew Wakeling <matthew(at)flymine(dot)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
In response to
pgsql-performance by date
|Next:||From: VJK||Date: 2010-03-15 15:28:15|
|Subject: Re: Deleting bytea, autovacuum, and 8.2/8.4 differences|
|Previous:||From: Matthew Wakeling||Date: 2010-03-15 15:18:07|
|Subject: Re: Deleting bytea, autovacuum, and 8.2/8.4 differences |