On Fri, 11 Dec 2009 14:56:57 -0500, Daniel Ouellet <dan...@presscom.net> wrote:
> Then using PostgreSQL should really work well for you then and you > wouldn't really need or benefit much from multicore kernel with the > giant lock removed as PostgreSQL is not and do not use threads anyway by > design oppose to MySQL that does. So, that choice of database eliminate > your biggest concern form the start. Although PostgreSQL uses multiple processes instead of multiple threads, and that means that (on OpenBSD) PG can scale CPU utilization to all available processors where MySQL can't... if I understand the situation correctly, PG would still benefit from a kernel locking approach that didn't restrict kernel activity to a single CPU core. However, I would be surprised if that starts being a serious problem before OpenBSD's limit of ~4GB on i386 and amd64 started being a problem. And you actually need a fairly big database before that's a problem, so... -- Matthew Weigel hacker unique & idempot . ent