| 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: | Whole Thread | Raw Message | 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
| 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 |