Running large DB's on FreeBSD
Ask Bjørn Hansen
ask at develooper.com
Sun Nov 12 04:14:10 PST 2006
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
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.
More information about the freebsd-stable