Re: [Sqlgrey-users] Using PostgreSQL vs MySQL

[Dave S. <dst...@ma...>]

Good to know the stats - thanks. We run about 2.5 million records in our =
connect table here. Sounds like MySQL is working well for you, and that's =
a good tip. It may be better at handing large amount of 'change' data than =
Postgres.
=20
Postgres has a maintenance routine called a 'Vacuum' that needs to be run =
on all DBs as its not good at maintaining itself. These can be automated, =
but only in the latest versions.
=20
Two followup questions:
1. What table format do you use? MyISAM or InnoDB ?
2. Do you run any sort of maintenance on the SQLGrey tables?
=20
Thanks,
=20
Dave Strickler
MailWise LLC
617-933-5810 (direct)
www.mailwise.com ( http://www.mailwise.com/ )
"Intelligent E-mail Protection"





>>> Dan Faerch <da...@ha...> 12:41 PM Tuesday, May 30, 2006 >>>
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=20
during daytime on each server, and i dont have to do any maintenance at=20
all..
The connect table on a random server at this very moment contains=20
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=20
since its just unused, pre-alloceted diskspace for the table. (the=20
table-files dont auto-shrink on "delete" operations)
The space will be mostly re-used tomorrow at time-prime as new records=20
are added faster, so basically MySQL seems to find a good size for you=20
table-file and works within that, saving the server for at lot of=20
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 =
?
> =20
> =20
> =20
> 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.ma=
ilwise.com ( http://www.mailwise.com/ )=20
>  =20



-------------------------------------------------------
All the advantages of Linux Managed Hosting--Without the Cost and Risk!
Fully trained technicians. The highest number of Red Hat certifications in
the hosting industry. Fanatical Support. Click to learn more
http://sel.as ( http://sel.as/ )-us.falkag.net/sel?cmd=3Dlnk&kid=3D107521&b=
id=3D248729&dat=3D121642
_______________________________________________
Sqlgrey-users mailing list
Sql...@li...=20
https://lists.sourceforge.net/lists/listinfo/sqlgrey-users

----------------------------
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