On Thu, 2004-10-14 at 06:54 -0400, Tom Lane wrote: > "PostgreSQL Bugs List" <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] INIT.D Developer [EMAIL PROTECTED] Debian. The best software from the best people [see above] -- brought to you by One Line Spam
signature.asc
Description: This is a digitally signed message part
