On Wed, 2010-09-01 at 16:59 -0400, Tom Lane wrote: > It would help if Devrim could break down the bloat to the level of > individual tables/indexes. While setting up this data (by anonymizing table names, etc), I saw that almost all relations are smaller on backup server, as compared to prod. Yeah, there is a little bloat on master, but at the end of the day, total size is expected to be smaller on backup. See 5 top disk space eaters (in bytes): Prod: idx1|1441636352 bytes tbl3|3248930816 bytes tbl4|9065570304 bytes tbl5|10850549760 bytes Backup: idx1|1215463424 bytes tbl3|3189325824 bytes tbl4|8910422016 bytes tbl5|10814955520 bytes Almost all relations are smaller on backup. Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Attachment:
signature.asc
Description: This is a digitally signed message part
