Re: CLUSTER. (fwd) - Mailing list pgsql-general

From Dariusz Pietrzak
Subject Re: CLUSTER. (fwd)
Date
Msg-id Pine.LNX.4.10.10106151818050.32452-100000@ajax.umcs.lublin.pl
Whole thread Raw
In response to Re: CLUSTER. (fwd)  ("Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu>)
List 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


pgsql-general by date:

Previous
From: "Thalis A. Kalfigopoulos"
Date:
Subject: Ellison pops a price surprise at Oracle 9i launch
Next
From: "Dave Cramer"
Date:
Subject: Re: [JDBC] The bytea datatype and JDBC