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
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" |