From: Bruce Momjian <maillist@candle.pha.pa.us>
Message-Id: <199909231736.NAA20278@candle.pha.pa.us>
Subject: Re: [GENERAL] Multi-threading on PostgreSQL?
In-Reply-To: <001a01becef8$538b4540$07581f18@tiago-s-dell.hawaii.rr.com> from
	Tiago Hermans at "Jul 15, 1999 09:29:16 am"
To: Tiago Hermans <thermans@hawaii.rr.com>
Date: Thu, 23 Sep 1999 13:36:42 -0400 (EDT)
CC: webmaster@postgresql.org, PostgreSQL-documentation <docs@postgresql.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

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