Re: [HACKERS] RE: Mysql comparison

From: Tom <tom(at)sdf(dot)com>
To: Vince Vielhaber <vev(at)michvhf(dot)com>
Cc: Joel Shellman <joel(at)trafficx(dot)com>, hackers(at)postgresql(dot)org, webmaster(at)postgresql(dot)org
Subject: Re: [HACKERS] RE: Mysql comparison
Date: 1999-04-27 03:44:37
Message-ID: Pine.BSF.4.05.9904262040470.16605-100000@misery.sdf.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On Mon, 26 Apr 1999, Vince Vielhaber wrote:

...
> > Also, it says that postgresql is not multithreaded--what exactly does
> > that mean? Does that mean it can only handle one query at a time? That
> > seems very strange.

There is more than one way of doing more than one thing at a time.
Multithreading is one way, and multiprocessing is another.

BTW, even though MySQL is multithreaded, any thread that modifies a
table (update, delete, insert) will block all other threads on that table
until it completes.

Therefore, multithreading or multiprocessing has little to do with any
parallelism a rdms may utilize. You have to look deeper.

> --
> ==========================================================================
> Vince Vielhaber -- KA8CSH email: vev(at)michvhf(dot)com flame-mail: /dev/null
> # include <std/disclaimers.h> TEAM-OS2
> Online Campground Directory http://www.camping-usa.com
> Online Giftshop Superstore http://www.cloudninegifts.com
> ==========================================================================

Tom

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Inoue 1999-04-27 03:49:13 Lock freeze ? in MVCC
Previous Message Todd Graham Lewis 1999-04-27 03:25:11 Re: [HACKERS] MVCC Question