Re: BUG #1286: indices not used after a pg_restore - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1286: indices not used after a pg_restore
Date
Msg-id 4572.1097812117@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1286: indices not used after a pg_restore  ("PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>)
List pgsql-bugs
Federico Di Gregorio <fog@initd.org> writes:
> On Thu, 2004-10-14 at 06:54 -0400, Tom Lane wrote:
>> I do not believe that you remembered to ANALYZE after restore.

> unfortunately for your belief, i remembered. :)

> also, this problem can be replicated at will. i can send a dump that
> exposes the problem if necessary but i'll need some time to purge
> customers data and create a dump a can freely send.

I'd like to see it, please.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: 'configure' bug on Mac OS X 10.3.5
Next
From: Tom Lane
Date:
Subject: Re: SELECT FOR UPDATE and LIMIT 1 behave oddly