On Mon, Jan 31, 2011 at 5:54 PM, Aleksey Tsalolikhin <atsaloli.t...@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. You can reclaim that space by doing a cluster or vacuum full on the subject table. Setting fill factor ahead of time to something in the 90% range should cut down on bloat as future updates can then happen in place, and also will improve performance of the system as updates happen in the same page and if they're not indexed don't require index updates as well (Heap Only Tuple updates, or HOT updates use this method) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
