Re: huge price database question.. - Mailing list pgsql-general

From Andy Colson
Subject Re: huge price database question..
Date
Msg-id 4F69478D.5080609@squeakycode.net
Whole thread Raw
In response to Re: huge price database question..  (Brent Wood <Brent.Wood@niwa.co.nz>)
List pgsql-general
On 03/20/2012 08:54 PM, Brent Wood wrote:
>
> Also look at a clustered index on timestamp
>
>
> Brent Wood
>
> GIS/DBA consultant
> NIWA
> +64 (4) 4 386-0300

A clustered index is only "clustered" at the point in time you run the command.  It wont remain that way, and with a
reallybig table, you don't wanna spend the time re-clustering it every time you import more data. 

-Andy

pgsql-general by date:

Previous
From: Sam Loy
Date:
Subject: Re: Is it even possible?
Next
From: David Kerr
Date:
Subject: Re: huge price database question..