Running large DB's on FreeBSD

Ask Bjørn Hansen ask at
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  
> 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


More information about the freebsd-stable mailing list