Mark Rae wrote: > On Tue, Mar 15, 2005 at 06:46:50PM -0500, Bruce Momjian wrote: > > Mark Rae wrote: > > > Also, while on the subject of scaling. I had the opportunity > > > to try postgres on a 16CPU Altix and couldn't get it to scale > > > more than about 4x, whereas Oracle got up to about 12x faster > > > > > We have had some major SMP improvements in current CVS. Were you > > testing that or 8.0.X? > > It tried it with 8.0.0rc3, and had previously tried a 7.4 version
Oh, you have to try CVS HEAD or a nightly snapshot. Tom made a major change that allows scaling in SMP environments. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
