| From: | Jason Davis <jdavis(at)tassie(dot)net(dot)au> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | CLUSTER trashing indexes |
| Date: | 2000-10-22 08:07:10 |
| Message-ID: | 200010220758.SAA09128@zeus.tassie.net.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hi all
I have a rather large table, around 7 million rows. I created 3 indexes on
this table, which resulted in rather large indexes. As there will be no
more rows added to this table, I thought optimizing the indexes with the
CLUSTER command might be a good idea to speed up lookups. After the first
index had finished being processed by the cluster command, my remaining
indexes diappeared. The actual index files in the ~/data/base/dbname
directory had completely disappeared. Therefore I have to go and re-create
the indexes. Have I missed something in the release notes or known bugs
list, or is there a size limitation or problem when dealing with indexes
and/or clustering them? The average physical index file size being around
200MB each.
My version btw is 7.0.2 running on FreeBSD 3.4.
cheers,
Jason Davis
DB Admin/Programmer
Tas Access
www.tassie.net.au
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-10-22 16:04:47 | Re: CLUSTER trashing indexes |
| Previous Message | Frank Hilliard | 2000-10-21 22:24:43 | Using KDE to start Postgres |