Database Bloat

From: elliott <elliott(at)cpi(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Database Bloat
Date: 2012-08-20 17:53:47
Message-ID: 503279AB.80900@cpi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Janes 2012-08-20 17:55:08 Re: Ignore hash indices on replicas
Previous Message Tom Lane 2012-08-20 17:31:06 Re: postmaster.pid file auto-clean up?