| From: | Dariusz Pietrzak <dariush(at)ajax(dot)umcs(dot)lublin(dot)pl> |
|---|---|
| To: | "Thalis A(dot) Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: CLUSTER. (fwd) |
| Date: | 2001-06-15 16:21:36 |
| Message-ID: | Pine.LNX.4.10.10106151818050.32452-100000@ajax.umcs.lublin.pl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> Clustering is really static i.e. it's done and after it any inserts/updates start spoiling the table again.
> So I guess the answer is no. Maybe you can create a procedure that does
> CLUSTER and then recreates the indeces and whatever else you lose in the
> process.
What a pity,
I used to do some benchmarks and little studies using explain
and cluster had huge effect on efficency with data I used.
I thought it works like table partitions in oracle only within one data
location, pity.
Thanx.
--
Dariusz Pietrzak
Certified Nobody
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2001-06-15 17:53:33 | Re: [JDBC] The bytea datatype and JDBC |
| Previous Message | Martín Marqués | 2001-06-15 16:09:16 | Re: Re: Log files, how to rotate properly |