Re: PostgreSQL vs. MySQL - Mailing list pgsql-performance

From Rod Taylor
Subject Re: PostgreSQL vs. MySQL
Date
Msg-id 1057331162.40425.79.camel@jester
Whole thread Raw
In response to Re: PostgreSQL vs. MySQL  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Responses Re: PostgreSQL vs. MySQL  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
List pgsql-performance
> 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.

Attachment

pgsql-performance by date:

Previous
From: Rafal Kedziorski
Date:
Subject: Re: PostgreSQL vs. MySQL
Next
From: Shridhar Daithankar
Date:
Subject: Re: PostgreSQL vs. MySQL