Re: pg_dump and database size question

On Thursday 06 January 2011 5:58:13 am Birta Levente wrote:
> Hi,
>
>
> I have postgres 9.0.2 server with a 2.4GB database.
> After pg_dump of the database, the size increased with aprox 200MB ... why?
> I make some tests and the total_relation_size is increased, but the
> relation_size not.
>
> thanks
>
> Birta Levente

Are you saying the existing database increases in size after the dump or that
when you dump/restore the restored db is greater in size than what it was
previously? Also if it was a dump/restore where you changing Postgres
versions? In any case total_relation_size includes more information than
relation_size; notably TOAST space, indexes, and two more of the data
forks(main,fsm,vm). So the difference is in one of those. See here for more
info:
http://www.postgresql.org/docs/9.0/interactive/functions-admin.html

As to why, that probably depends on the answer to my previous questions.

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com