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