pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedMulti-threading on PostgreSQL?
5+ messages / 3 participants
[nested] [flat]
* Multi-threading on PostgreSQL?
@ 1999-07-15 06:13 Tiago Hermans <thermans@hawaii.rr.com>
1999-07-15 06:31 ` Re: [GENERAL] Multi-threading on PostgreSQL? Chris Bitmead <chris@tech.com.au>
1999-07-15 13:34 ` Re: [GENERAL] Multi-threading on PostgreSQL? Bruce Momjian <maillist@candle.pha.pa.us>
0 siblings, 2 replies; 5+ messages in thread
From: Tiago Hermans @ 1999-07-15 06:13 UTC (permalink / raw)
To: pgsql-general@postgresql.org
Hi,
I am really impressed with the features of PostgreSQL but am wondering if we
should use this product for our project. We have tried several databases
(MySQL, Sybase ASE, Sybase ASA) and we are now looking at PostgreSQL before
releasing our service on the Internet.
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?
Thank you for any info this.
Tiago Hermans
thermans@hawaii.rr.com
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [GENERAL] Multi-threading on PostgreSQL?
1999-07-15 06:13 Multi-threading on PostgreSQL? Tiago Hermans <thermans@hawaii.rr.com>
@ 1999-07-15 06:31 ` Chris Bitmead <chris@tech.com.au>
1 sibling, 0 replies; 5+ messages in thread
From: Chris Bitmead @ 1999-07-15 06:31 UTC (permalink / raw)
To: pgsql-general@postgreSQL.org
I think you are missing something. Threads and processes, to a great
extent are 6 of one and half a dozen of the other. Postgres uses
multiple processes accessing a shared memory area. A multithreaded
database would use multiple threads accessing a shared memory area. In
most OSes, threads and processes are treated very much the same way.
Threads and processes don't necessarily have to "wait". Both threads and
processes use locks. A good multi-process implementation will beat a bad
threaded one every time.
A threaded implementation can be more efficient, specifically when
you've got hundreds of simultaneous connections, but we're not talking
about some giant leap here.
That's not to say Sybase isn't faster than PostgreSQL (or slower for
that matter. I wouldn't know). But I'd advise against putting any stock
into whether it's threaded or not. As always, do your own testing.
Tiago Hermans wrote:
>
> Hi,
>
> I am really impressed with the features of PostgreSQL but am wondering if we
> should use this product for our project. We have tried several databases
> (MySQL, Sybase ASE, Sybase ASA) and we are now looking at PostgreSQL before
> releasing our service on the Internet.
>
> 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?
>
> Thank you for any info this.
>
> Tiago Hermans
> thermans@hawaii.rr.com
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [GENERAL] Multi-threading on PostgreSQL?
1999-07-15 06:13 Multi-threading on PostgreSQL? Tiago Hermans <thermans@hawaii.rr.com>
@ 1999-07-15 13:34 ` Bruce Momjian <maillist@candle.pha.pa.us>
1999-07-15 19:29 ` RE: [GENERAL] Multi-threading on PostgreSQL? Tiago Hermans <thermans@hawaii.rr.com>
1 sibling, 1 reply; 5+ messages in thread
From: Bruce Momjian @ 1999-07-15 13:34 UTC (permalink / raw)
To: Tiago Hermans <thermans@hawaii.rr.com>; +Cc: pgsql-general@postgreSQL.org
[Charset iso-8859-1 unsupported, filtering to ASCII...]
> Hi,
>
> I am really impressed with the features of PostgreSQL but am wondering if we
> should use this product for our project. We have tried several databases
> (MySQL, Sybase ASE, Sybase ASA) and we are now looking at PostgreSQL before
> releasing our service on the Internet.
>
> 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.
--
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: [GENERAL] Multi-threading on PostgreSQL?
1999-07-15 06:13 Multi-threading on PostgreSQL? Tiago Hermans <thermans@hawaii.rr.com>
1999-07-15 13:34 ` Re: [GENERAL] Multi-threading on PostgreSQL? Bruce Momjian <maillist@candle.pha.pa.us>
@ 1999-07-15 19:29 ` Tiago Hermans <thermans@hawaii.rr.com>
1999-09-23 17:36 ` Re: [GENERAL] Multi-threading on PostgreSQL? Bruce Momjian <maillist@candle.pha.pa.us>
0 siblings, 1 reply; 5+ messages in thread
From: Tiago Hermans @ 1999-07-15 19:29 UTC (permalink / raw)
To: Bruce Momjian <maillist@candle.pha.pa.us>; +Cc: pgsql-general@postgresql.org
> > 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [GENERAL] Multi-threading on PostgreSQL?
1999-07-15 06:13 Multi-threading on PostgreSQL? Tiago Hermans <thermans@hawaii.rr.com>
1999-07-15 13:34 ` Re: [GENERAL] Multi-threading on PostgreSQL? Bruce Momjian <maillist@candle.pha.pa.us>
1999-07-15 19:29 ` RE: [GENERAL] Multi-threading on PostgreSQL? Tiago Hermans <thermans@hawaii.rr.com>
@ 1999-09-23 17:36 ` Bruce Momjian <maillist@candle.pha.pa.us>
0 siblings, 0 replies; 5+ messages in thread
From: Bruce Momjian @ 1999-09-23 17:36 UTC (permalink / raw)
To: Tiago Hermans <thermans@hawaii.rr.com>; +Cc: webmaster@postgresql.org, PostgreSQL-documentation <docs@postgresql.org>
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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~1999-09-23 17:36 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-07-15 06:13 Multi-threading on PostgreSQL? Tiago Hermans <thermans@hawaii.rr.com>
1999-07-15 06:31 ` Chris Bitmead <chris@tech.com.au>
1999-07-15 13:34 ` Bruce Momjian <maillist@candle.pha.pa.us>
1999-07-15 19:29 ` Tiago Hermans <thermans@hawaii.rr.com>
1999-09-23 17:36 ` Bruce Momjian <maillist@candle.pha.pa.us>
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