Re: ready for some testing

On Thu, 27 Nov 2003 11:16:28 -0700
Vincent Danen <[email protected]> wrote:

> Out of curiousity, did you every play with Anthill using mysql?  I'm 
> curious on your thoughts as to wether you think the postgres backend is 
> faster.  It seems faster to me, but I can't bench it properly yet 
> because my Linux laptop (AMD 2400+XP with 512MB RAM) is running 
> postgres whereas my OS X laptop (1GHz with 1GB RAM) is using MySQL.. 
> but the postgres one seems faster to me.

I'm sorry I havn't, I just tried the demo before PostgreSQL support was
added. I've always been impressed with PostgreSQL performance and feature
set. Where I work I have databases that have several gigs of data and
tables with many millions of rows and once I optimized the queries and
added indexes it works fast and great! Basicly I choose PostgreSQL for its
feature set and stability (foreign keys, etc), if the speed was good that
was a added bonus. I enjoy doing benchmarks from time to time
(http://users.altec.org/~russ/benchmarks.html), if you really want to know
maybe I could help. Nothing against MySQL many people use it and it works
good for them. PostgreSQL has just really impressed me and has proven to
me to be really good and stable. Recently where I work we moved all our
projects from Oracle to PostgreSQL, with the good documentation and
community support that PostgreSQL offers I would say we have better
performance and stability with PostgreSQL. Of course part of that reason
could be we didn't have a Oracle specialized DBA on staff.

It's pretty tough to do benchmarks, as slight configurations in the
database could make a large difference. I wouldn't be the best at
optimizing MySQL so there would be a bias right there.


Russell Valentine

_______________________________________________
Anthill-workers mailing list
Anthill-workers-+mQDA36h6dWw5LPnMra/[email protected]
http://vmlinuz.ca/mailman/listinfo/anthill-workers

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQE/xkd6O0EDJO5MgRYRApljAJ9V51Bk5/1fDapG9DCoFjsD/gLZBgCcC3Rc
uom0UMYmtgVZvjZVyEQRd/c=
=Xl+/
-----END PGP SIGNATURE-----