Postgres Pro
Downloads
Home   >   mailing lists

Database Bloat - Mailing list pgsql-general

From elliott
Subject Database Bloat
Date
Msg-id 503279AB.80900@cpi.com
Whole thread Raw
Responses Re: Database Bloat  (John R Pierce <pierce@hogranch.com>)
Re: Database Bloat  ("David Johnston" <polobo@yahoo.com>)
Re: Database Bloat  (Jerry Sievers <gsievers19@comcast.net>)
Re: Database Bloat  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: postmaster.pid file auto-clean up?
Next
From: Jeff Janes
Date:
Subject: Re: Ignore hash indices on replicas