Re: About the performance of startup after dropping many tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: About the performance of startup after dropping many tables
Дата
Msg-id 5095.1298000244@sss.pgh.pa.us
обсуждение исходный текст
Ответ на About the performance of startup after dropping many tables  (Gan Jiadong <ganjd@huawei.com>)
Ответы Re: About the performance of startup after dropping many tables  (Gan Jiadong <ganjd@huawei.com>)
Re: About the performance of startup after dropping many tables  (Gan Jiadong <ganjd@huawei.com>)
Re: About the performance of startup after dropping many tables  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
Gan Jiadong <ganjd@huawei.com> writes:
> we have PG 8.3.13 in our system. When running performance cases, we find the
> startup recovery cost about 3 minutes. It is too long in our system. 

Maybe you should rethink the assumption that dropping 40000 tables is a
cheap operation.  Why do you have that many in the first place, let
alone that many that you drop and recreate frequently?  Almost
certainly, you need a better-conceived schema.
        regards, tom lane

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Mark Kirkwood
Дата:
Сообщение: WIP - Add ability to constrain backend temporary file space
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Add support for logging the current role