Re: Anyone running PostgreSQL on Sun Solaris?

От:

"Rainer J. H. Brandt" <rjhb@bb-c.de>

Дата:

14 июля 2005 г. в 03:09:39

> A while ago we had a client running PostgreSQL on a Quad v440, and the
> performance was horrific. There are some known issues with PostgreSQL
> and solaris. AFAIK there was a kernel patch to alleviate some of the
> issues, but i'm unsure of the state of this as its been sometime since
> i've had any experience with PostgreSQL and solaris.

Can anyone remember specific information?

The only detail I remember about performance under Solaris is a discussion
about slow qsort:
http://archives.postgresql.org/pgsql-hackers/2002-04/msg00103.php

A quick search didn't turn up information about whether the build
process now replaces Sun's qsort, or whether Sun has improved qsort
since the problem was noticed by postgres users in 2002.

It'd be interesting to invest some time studying the sources at
opensolaris.org.

Rainer
----------------------------------------------------------------------
Rainer J. H. Brandt                            email:     rjhb@bb-c.de
Brandt & Brandt Computer GmbH                  web:        www.bb-c.de
Kamberg 111                                    phone:  +49 2448 919126
D 53940 Hellenthal                             mobile: +49 172 9593205

Anyone running PostgreSQL on Sun Solaris?

От:

Chris Hoover <revoohc@gmail.com>

Дата:

14 июля 2005 г. в 02:13:02

We are looking at the possibility of upgrading from our Dell Intel 
systems running Linux to Sun boxes running Solaris.  Are any of you 
running PostgreSQL in this type of environment.  Specifically, we are 
looking at Sun v880 with Solaris 10.  However, any Sun/Solaris  
references would be appreciated.

Thanks,

Chris

Re: Anyone running PostgreSQL on Sun Solaris?

От:

Marc McIntyre <mmcintyre@squiz.net>

Дата:

14 июля 2005 г. в 02:37:13

A while ago we had a client running PostgreSQL on a Quad v440, and the 
performance was horrific. There are some known issues with PostgreSQL 
and solaris. AFAIK there was a kernel patch to alleviate some of the 
issues, but i'm unsure of the state of this as its been sometime since 
i've had any experience with PostgreSQL and solaris.

Chris Hoover wrote:

> We are looking at the possibility of upgrading from our Dell Intel 
> systems running Linux to Sun boxes running Solaris.  Are any of you 
> running PostgreSQL in this type of environment.  Specifically, we are 
> looking at Sun v880 with Solaris 10.  However, any Sun/Solaris  
> references would be appreciated.
>
> Thanks,
>
> Chris
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>

-- 
Marc McIntyre
MySource Matrix Lead Developer

..>> Sydney ...>
92 Jarrett St          T: +61 (0) 2 9568 6866
Leichhardt,            F: +61 (0) 2 9568 6733
NSW, 2040              W: http://www.squiz.net/

..>> Canberra ...>
Walter Turnbull Bldg   T: +61 (0) 2 6233 0607
44 Sydney Ave,         F: +61 (0) 2 6233 0696
Forrest,               W: http://www.squiz.net/
ACT 2603

..>> London ...>
The Old Fire Station,  T: +44 (0) 20 7300 7321
140 Tabernacle St,     F: +44 (0) 870 112 3394
London EC2A 4SD        W: http://www.squiz.co.uk/

.....>> Open Source  - Own it  -  Squiz.net ...../>

IMPORTANT: This email (and any attachments) is commercial-in-confidence and or may be legally privileged and must not be forwarded, copied or shared without express permission from Squiz. If you are not the intended recipient, you may not legally copy, disclose or use the contents in any way and you should contact squiz@squiz.net immediately and destroy this message and any attachments. Thank you.

Re: Anyone running PostgreSQL on Sun Solaris?

От:

Marc McIntyre <mmcintyre@squiz.net>

Дата:

14 июля 2005 г. в 04:00:50


Rainer J. H. Brandt wrote:

>>A while ago we had a client running PostgreSQL on a Quad v440, and the
>>performance was horrific. There are some known issues with PostgreSQL
>>and solaris. AFAIK there was a kernel patch to alleviate some of the
>>issues, but i'm unsure of the state of this as its been sometime since
>>i've had any experience with PostgreSQL and solaris.
>>    
>>
>
>Can anyone remember specific information?
>  
>
It been too long to remember exact specifics, but it was something very 
similar to this problem.

    
http://sunportal.sunmanagers.org/pipermail/summaries/2003-March/003254.html

You might also want to have a look at this, although most of these 
issues are very old and have probably been resolved by now.

    
http://www.phil.uni-erlangen.de/tree/postgresql/majordomo/pgsql-novice-digest/v01.n098

>The only detail I remember about performance under Solaris is a discussion
>about slow qsort:
>http://archives.postgresql.org/pgsql-hackers/2002-04/msg00103.php
>
>A quick search didn't turn up information about whether the build
>process now replaces Sun's qsort, or whether Sun has improved qsort
>since the problem was noticed by postgres users in 2002.
>
>It'd be interesting to invest some time studying the sources at
>opensolaris.org.
>
>Rainer
>----------------------------------------------------------------------
>Rainer J. H. Brandt                            email:     rjhb@bb-c.de
>Brandt & Brandt Computer GmbH                  web:        www.bb-c.de
>Kamberg 111                                    phone:  +49 2448 919126
>D 53940 Hellenthal                             mobile: +49 172 9593205
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq
>
>  
>


-- 
Marc McIntyre
MySource Matrix Lead Developer