Re: Database Bloat

On 08/20/12 10:53 AM, elliott wrote:
> Hi,
>
> I am using PostgreSQL 9.1 and loading very large tables ( 13 million
> rows each ).  The flat file size is only 25M.  However, the equivalent
> database table is 548MB.  This is without any indexes applied and auto
> vacuum  turned on.  I have read that the bloat can be around 5 times
> greater for tables than flat files so over 20 times seems quite
> excessive.
>
> Any ideas on how to go about decreasing this bloat or is this not
> unexpected for such large tables?


what do the fields of this table look like (output from \d tablename
would be useful)


--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast