elliott <elliott@cpi.com> writes:
> 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?
Well, check if the table has a low fill-factor setting.
\d+ footable
Hasn't come up yet in the remarks by others on this thread but worth verifying.
> Thanks
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 732.216.7255