On Mon, Jan 31, 2011 at 7:52 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Mon, Jan 31, 2011 at 5:54 PM, Aleksey Tsalolikhin
> <atsaloli.tech@gmail.com> wrote:
>> Situation: Disk usage on production server root filesystem is at 68%
>> utilization (80 GB used), on DR is at 51% (56 GB used). We use
>> SlonyII-1.2.x to keep the DR up to date. I would like to account for
>> the 24 GB difference.
>
> This is likely free space in your database. Some of it is completely
> normal and actually improves performance. Too much and your db is
> bloated and things starting taking too long.
Thanks, Scott!
Bucardo's "check_postgres.pl --action bloat" complains about one table,
1 GB wasted. So the other tables must be OK.
So what about my DR, which doesn't have this same 20+ GB of "free space".
Will it acquire it once it goes into production? Will performance be impacted
as it acquires the free space? Should I even be concerned about the
difference in disk usage or is it normal and expected?
How do I find out how much actual data I have in my database, minus the
"free space"? Is there some built-in way to report this, or do I need to run
"SELECT * FROM *" and look at the byte count of the output?
Thanks,
-at