Re: [HACKERS] RE: Mysql comparison - Mailing list pgsql-hackers

From Tom
Subject Re: [HACKERS] RE: Mysql comparison
Date
Msg-id Pine.BSF.4.05.9904262040470.16605-100000@misery.sdf.com
Whole thread Raw
In response to RE: Mysql comparison  (Vince Vielhaber <vev@michvhf.com>)
List 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



pgsql-hackers by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: Lock freeze ? in MVCC
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Lock freeze ? in MVCC