Обсуждение: Anyone running PostgreSQL on Sun Solaris?
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
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 beforwarded, copied or shared without express permission from Squiz. If you are not the intended recipient, you may not legallycopy, disclose or use the contents in any way and you should contact squiz@squiz.net immediately and destroy thismessage and any attachments. Thank you.
> 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
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