If I use
SELECT pg_size_pretty(pg_database_size('dbname')) As fulldbsize;
If I compare this output with
I have a difference of 3 GB, which I think is not normal.
To make a little bit clearer what i mean:
/var/lib/postgresql/9.0/main/base/43169# du --apparent-size -h
/var/lib/postgresql/9.0/main/base/43169# du -sh
Is such a big fragmentation a normal behavior? It's splitted to several
I also made a "xfs_fsr" to defrag all of this, i gathered around 1 GB
back ( would be more if the tables wouldn't be written in this time )
But within some hours the fragmentation was back..
There is also no big dead tuple count in this database, it's getting a
vacuum analyze every night.
Right now i am out of ideas... What do you think i could do?
If you need more information i can provide.
- OS: Debian Lenny
- Disksize: 15GB
- Filesystem: XFS
- Psql: 9.0.3
thanks in advance.
pgsql-admin by date
|Next:||From: Kevin Grittner||Date: 2012-02-14 14:34:13|
|Subject: Re: Real time monitoring of pg_dump progress through
|Previous:||From: Anup Greens||Date: 2012-02-14 13:18:42|
|Subject: Real time monitoring of pg_dump progress through web apps|