Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] Multi-threading on PostgreSQL?

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: Tiago Hermans <thermans(at)hawaii(dot)rr(dot)com>
Cc: webmaster(at)postgresql(dot)org, PostgreSQL-documentation <docs(at)postgresql(dot)org>
Subject: Re: [GENERAL] Multi-threading on PostgreSQL?
Date: 1999-09-23 17:36:42
Message-ID: 199909231736.NAA20278@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-docspgsql-general
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(at)candle(dot)pha(dot)pa(dot)us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

pgsql-docs by date

Next:From: Alec SmecherDate: 1999-09-24 03:01:51
Subject: Count UPDATEs in libpq++?
Previous:From: Bruce MomjianDate: 1999-09-22 16:45:49
Subject: Re: [DOCS] INSTALL file (was Re: [HACKERS] Re: HISTORY for 6.5.2)

pgsql-general by date

Next:From: Sebestyen ZoltanDate: 1999-09-23 17:46:08
Subject: That migration problem
Previous:From: Bruce MomjianDate: 1999-09-23 17:25:07
Subject: Re: [GENERAL] Is it possible run pgsql in Windows 95 ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group