<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; "><BR><DIV><DIV>On Sep 4, 2007, at 1:34 PM, <A href="mailto:f-myth-users@media.mit.edu">f-myth-users@media.mit.edu</A> wrote:</DIV><BLOCKQUOTE type="cite"><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><SPAN class="Apple-style-span"><FONT class="Apple-style-span" color="#000000">...</FONT>e.g., the rather unfortunate reactions when</SPAN></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">someone a few months ago was trying to allow migration to Postgres,</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">which -doesn't- seem to require the daily table-fixing cargo cult</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">ritual to stay operational and performant, and doesn't seem to get</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">the same sorts of snickers from database people that MySQL does.]</DIV></BLOCKQUOTE><DIV><BR class="khtml-block-placeholder"></DIV><DIV>I dunno. Different isn't necessarily better. I run the repair/optimize script weekly and at each reboot, on my box, and it works fine. I've never seen it find a problem, even after an unclean shutdown, but I run it just to play it safe. IMHO often the repair/optimize script is a solution looking for a problem. It's like when tech support people tell you to unplug a problematic device and plug it back in. Most of the time it doesn't help, but it does just often enough that it's the first thing people try.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>It's been a long time since I ran a Postgres database, but I recall having to run a 'vacuum' script on it on a regular basis to keep it running properly. So, probably six of one, half a dozen of the other. I can run VACUUM, or I can run OPTIMIZE TABLE. I don't really care which it is.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>One thing I've noticed about relational database people is they all develop a religious fervor for their own favorite database, and consider using any other to be the most horrible form of heresy. I take all claims that one database engine is superior to another with a big grain of salt. ;)</DIV><DIV><BR class="khtml-block-placeholder"></DIV></DIV></BODY></HTML>