elliott <elliott@xxxxxxx> 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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consulting@xxxxxxxxxxx p: 732.216.7255 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
