We belive that PostgreSQL 7.2 will have much better SMP performance.
It should be released in 2-3 months.
> I have a dual-CPU (PIII 600MHz), 512MB, IDE-HD box. A couple
> of months ago I was using Linux 2.4.3 on this box and was getting
> good performance on a custom network-server/db application I am
> running. Basically, I am getting constant network traffic to
> the machine, storing transmitted information in memory until
> some threshold size, and then forking off a process to transfer
> the shared memory to PostgreSQL database. I saw better performance
> doing this than dumping to the database right away as the data
> was coming in. The application takes advantage of optimized
> SQL statements, vacuum analyze, indexes, persistent db connections,
> bound values, delayed transaction commits, etc..
--
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