First, try 7.3beta. That has a fix for Solaris sorting. That may fix
it.
---------------------------------------------------------------------------
Chris wrote:
> Hi,
>
> I am using PostgresSQL 7.1.3 on both Linux and Solaris envrionment.
> Development is using the Linux and production is using Solaris. I
> experienced that the perfomrance on Solaris is much worse than Linux.
> For example, the same query executed 9 seconds on Solaris and only 1
> seconds on Linux.
>
> Is there any help upgrading the 7.1.3 to 7.2.3? Or how can I do some
> performance tunning on Solaris?
>
> Thanks.
> Chris
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
--
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