Postgres Pro
Downloads
Home   >   mailing lists

Re: Question about DROP TABLE - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Question about DROP TABLE
Date
Msg-id CAFj8pRCWbVhOfeyf9Gfd2sGSbq4+3Q1DB=2wktpggyQumeFR9Q@mail.gmail.com
Whole thread Raw
In response to Question about DROP TABLE  (Michal Novotny <michal.novotny@trustport.com>)
Responses Re: Question about DROP TABLE  (Michal Novotny <michal.novotny@trustport.com>)
List pgsql-hackers
Tree view
Hi

2016-01-12 11:57 GMT+01:00 Michal Novotny <michal.novotny@trustport.com>:
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?

drop table should be fast.

There can be two reasons why not:

1. locks - are you sure, so this statement didn't wait on some lock?

2. filesystem issue  - can you check the speed of rm 5TB file on your IO?

Regards

Pavel



 

PostgreSQL version used is PgSQL 9.4.

Thanks a lot!
Michal


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

pgsql-hackers by date:

Previous
From: Michal Novotny
Date:
Subject: Question about DROP TABLE
Next
From: Andres Freund
Date:
Subject: Re: Question about DROP TABLE