From: | Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in> |
---|---|
To: | Postgresql Performance <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: PostgreSQL vs. MySQL |
Date: | 2003-07-04 15:18:39 |
Message-ID: | 200307042048.39521.shridhar_daithankar@nospam.persistent.co.in |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs pgsql-general pgsql-hackers pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2003-07-04 15:26:20 | Re: PostgreSQL vs. MySQL |
Previous Message | Rod Taylor | 2003-07-04 15:06:03 | Re: PostgreSQL vs. MySQL |
From | Date | Subject | |
---|---|---|---|
Next Message | Shridhar Daithankar | 2003-07-04 15:19:49 | Re: Datatypes and performance |
Previous Message | Tom Lane | 2003-07-04 15:11:25 | Re: any body using Solaris8 with postgresql 7.3.3 |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2003-07-04 15:26:20 | Re: PostgreSQL vs. MySQL |
Previous Message | Rod Taylor | 2003-07-04 15:06:03 | Re: PostgreSQL vs. MySQL |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2003-07-04 15:26:20 | Re: PostgreSQL vs. MySQL |
Previous Message | Rod Taylor | 2003-07-04 15:06:03 | Re: PostgreSQL vs. MySQL |