Re: Slow performance after restoring a dump

Поиск
Список
Период
Сортировка
От David Osborne
Тема Re: Slow performance after restoring a dump
Дата
Msg-id CAKmpXCduMKf=iO=YjKQcKgfd9V4jS-aKD_JJfvMTYEhQOv6ASQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Slow performance after restoring a dump  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Slow performance after restoring a dump  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Дерево обсуждения
Hi, yes I've run "analyse" against the newly restored database. Should that be enough?

On 19 March 2018 at 15:35, Tom Lane <tgl@sss.pgh.pa.us> wrote:
David Osborne <david@qcode.co.uk> writes:

The first question people will ask is did you re-ANALYZE the new
database?  pg_dump doesn't take care of that for you, and auto-analyze
might not think it needs to process the smaller tables.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Slow performance after restoring a dump
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Slow performance after restoring a dump