Running large DB's on FreeBSD

[Ask Bjørn Hansen]

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/