Date: Mon, 9 Feb 2015 14:25:03 -0500
From: Bruce Momjian <bruce@momjian.us>
To: "For@ll" <forall@stalowka.info>
Cc: pgsql-admin@postgresql.org
Subject: Re: Lost statistics after restore database
Message-ID: <20150209192503.GA7072@momjian.us>
References: <masg3r$fqu$1@ger.gmane.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <masg3r$fqu$1@ger.gmane.org>
User-Agent: Mutt/1.5.20 (2009-06-14)
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

On Wed, Feb  4, 2015 at 08:01:15AM +0100, For@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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin