From: | "Tiago Hermans" <thermans(at)hawaii(dot)rr(dot)com> |
---|---|
To: | "Bruce Momjian" <maillist(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | RE: [GENERAL] Multi-threading on PostgreSQL? |
Date: | 1999-07-15 19:29:16 |
Message-ID: | 001a01becef8$538b4540$07581f18@tiago-s-dell.hawaii.rr.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs pgsql-general |
> > My concern comes from the fact that there's no multi-threading
> support in
> > PostgreSQL and since we expect many customers to be connected
> at the same
> > time on multiple connections, I am afraid the time to perform the SQL
> > statements will be much longer, since they'll all be queued one
> after the
> > other. Therefore, if one query takes a long time, all the other
> queries have
> > to wait behind before being executed.
> >
> > Am I missing something or are my assumptions correct?
> > Also, does PostgreSQL supports international characters?
>
> We certainly process multiple queries at the same time. We are not
> multi-threaded in the sense we don't run multiple queries inside the
> same process. Each connection gets its own process.
>
> I am interested to hear why you thought we only do one query at a time.
> Is there some information we published or someone else published that
> lead you to that conclusion.
In the URL: http://www.postgresql.org/doxlist.html
the "Multi-threaded" and "Parallel Query" bullets are not active. I guess
these words should be explained with a hyperlink to avoid confusion. You
have such a great product, if I didn't register on the mailing list and
posted this message, I would have been totally wrong in my assumptions, and
looking at the history of the list, I am not the only one.
Anyway, we are downloading PostgreSQL today and will port our SQL code to
try it out.
Thank you for your reply and clarification on this.
Tiago
From | Date | Subject | |
---|---|---|---|
Next Message | Simeó | 1999-07-15 20:21:34 | Foreign Keys in PostgreSQL |
Previous Message | Dieter Lange | 1999-07-15 17:38:02 | Template1 database in docs |
From | Date | Subject | |
---|---|---|---|
Next Message | Simeó | 1999-07-15 20:21:34 | Foreign Keys in PostgreSQL |
Previous Message | Ing. Arturo de la Torre | 1999-07-15 16:17:19 | (no subject) |