| From: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
|---|---|
| To: | Hannu Krosing <hannu(at)tm(dot)ee> |
| Cc: | mkscott(at)sacadia(dot)com, "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Threaded PosgreSQL server |
| Date: | 2002-02-07 10:49:39 |
| Message-ID: | 20020207114939.H29170@zf.jcu.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Feb 07, 2002 at 12:03:56PM +0200, Hannu Krosing wrote:
> Btw, have you tried comparing pgbench runs on threaded model vs forked
> model. IIRC your code can run both ways.
It depend on OS. For example do fork and create thread is very
simular on Linux. May be ..can be some speed difference between locking
and access to shared memory?
IMHO in thread version is problem with backend crash (user's bugs in
PL .etc).
> > You can do this with processes (planned for 7.3 I think) but I
> > think it was much easier with threads. Other things may open up with
> > threads as well like Java stored procedures. Anyway, now I think it is
> > worth it.
Are all current PL interpereters thread safe?
Karel
--
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc G. Fournier | 2002-02-07 12:30:04 | Re: Threaded PosgreSQL server |
| Previous Message | Dean Lu | 2002-02-07 10:47:24 | Re: [Fwd: MS SQL compatible functions] |