On Thu, 2004-10-14 at 06:54 -0400, Tom Lane wrote:
> "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org> writes:
> > After a pg_dump/pg_restore (using the tar format) queries that were using
> > the indices don't use them anymore until the indices are dropped and
> > recreated. After that the indices are used the correct way.
> 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.
Federico Di Gregorio http://people.initd.org/fog
Debian GNU/Linux Developer fog(at)debian(dot)org
INIT.D Developer fog(at)initd(dot)org
Debian. The best software from the best people [see above]
-- brought to you by One Line Spam
In response to
pgsql-bugs by date
|Next:||From: Josh Berkus||Date: 2004-10-14 16:45:20|
|Subject: Re: SELECT FOR UPDATE and LIMIT 1 behave oddly|
|Previous:||From: Tom Lane||Date: 2004-10-14 10:54:55|
|Subject: Re: BUG #1286: indices not used after a pg_restore |