Postgres Pro
Downloads
Home   >   mailing lists

Re: Effects of dropping a large table - Mailing list pgsql-general

From Peter J. Holzer
Subject Re: Effects of dropping a large table
Date
Msg-id 20230723095138.vrlw4jlbafy6iktn@hjp.at
Whole thread Raw
In response to Re: Effects of dropping a large table  (Rob Sargent <robjsargent@gmail.com>)
Responses Re: Effects of dropping a large table  (Gus Spier <gus.spier@gmail.com>)
List pgsql-general
Tree view 
On 2023-07-22 16:37:39 -0400, Gus Spier wrote:
> Isn’t this a perfect opportunity to use the TRUNCATE command to
> quickly remove the data? And follow up by deleting the now empty
> tables?

What's the advantage of first truncating and then deleting a table over
just deleting it?

        hp

--
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"
Attachment

pgsql-general by date:

Previous
From: "Wen Yi"
Date:
Subject: [Beginner Question]Is there way to test the postgres's kernel function?
Next
From: Gus Spier
Date:
Subject: Re: Effects of dropping a large table