Re: PostgreSQL on Linux and Solaris comparison

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Chris <chris(dot)lo(at)cyberwisdom(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL on Linux and Solaris comparison
Date: 2002-11-07 16:51:08
Message-ID: 200211071651.gA7Gp8H21579@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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(at)postgresql(dot)org)
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-11-07 16:51:57 Re: licenses & price?
Previous Message Richard Huxton 2002-11-07 16:42:52 Re: table drops