Re: Question about DROP TABLE
| От | Pavel Stehule |
|---|---|
| Тема | Re: Question about DROP TABLE |
| Дата | |
| Msg-id | CAFj8pRCWbVhOfeyf9Gfd2sGSbq4+3Q1DB=2wktpggyQumeFR9Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | Question about DROP TABLE (Michal Novotny <michal.novotny@trustport.com>) |
| Ответы |
Re: Question about DROP TABLE
|
| Список | pgsql-hackers |
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 по дате отправления: