Re: Yet another "drop table vs delete" question

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: marek(dot)patrzek(at)gmail(dot)com
Subject: Re: Yet another "drop table vs delete" question
Date: 2009-04-21 19:28:28
Message-ID: 200904212228.29528.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tuesday 21 April 2009 20:26:24 marek(dot)patrzek(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2009-04-21 19:30:06 Re: Yet another "drop table vs delete" question
Previous Message Stephen Frost 2009-04-21 19:26:11 Re: PostgreSQL versus MySQL for GPS Data