Re: Database Bloat

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