| From: | Rod Taylor <rbt(at)rbt(dot)ca> |
|---|---|
| To: | shridhar_daithankar(at)persistent(dot)co(dot)in |
| Cc: | Postgresql Performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL vs. MySQL |
| Date: | 2003-07-04 15:06:03 |
| Message-ID: | 1057331162.40425.79.camel@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs pgsql-general pgsql-hackers 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shridhar Daithankar | 2003-07-04 15:18:39 | Re: PostgreSQL vs. MySQL |
| Previous Message | Rafal Kedziorski | 2003-07-04 14:55:04 | Re: PostgreSQL vs. MySQL |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-07-04 15:11:25 | Re: any body using Solaris8 with postgresql 7.3.3 |
| Previous Message | Rafal Kedziorski | 2003-07-04 14:55:04 | Re: PostgreSQL vs. MySQL |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shridhar Daithankar | 2003-07-04 15:18:39 | Re: PostgreSQL vs. MySQL |
| Previous Message | Teodor Sigaev | 2003-07-04 15:02:15 | Re: How to submit Tsearch V2 ? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shridhar Daithankar | 2003-07-04 15:18:39 | Re: PostgreSQL vs. MySQL |
| Previous Message | Rafal Kedziorski | 2003-07-04 14:55:04 | Re: PostgreSQL vs. MySQL |