On Wed, Aug 22, 2012 at 12:25 PM, elliott <elliott@xxxxxxx> wrote: > Yes, it is a tif file. Uncompressed it is around 85M. ok, 85 -> 548mb is reasonable considering you have very narrow rows and an index that covers 2/3 of your column data. if you want to see dramatic reduction in table size, you probably need to explore use of arrays in some fashion. merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general