Postgres Pro
Downloads
Home   >   mailing lists

Re: Yet another "drop table vs delete" question - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Yet another "drop table vs delete" question
Date
Msg-id 200904212228.29528.peter_e@gmx.net
Whole thread Raw
In response to Yet another "drop table vs delete" question  (marek.patrzek@gmail.com)
Responses Re: Yet another "drop table vs delete" question
List pgsql-general
Tree view 
On Tuesday 21 April 2009 20:26:24 marek.patrzek@gmail.com wrote:
> I was wondering if dropping a table is more efficient in PostgreSQL
> 8.x in comparison to deleting it's content ?

Yes, but if you are asking that question, you probably really want to use
TRUNCATE.

pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: PostgreSQL versus MySQL for GPS Data
Next
From: Christophe
Date:
Subject: Re: Yet another "drop table vs delete" question