Re: Delete operation VERY slow...

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Delete operation VERY slow...
Date: 2006-06-16 07:17:07
Message-ID: 20060616071707.GF19579@webserv.wug-glas.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

am 16.06.2006, um 15:58:46 +0900 mailte David Leangen folgendes:
>
> Hello!
>
> I am trying to delete an entire table. There are about 41,000 rows in
> the table (based on count(*)).
>
> I am using the SQL comment: delete from table;

Use TRUNCATE table.

Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47215, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Frith-Macdonald 2006-06-16 07:17:14 Why is my (empty) partial index query slow?
Previous Message David Leangen 2006-06-16 06:58:46 Delete operation VERY slow...