| From: | Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | "For(at)ll" <forall(at)stalowka(dot)info>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Lost statistics after restore database |
| Date: | 2015-02-10 06:26:31 |
| Message-ID: | CAGDYbUOhZP=Ba2W73XZufKSREZqAxmY_VjOtq1p8rUoECjKbxQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Tue, Feb 10, 2015 at 12:55 AM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> On Wed, Feb 4, 2015 at 08:01:15AM +0100, For(at)ll wrote:
> > Hi,
> >
> > I have weird problem with database postgresql 9.3.5. I tried to use
> > pg_upgrade to migrate dabase from postgresql 9.2 to 9.3 it ended in
> > 2 minutes - orginal database has 45GB and after pg_upgrade has
> > 200MB.
> > So I used pg_dump (9.3.5) with binary format (Fc) and then restore
> > with pg_restore 9.3.5. Database did restore but thereis problem with
> > statistics. I have the same database on the other server and when I
> > look for statistics I have 75 rows and on my broken db I should have
> > the same, but I have only 20 rows and there are queries that lasts
> > and lasts.
> > If I give explain analyze for them it last for 45 minutes and more...
>
> Neither upgrade method preserves optimizer statistics, try ANALYZE.
>
> --
> Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + Everyone has their own god. +
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://stream.boxwatch.ru/mailpref/pgsql-admin
>
Hi,
I think you should try analyze on your 9.3.5.
There is a script get created after performing the pg_upgrade
So I suggest you to run the analyze script and check the statistics in
catalog tables.
Regards
Ajinkya Bangale
Database administrator
www.shreeyansh.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Devrim Gündüz | 2015-02-10 06:42:18 | Re: How to upgrade psql client |
| Previous Message | Harshad Adalkonda | 2015-02-10 05:38:58 | Re: How to upgrade psql client |