Re: Database Bloat

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: elliott <elliott(at)cpi(dot)com>
Cc: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Database Bloat
Date: 2012-08-22 18:16:12
Message-ID: CAHyXU0ywHAZ4LnBNZrq--fFPm60_yEwZBH61WRLkhT6Q9aEtvQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Aug 22, 2012 at 12:25 PM, elliott <elliott(at)cpi(dot)com> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Hannon 2012-08-22 20:10:01 Re: Amazon High I/O instances
Previous Message Sébastien Lorion 2012-08-22 17:30:03 Re: Amazon High I/O instances