Horton

Re: [HACKERS] RE: Mysql comparison

Tom Samplonius <tom@sdf.com>

View thread
From: Tom <tom@sdf.com>
To: Vince Vielhaber <vev@michvhf.com>
Cc: Joel Shellman <joel@trafficx.com>, hackers@postgresql.org, webmaster@postgresql.org
Date: 1999-04-27T03:44:37Z
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@michvhf.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