On Oct 24, 2006, at 7:27 AM, Vivek Khera wrote:
I believe the front-end application is MySQL dependent, but what
is so much better about PostgreSQL? I understand that it has some
more advanced features, but if they are not used, then what is the
advantage? (I really like the InnooDB storage in MySQL)
So after billions and billions of inserts/updates/deletes, how do
you reclaim all that lost space in innodb? dump + reload is what I
hear.
If you've configured it properly you can just do "optimize table foo".
also, do you value your data? ie, if you insert data which cannot
be stored should the DB silently alter it or should it throw back
an error for your application to decide what to do? guess which DB
does which...
Not MySQL if you configure/ask it not to.
- ask
--
http://www.askbjoernhansen.com/
_______________________________________________
freebsd-stable@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-stable
To unsubscribe, send any mail to "[EMAIL PROTECTED]"
