Re: Slow performance after restoring a dump - Mailing list pgsql-performance

From Tom Lane
Subject Re: Slow performance after restoring a dump
Date
Msg-id 31890.1521473700@sss.pgh.pa.us
Whole thread Raw
In response to Slow performance after restoring a dump  (David Osborne <david@qcode.co.uk>)
Responses Re: Slow performance after restoring a dump  (David Osborne <david@qcode.co.uk>)
List pgsql-performance
David Osborne <david@qcode.co.uk> writes:
> Hi, I was wondering if someone could help us work out why this query is so
> slow.
> We've just dumped a database (Postgresql 9.1) and restored it to a new
> instance (AWS RDS 9.6) (via pg_dump, restored to psql)

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.

            regards, tom lane


pgsql-performance by date:

Previous
From: David Osborne
Date:
Subject: Slow performance after restoring a dump
Next
From: David Osborne
Date:
Subject: Re: Slow performance after restoring a dump