Re: [Sqlgrey-users] Using PostgreSQL vs MySQL

[Dan F. <da...@ha...>]

I dont know what "vacuumed" is, since i've never used Postgres.

But i do run MySQL, and on my setup we have around 20 INSERT's a second 
during daytime on each server, and i dont have to do any maintenance at 
all..
The connect table on a random server at this very moment contains 
131.081 records. It has 42mb of data and an "overhead" of 31mb.
One could run "Optimize" to remove the overhead, but it doesnt matter 
since its just unused, pre-alloceted diskspace for the table. (the 
table-files dont auto-shrink on "delete" operations)
The space will be mostly re-used tomorrow at time-prime as new records 
are added faster, so basically MySQL seems to find a good size for you 
table-file and works within that, saving the server for at lot of 
resizing operations.

- Dan Faerch



Dave Strickler 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 ?
>  
>  
>  
> Dave Strickler
> MailWise LLC
> 617-933-5810 (direct)
> www.mailwise.com ( http://www.mailwise.com/ )
> "Intelligent E-mail Protection"
>
>
>
>
> ----------------------------
> This message has been certified virus-free by MailWise Filter - The real-time, intelligent, e-mail firewall used to scan inbound and outbound messages for SPAM, Viruses and Content.  For more info visit: http://www.mailwise.com 
>