Postgres Pro
Downloads
Home   >   mailing lists

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 27959.1097751295@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>)
Responses Re: BUG #1286: indices not used after a pg_restore  (Federico Di Gregorio <fog@initd.org>)
List pgsql-bugs
Tree view 
"PostgreSQL Bugs List" <pgsql-bugs@postgresql.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

pgsql-bugs by date:

Previous
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1286: indices not used after a pg_restore
Next
From: "Fahad G."
Date:
Subject: 'configure' bug on Mac OS X 10.3.5