"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.
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Federico Di Gregorio||Date: 2004-10-14 11:06:39|
|Subject: Re: BUG #1286: indices not used after a pg_restore|
|Previous:||From: PostgreSQL Bugs List||Date: 2004-10-14 09:26:00|
|Subject: BUG #1286: indices not used after a pg_restore|