What is the practical limitation of no multi-threading?

From: Brian Beuning <bbeuning(at)mindspring(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: What is the practical limitation of no multi-threading?
Date: 2001-12-08 02:05:18
Message-ID: 3C11755D.600AFF56@mindspring.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

OK I admit it, I am a postgresql newbie. The developers FAQ says the
postgresql "backend" is not multi-threaded. How serious is this?

If this means only one transaction at a time can make progress or the
entire DBMS server is blocked on every disk I/O then that is very bad.

But if every connection gets its own backend, and the backends can run
in parallel then not being multithreaded is no big deal.

Here is the bottom line. Our app runs on multiple machines (we call
them sinks)
hitting one DBMS server for data. We expect the sinks to be able to all
make
progress at the same time. Each sink fetchs some data, goes compute
bound
for .2 to .4 seconds, and then sends a bunch of INSERT/UPDATE/DELETE
to the DBMS. Will our sinks be able to run concurrently?

Thanks,
Brian Beuning

Responses

Browse pgsql-general by date

  From Date Subject
Next Message steve boyle 2001-12-08 02:09:03 Re: Upcoming Presentations in Japan
Previous Message Boban Acimovic 2001-12-07 23:22:01 How to get database schema without pg_dump?