Postgres Pro
Downloads
Home   >   mailing lists

Question about DROP TABLE - Mailing list pgsql-hackers

From Michal Novotny
Subject Question about DROP TABLE
Date
Msg-id 5694DC01.1000709@trustport.com
Whole thread Raw
Responses Re: Question about DROP TABLE  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Question about DROP TABLE  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Tree view 
Dear PostgreSQL Hackers,
I've discovered an issue with dropping a large table (~5T). I was
thinking drop table is fast operation however I found out my assumption
was wrong.

Is there any way how to tune it to drop a large table in the matter of
seconds or minutes? Any configuration variable in the postgresql.conf or
any tune up options available?

PostgreSQL version used is PgSQL 9.4.

Thanks a lot!
Michal

pgsql-hackers by date:

Previous
From: Julien Rouhaud
Date:
Subject: Re: Removing Functionally Dependent GROUP BY Columns
Next
From: Pavel Stehule
Date:
Subject: Re: Question about DROP TABLE