Re: [GENERAL] Hardware optimising

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: Dimitri <dimitri(at)france(dot)sun(dot)com>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] Hardware optimising
Date: 1999-09-01 23:21:49
Message-ID: 199909012321.TAA25838@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Hi Bruce!
>
> I think you are not right with remark about threads...
> At least with Sun Solaris you will be much faster with multithreaded
> process vs multi processes.
> Why? Because Solaris is real multithreaded kernel, so it sees only
> threads in the kernel level.
> "Process" is a user view for running task, and 1 process = at least 1
> thread.
> Why multithreaded process wil be faster than multi processes? - Because
> switching between threads will cost much less than between processes, so
> you wil have more CPU time to continue your job.
> And, of course, all threads can use any CPU, so you win more with more
> CPU(s), but even with ONE CPU on your machine you will be faster with 10
> threads than with 10 processes...

Agreed. Sentenses removed. New text:

We handle each user connection by creating a Unix process. Backend
processes share data buffers and locking information. With multiple
CPU's, multiple backends can easily run on different CPU's.<BR><BR>

--
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

Browse pgsql-general by date

  From Date Subject
Next Message Michael Simms 1999-09-01 23:29:19 Re: [GENERAL] How to make a read-write atomic?
Previous Message Bruce Momjian 1999-09-01 23:05:11 Re: [GENERAL] 6.5.1 pg_dump adds "connect as" line