| 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: | Whole Thread | Raw Message | 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 |