Re: BUG #1286: indices not used after a pg_restore

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Federico Di Gregorio <fog(at)initd(dot)org>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1286: indices not used after a pg_restore
Date: 2004-10-15 03:48:37
Message-ID: 4572.1097812117@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Federico Di Gregorio <fog(at)initd(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2004-10-15 04:22:33 Re: SELECT FOR UPDATE and LIMIT 1 behave oddly
Previous Message Alvaro Herrera 2004-10-15 02:43:39 Re: 'configure' bug on Mac OS X 10.3.5