On Mon, Jan 31, 2011 at 7:52 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: > On Mon, Jan 31, 2011 at 5:54 PM, Aleksey Tsalolikhin > <atsaloli.tech@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
