pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Anyone running PostgreSQL on Sun Solaris?
4+ messages / 3 participants
[nested] [flat]

* Anyone running PostgreSQL on Sun Solaris?
@ 2005-07-08 19:55 Chris Hoover <revoohc@gmail.com>
  2005-07-14 05:35 ` Re: Anyone running PostgreSQL on Sun Solaris? Marc McIntyre <mmcintyre@squiz.net>
  0 siblings, 1 reply; 4+ messages in thread

From: Chris Hoover @ 2005-07-08 19:55 UTC (permalink / raw)
  To: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Anyone running PostgreSQL on Sun Solaris?
  2005-07-08 19:55 Anyone running PostgreSQL on Sun Solaris? Chris Hoover <revoohc@gmail.com>
@ 2005-07-14 05:35 ` Marc McIntyre <mmcintyre@squiz.net>
  2005-07-14 06:09   ` Re: Anyone running PostgreSQL on Sun Solaris? Rainer J. H. Brandt <rjhb@bb-c.de>
  0 siblings, 1 reply; 4+ messages in thread

From: Marc McIntyre @ 2005-07-14 05:35 UTC (permalink / raw)
  To: Chris Hoover <revoohc@gmail.com>; +Cc: pgsql-admin

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.







^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Anyone running PostgreSQL on Sun Solaris?
  2005-07-08 19:55 Anyone running PostgreSQL on Sun Solaris? Chris Hoover <revoohc@gmail.com>
  2005-07-14 05:35 ` Re: Anyone running PostgreSQL on Sun Solaris? Marc McIntyre <mmcintyre@squiz.net>
@ 2005-07-14 06:09   ` Rainer J. H. Brandt <rjhb@bb-c.de>
  2005-07-14 06:59     ` Re: Anyone running PostgreSQL on Sun Solaris? Marc McIntyre <mmcintyre@squiz.net>
  0 siblings, 1 reply; 4+ messages in thread

From: Rainer J. H. Brandt @ 2005-07-14 06:09 UTC (permalink / raw)
  To: pgsql-admin

> 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






^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Anyone running PostgreSQL on Sun Solaris?
  2005-07-08 19:55 Anyone running PostgreSQL on Sun Solaris? Chris Hoover <revoohc@gmail.com>
  2005-07-14 05:35 ` Re: Anyone running PostgreSQL on Sun Solaris? Marc McIntyre <mmcintyre@squiz.net>
  2005-07-14 06:09   ` Re: Anyone running PostgreSQL on Sun Solaris? Rainer J. H. Brandt <rjhb@bb-c.de>
@ 2005-07-14 06:59     ` Marc McIntyre <mmcintyre@squiz.net>
  0 siblings, 0 replies; 4+ messages in thread

From: Marc McIntyre @ 2005-07-14 06:59 UTC (permalink / raw)
  To: rjhb@bb-c.de; +Cc: pgsql-admin


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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2005-07-14 06:59 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-07-08 19:55 Anyone running PostgreSQL on Sun Solaris? Chris Hoover <revoohc@gmail.com>
2005-07-14 05:35 ` Marc McIntyre <mmcintyre@squiz.net>
2005-07-14 06:09   ` Rainer J. H. Brandt <rjhb@bb-c.de>
2005-07-14 06:59     ` Marc McIntyre <mmcintyre@squiz.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox