From: Tiago Hermans <thermans@hawaii.rr.com>
To: Bruce Momjian <maillist@candle.pha.pa.us>
Cc: pgsql-general@postgresql.org
Subject: RE: [GENERAL] Multi-threading on PostgreSQL?
Date: Thu, 15 Jul 1999 09:29:16 -1000
Message-ID: <001a01becef8$538b4540$07581f18@tiago-s-dell.hawaii.rr.com> (raw)
In-Reply-To: <199907151334.JAA07774@candle.pha.pa.us>
> > 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-docs@postgresql.org
Cc: thermans@hawaii.rr.com, maillist@candle.pha.pa.us, pgsql-general@postgresql.org
Subject: Re: [GENERAL] Multi-threading on PostgreSQL?
In-Reply-To: <001a01becef8$538b4540$07581f18@tiago-s-dell.hawaii.rr.com>
References: <199907151334.JAA07774@candle.pha.pa.us> <001a01becef8$538b4540$07581f18@tiago-s-dell.hawaii.rr.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox