On Mon, Jul 21, 2008 at 1:25 PM, Andreas Hartmann <andreas@xxxxxxxxxx> wrote: > SELECT pg_database.datname, > pg_size_pretty(pg_database_size(pg_database.datname)) AS size > FROM pg_database where pg_database.datname = 'vvz_live_1'; > > datname | size > ---------------+--------- > vvz_live_1 | 2565 MB > > I wonder why the actual size is so much bigger than the data-only dump - is > this because of index data etc.? More probably because the database is totally bloated. Do you run VACUUM regularly or did you set up autovacuum? -- Guillaume
