On Tue, 16 Jun 2009, Brent Wood wrote:
For data retrieval, clustered indexes may help, but as this requires a physical reordering of the data on disk, it may be impractical.
This tends to be irrelevant for this sort of data because it's normally inserted in a fairly clustered way in the first place. The usual way tables get unclustered involves random insertion and deletion, and that just doesn't happen for data that's being imported daily and never deleted afterwards; it's naturally clustered quite well.
-- * Greg Smith gsmith@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
