Re: Slow performance after restoring a dump

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxx> wrote:
David Osborne <david@xxxxxxxxxxx> 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.


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux