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.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
