Postgres Pro
Downloads
Home   >   mailing lists

Re: Delete operation VERY slow... - Mailing list pgsql-performance

From A. Kretschmer
Subject Re: Delete operation VERY slow...
Date
Msg-id 20060616071707.GF19579@webserv.wug-glas.de
Whole thread Raw
In response to Delete operation VERY slow...  (David Leangen <postgres@leangen.net>)
List pgsql-performance
Tree view 
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    ===

pgsql-performance by date:

Previous
From: David Leangen
Date:
Subject: Delete operation VERY slow...
Next
From: "Gourish Singbal"
Date:
Subject: Re: Delete operation VERY slow...