public inbox for [email protected]  

help / color / mirror / Atom feed

From: Shridhar Daithankar <[email protected]>
To: Postgresql Performance <[email protected]>
Subject: Re: PostgreSQL vs. MySQL
Date: Fri, 4 Jul 2003 20:48:39 +0530
Message-ID: <[email protected]> (raw)
In-Reply-To: <1057331162.40425.79.camel@jester>
References: <[email protected]>
	<3F05E144.10448.6784AB@localhost>
	<1057331162.40425.79.camel@jester>

On Friday 04 July 2003 20:36, Rod Taylor wrote:
> > 2. Postgresql uses shared memory being process based architecture. Mysql
> > uses process memory being threaded application. It does not need  kernel
> > settings to work and usually works best it can.
>
> MySQL has other issues with the kernel due to their threading choice
> such as memory limits per process, or poor threaded SMP support on some
> platforms (inability for a single process to use more than one CPU at a
> time regardless of thread count).
>
> Threads aren't an easy way around kernel limitations, which is probably
> why Apache has gone for a combination of the two -- but of course that
> adds complexity.

Correct. It's not debate about whether threading is better or not. But it 
certainly affects the default way with which these two applications work.

 Shridhar

view thread (66+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: PostgreSQL vs. MySQL
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox