Thread: PostgreSQL + SMP

PostgreSQL + SMP

From
paitoon butri
Date:
Dear, All
    I want to know that Postgres support SMP or Dual
Processor, or not. If it support, how to configure?

Thank all


__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/

RE: PostgreSQL + SMP

From
Matthew
Date:
Postgre is not threaded, but every connection gets it's own process.  The OS
will distribute the processes across the processors.  Not sure I said that
very will.

Basically a single connection will not be any faster with SMP, but multiple
connections will be.

> -----Original Message-----
> From:    paitoon butri [SMTP:pbt_10400@yahoo.com]
> Sent:    Thursday, November 30, 2000 6:34 AM
> To:    pgsql-admin@postgresql.org
> Subject:    [ADMIN] PostgreSQL + SMP
>
> Dear, All
>     I want to know that Postgres support SMP or Dual
> Processor, or not. If it support, how to configure?
>
> Thank all
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Shopping - Thousands of Stores. Millions of Products.
> http://shopping.yahoo.com/

Re: PostgreSQL + SMP

From
Bruce Momjian
Date:
> Postgre is not threaded, but every connection gets it's own process.  The OS
> will distribute the processes across the processors.  Not sure I said that
> very will.
>
> Basically a single connection will not be any faster with SMP, but multiple
> connections will be.

Actually, even a single process will be faster because all other system
process will run on other cpu's.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@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

Re: PostgreSQL + SMP

From
Alfred Perlstein
Date:
* Bruce Momjian <pgman@candle.pha.pa.us> [001210 12:19] wrote:
> > Postgre is not threaded, but every connection gets it's own process.  The OS
> > will distribute the processes across the processors.  Not sure I said that
> > very will.
> >
> > Basically a single connection will not be any faster with SMP, but multiple
> > connections will be.
>
> Actually, even a single process will be faster because all other system
> process will run on other cpu's.

Depending on how idle you are, the large overhead of bus locking
can cause a lot of perf degredation(sp?) for the idle SMP case.

--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."

Re: PostgreSQL + SMP

From
Bruce Momjian
Date:
> * Bruce Momjian <pgman@candle.pha.pa.us> [001210 12:19] wrote:
> > > Postgre is not threaded, but every connection gets it's own process.  The OS
> > > will distribute the processes across the processors.  Not sure I said that
> > > very will.
> > >
> > > Basically a single connection will not be any faster with SMP, but multiple
> > > connections will be.
> >
> > Actually, even a single process will be faster because all other system
> > process will run on other cpu's.
>
> Depending on how idle you are, the large overhead of bus locking
> can cause a lot of perf degredation(sp?) for the idle SMP case.

True.  I was thinking more of the backend having to give up the cpu to
allow other processes to run.  With two cpu's, I believe one backend can
camp out on a cpu forever as long as the other cpu doesn't get busy.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@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

Re: PostgreSQL + SMP

From
Alfred Perlstein
Date:
* Bruce Momjian <pgman@candle.pha.pa.us> [001210 12:28] wrote:
> > * Bruce Momjian <pgman@candle.pha.pa.us> [001210 12:19] wrote:
> > > > Postgre is not threaded, but every connection gets it's own process.  The OS
> > > > will distribute the processes across the processors.  Not sure I said that
> > > > very will.
> > > >
> > > > Basically a single connection will not be any faster with SMP, but multiple
> > > > connections will be.
> > >
> > > Actually, even a single process will be faster because all other system
> > > process will run on other cpu's.
> >
> > Depending on how idle you are, the large overhead of bus locking
> > can cause a lot of perf degredation(sp?) for the idle SMP case.
>
> True.  I was thinking more of the backend having to give up the cpu to
> allow other processes to run.  With two cpu's, I believe one backend can
> camp out on a cpu forever as long as the other cpu doesn't get busy.

That's true, as long as there's no contention for the locks then it's
pretty cheap.

--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."