Reproducing query plans in empty database: can I just copy stats andsettings?

Поиск
Список
Период
Сортировка
От Guyren Howe
Тема Reproducing query plans in empty database: can I just copy stats andsettings?
Дата
Msg-id E72D67A1-66F6-461F-B4FC-AF032AFEDE84@gmail.com
обсуждение исходный текст
Ответы Re: Reproducing query plans in empty database: can I just copy statsand settings?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Дерево обсуждения
I work with Protected Health Information so have restricted access to an important database.

I would like to look into index and query changes for that database. It occurs to me that if I was able to reproduce the statistics and cost settings for the database, then Explain would produce identical results to the production database.

Can do this? Any other advice?

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

Предыдущее
От: Luca Ferrari
Дата:
Сообщение: Re: Error
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Reproducing query plans in empty database: can I just copy statsand settings?