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
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 |