REINDEX by table or by index?

Поиск
Список
Период
Сортировка
От Jeff Boes
Тема REINDEX by table or by index?
Дата
Msg-id 1055434890.27084.29.camel@takin.private.nexcerpt.com
обсуждение исходный текст
Ответы Re: REINDEX by table or by index?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
[Apologies if you have seen this before. I just discovered that posting
to the group via NNTP, at Teranews.com, apparently isn't working since
my posts aren't showing up in the mailing list archives.]

Given a fairly large (7 MRows or so) table with more than one index
(say, two): would it be theoretically faster to do

  REINDEX TABLE "foo";

or

  REINDEX INDEX "ix_foo_one";

and

  REINDEX INDEX "ix_foo_two";

in another session?  (The system in question has two CPUs, if that makes
any difference.)

--
Jeff Boes                                      vox 269.226.9550 ext 24
Database Engineer                                     fax 269.349.9076
Nexcerpt, Inc.                                 http://www.nexcerpt.com
           ...Nexcerpt... Extend your Expertise


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

Предыдущее
От: Jeff Boes
Дата:
Сообщение: Backends "idle in transaction"
Следующее
От: Henry House
Дата:
Сообщение: Re: Timestamp of insertion of the row.