Thread: 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/
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/
> 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
* 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."
> * 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
* 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."