Re: Database Bloat

elliott <elliott(at)cpi(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres(dot)consulting(at)comcast(dot)net
p: 732.216.7255