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

Поиск
Список
Период
Сортировка
От Federico Di Gregorio
Тема Re: BUG #1286: indices not used after a pg_restore
Дата
Msg-id 1097751999.3427.12.camel@lana.initd.org
обсуждение исходный текст
Ответ на Re: BUG #1286: indices not used after a pg_restore  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
On Thu, 2004-10-14 at 06:54 -0400, Tom Lane wrote:
> "PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
> > After a pg_dump/pg_restore (using the tar format) queries that were usi=
ng=20
> > the indices don't use them anymore until the indices are dropped and=20
> > recreated. After that the indices are used the correct way.=20
>=20
> 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.

--=20
Federico Di Gregorio                         http://people.initd.org/fog
Debian GNU/Linux Developer                                fog@debian.org
INIT.D Developer                                           fog@initd.org
  Debian. The best software from the best people [see above]
                                      -- brought to you by One Line Spam

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Ivan Esteban Rivera Uria"
Дата:
Сообщение: finger print (minutias)
Следующее
От: Justin Clift
Дата:
Сообщение: [Fwd: Re: misc/72498: Libc timestamp code on jailed SMP machine generates incorrect results]