<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;"><span style="font-weight: bold;">Aleksey,</span><br style="font-weight: bold;"><br style="font-weight: bold;"><span style="font-weight: bold;">To answer your questions:</span><br style="font-weight: bold;"><br style="font-weight: bold;">1. So does the database get bigger as it is transfered by Slony?<br><br><span style="font-weight: bold;">It doesn't get bigger, but PostgreSQL will write WAL files for all the inserts.</span><br style="font-weight: bold;"><span style="font-weight: bold;">I believe it is the WAL files (16MB each) that is starting to eat up you disk space.</span><br style="font-weight: bold;"><br>2. how large should the slave's disk be compared to the master's disk?<br><br><span style="font-weight: bold;">At least as big as the master. If you intend to use the slave as a failover, it is essential</span><br style="font-weight: bold;"><span
style="font-weight: bold;">that the hardware and O/S be as identical as possible.</span><br style="font-weight: bold;"><br style="font-weight: bold;">3. However my database size on the slave is 100 GB, and on the master is 58 GB.<br><br><span style="font-weight: bold;">How are you determining this? Are you using df -h?</span><br style="font-weight: bold;"><span style="font-weight: bold;">Or are you doing:</span><br style="font-weight: bold;"><br style="font-weight: bold;"><span style="font-weight: bold;">SELECT datname,</span><br style="font-weight: bold;"><span style="font-weight: bold;"> rolname as owner,</span><br style="font-weight: bold;"><span style="font-weight: bold;"> pg_size_pretty(pg_database_size(datname))as size_pretty,</span><br style="font-weight: bold;"><span style="font-weight: bold;"> pg_database_size(datname) as size,</span><br
style="font-weight: bold;"><span style="font-weight: bold;"> (SELECT pg_size_pretty (SUM( pg_database_size(datname))::bigint)</span><br style="font-weight: bold;"><span style="font-weight: bold;"> FROM pg_database) AS total,</span><br style="font-weight: bold;"><span style="font-weight: bold;"> ((pg_database_size(datname) / (SELECT SUM( pg_database_size(datname))</span><br style="font-weight: bold;"><span style="font-weight: bold;"> FROM pg_database) ) * 100)::numeric(6,3) AS pct</span><br style="font-weight: bold;"><span style="font-weight: bold;"> FROM pg_database d</span><br
style="font-weight: bold;"><span style="font-weight: bold;"> JOIN pg_authid a ON a.oid = datdba</span><br style="font-weight: bold;"><span style="font-weight: bold;">ORDER BY datname;</span><br style="font-weight: bold;"><br style="font-weight: bold;"><span style="font-weight: bold;">Also, make sure autovacuum is enabled on the slave?</span><br style="font-weight: bold;"><br><div id="RTEContent"><font size="4"><span style="font-weight: bold; font-family: arial; color: rgb(0, 0, 255);">Melvin Davidson </span></font><br> <font size="3"> </font><font size="3"><span style="font-weight: bold; font-family: courier;"></span><span style="font-weight: bold; font-family: courier;"><br>www.folkalley.com<br><br></span></font></div><br></td></tr></table><br>
<hr size=1>8:00? 8:25? 8:40? <a href="
http://tools.search.yahoo.com/shortcuts/?fr=oni_on_mail&#news"> Find a flick</a> in no time<br> with the<a href="
http://tools.search.yahoo.com/shortcuts/?fr=oni_on_mail&#news">Yahoo! Search movie showtime shortcut.</a>