Re: PostgreSQL 7.1 on SMP: FreeBSD 4.3 || Linux 2.4.x?

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