REINDEX by table or by index?

From: Jeff Boes <jboes(at)nexcerpt(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: REINDEX by table or by index?
Date: 2003-06-12 16:21:30
Message-ID: 1055434890.27084.29.camel@takin.private.nexcerpt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-06-12 16:42:36 Re: Still confused about VACUUM vs. VACUUM FULL
Previous Message Jeff Boes 2003-06-12 16:20:01 Backends "idle in transaction"