Question about DROP TABLE

Поиск
Список
Период
Сортировка
Искать
От
Michal Novotny
Тема
Question about DROP TABLE
Дата
Msg-id
5694DC01.1000709@trustport.com
Список
Дерево обсуждения
Question about DROP TABLE Michal Novotny <michal.novotny@trustport.com>
Re: Question about DROP TABLE Andres Freund <andres@anarazel.de>
Re: Question about DROP TABLE Michal Novotny <michal.novotny@trustport.com>
Re: Question about DROP TABLE Andres Freund <andres@anarazel.de>
Re: Question about DROP TABLE Michal Novotny <michal.novotny@trustport.com>
Re: Question about DROP TABLE Michal Novotny <michal.novotny@trustport.com>
Re: Question about DROP TABLE Pavel Stehule <pavel.stehule@gmail.com>
Re: Question about DROP TABLE Michal Novotny <michal.novotny@trustport.com>
Re: Question about DROP TABLE Pavel Stehule <pavel.stehule@gmail.com>
Re: Question about DROP TABLE Andres Freund <andres@anarazel.de>
Re: Question about DROP TABLE Michal Novotny <michal.novotny@trustport.com>
Re: Question about DROP TABLE Marko Tiikkaja <marko@joh.to>
Re: Question about DROP TABLE Pavel Stehule <pavel.stehule@gmail.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?

PostgreSQL version used is PgSQL 9.4.

Thanks a lot!
Michal


В списке pgsql-hackers по дате отправления
От: Julien Rouhaud
Дата:
От: Pavel Stehule
Дата:
Сообщение: Re: Question about DROP TABLE
FAQ