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 really big table, you don't wanna spend the time re-clustering it every time you import more data. -Andy -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
