| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | "For(at)ll" <forall(at)stalowka(dot)info> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Lost statistics after restore database |
| Date: | 2015-02-09 19:25:03 |
| Message-ID: | 20150209192503.GA7072@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | sridhar bamandlapally | 2015-02-10 03:53:35 | Re: [PERFORM] <empty string> Vs NULL |
| Previous Message | Luis Antonio Dias de Sá Junior | 2015-02-09 18:34:36 | Re: pg_createcluster failing on Trusty |