I've been playing with PG on a new FreeBSD 5.0 SMP box and I can't say
the performance is dramatic, but I haven't done serious benchmarking
yet. I will post the results if there is a gigantic leap..
On Thursday, February 6, 2003, at 02:21 PM, Vivek Khera wrote:
>>>>>> "RAD" == Ruslan A Dautkhanov <rusland@scn.ru> writes:
>
> RAD> Old releases (4.7, for example) also supports SMP, but worse
> RAD> comparative with version 5 as described in above mentioned
> RAD> release notes. Please say, if anybody test SMP in FreeBSD for
> RAD> PostgreSQL - really Postgres with v5.0 will "dramatically"
> RAD> increase SQL server performance?
>
> I run Postgres 7.2 on FreeBSD 4.7 with dual procs. Works fine. I
> will wait until about FreeBSD 5.2 before I upgrade this server.
>
>
> --
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> Vivek Khera, Ph.D. Khera Communications, Inc.
> Internet: khera@kciLink.com Rockville, MD +1-240-453-8497
> AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to
> majordomo@postgresql.org)
>
-Mitch