Re: [Sqlgrey-users] Using PostgreSQL vs MySQL

[Marc G. F. <sc...@hu...>]

On Tue, 30 May 2006, Andrew Diederich wrote:

> On 5/30/06, Dave Strickler <dst...@ma...> wrote:
>> 
>> Has anyone had experience in a large email volume shop, going from one DB 
>> format to the other? I find the connect table needs to be vacuumed daily 
>> under PostgreSQL. Are there such maintenance "problems" under MySQL ?
>
>
> What version of postgres are you using?  I believe 8.0 and 8.1 are
> much better about auto-vacuuming, or not needing it in the first
> place, than the 7.x versions.

8.1 has a built-in autovacuum daemon, but its disabled by default ... the 
8.x series are better are reusing space, but the space still needs to be 
freed up by a vacuum at some point ... what 8.x have reduced (but not 
eliminated) the need for is VACUUM FULL ...


----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email . sc...@hu...                              MSN . sc...@hu...
Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664