On Wed, Mar 7, 2012 at 2:37 PM, Steve Singer <[email protected]> wrote: > On 12-03-07 03:59 PM, Aleksey Tsalolikhin wrote: >> >> Hello, > > > > If the problem is that your table is bloated > > The CLUSTER command > http://www.postgresql.org/docs/8.4/static/sql-cluster.html will compact your > table. The VACUUM command does not normally return unused space to the > operating system (some exceptions apply)
Thank you, Steve. I used "check_postgres" to check for bloat and it reported wasted size only 1 GB. table XYZ rows:8674174 pages:463848 shouldbe:318436 (1.5X) wasted size:1191215104 (1 GB) This does not seem much compared to table size on the master, 154 GB,and on the slave, 527 GB. I can't run CLUSTER because I don't have another 500 GB free... I am running VACUUM FULL right now to return the unused disk space to the OS. I wondering if it will free 1 GB or 300 GB. I expect 1 GB, based on the check_postgres "bloat" check results. I'll run check_postgres "bloat" check again after the VACUUM FULL finishes. This table does use TOAST and most of the data is in TOAST... I wonder if the 1 GB size includes TOAST. Best, Aleksey _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
