| 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: | Whole Thread | Raw Message | 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" |