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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> David Osborne <david(at)qcode(dot)co(dot)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.
>
>