From: Bruce Momjian <maillist@candle.pha.pa.us>
To: Tiago Hermans <thermans@hawaii.rr.com>
Cc: webmaster@postgresql.org, PostgreSQL-documentation <docs@postgresql.org>
Subject: Re: [GENERAL] Multi-threading on PostgreSQL?
Date: Thu, 23 Sep 1999 13:36:42 -0400 (EDT)
Message-ID: <199909231736.NAA20278@candle.pha.pa.us> (raw)
In-Reply-To: <001a01becef8$538b4540$07581f18@tiago-s-dell.hawaii.rr.com>
Vince, can you please make this change for me?
[Charset iso-8859-1 unsupported, filtering to ASCII...]
> > > 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
>
>
--
Bruce Momjian | http://www.op.net/~candle
maillist@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
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 using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: maillist@candle.pha.pa.us, thermans@hawaii.rr.com, docs@postgresql.org
Subject: Re: [GENERAL] Multi-threading on PostgreSQL?
In-Reply-To: <199909231736.NAA20278@candle.pha.pa.us>
* 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