Thread: Upgrading to Solaris 9

Upgrading to Solaris 9

From
Danielle Cossette
Date:
Good morning,

Could you please let me know if Postgres 7.1.3 will run on Solaris 9.
If it does, are you aware of any issues.

Thank you for your help.

Danielle Cossette


Re: Upgrading to Solaris 9

From
Peter Eisentraut
Date:
Danielle Cossette writes:

> Could you please let me know if Postgres 7.1.3 will run on Solaris 9.

Why don't you try it out?

--
Peter Eisentraut   peter_e@gmx.net


Re: Upgrading to Solaris 9

From
Greg Spiegelberg
Date:
I did and had too many problems and performance issues.  Solaris-
PostgreSQL just doesn't gel as wel as Linux-PostgreSQL.  (ouch)

If PostgreSQL were to get retooled to work with threads the way it
works between processes today for Solaris or if someone were to find
a tweak to make the Solaris scheduler more process-centric than
thread-centric (maybe via dispadmin(1)?) then I'm sure Solaris-PG would
clobber Linux-PG.

I still spin up 7.3.3 on our Sun V480 4CPU, 8GB, 2 internal fibre
drives occasionally and our 7.3.3 on RedHat 7.3 with 2.4.20, 2 1.4GHz,
2GB memory and 2 internal U160 kills it.  I've tried the many options
for UFS and VxFS and EXT3 on Linux still beats it.  The database I use
on the Sun comes from a pg_dump on the Linux system.

But, IMHO Solaris 8 or 9 in comparison to Linux on like hardware,
databases, configurations and queries the latter will outperform the
former every time.  -= IMHO =-

The short answer to your question is yes, it will run on Solaris 9.

Greg


Peter Eisentraut wrote:
> Danielle Cossette writes:
>
>
>>Could you please let me know if Postgres 7.1.3 will run on Solaris 9.
>
>
> Why don't you try it out?
>


--
Greg Spiegelberg
  Sr. Product Development Engineer
  Cranel, Incorporated.
  Phone: 614.318.4314
  Fax:   614.431.8388
  Email: gspiegelberg@Cranel.com
Cranel. Technology. Integrity. Focus.



Re: Upgrading to Solaris 9

From
Gaetano Mendola
Date:
Danielle Cossette wrote:

> Good morning,
>
> Could you please let me know if Postgres 7.1.3 will run on Solaris 9.
> If it does, are you aware of any issues.

Seems that solaris is the worst choice for run Postgres.

Am I completely wrong ?


Regards
Gaetano Mendola


Re: Upgrading to Solaris 9

From
Ray Ontko
Date:
Sounds like an opportunity for someone at Sun to fund a
little research project.  Any Sun/Postgresql hackers out
there?  Any Sun project managers lurking out there?

Ray

On Tue, Nov 11, 2003 at 01:37:03PM -0500, Greg Spiegelberg wrote:
> I did and had too many problems and performance issues.  Solaris-
> PostgreSQL just doesn't gel as wel as Linux-PostgreSQL.  (ouch)
>
> If PostgreSQL were to get retooled to work with threads the way it
> works between processes today for Solaris or if someone were to find
> a tweak to make the Solaris scheduler more process-centric than
> thread-centric (maybe via dispadmin(1)?) then I'm sure Solaris-PG would
> clobber Linux-PG.
>
> I still spin up 7.3.3 on our Sun V480 4CPU, 8GB, 2 internal fibre
> drives occasionally and our 7.3.3 on RedHat 7.3 with 2.4.20, 2 1.4GHz,
> 2GB memory and 2 internal U160 kills it.  I've tried the many options
> for UFS and VxFS and EXT3 on Linux still beats it.  The database I use
> on the Sun comes from a pg_dump on the Linux system.
>
> But, IMHO Solaris 8 or 9 in comparison to Linux on like hardware,
> databases, configurations and queries the latter will outperform the
> former every time.  -= IMHO =-
>
> The short answer to your question is yes, it will run on Solaris 9.
>
> Greg
>
>
> Peter Eisentraut wrote:
> >Danielle Cossette writes:
> >
> >
> >>Could you please let me know if Postgres 7.1.3 will run on Solaris 9.
> >
> >
> >Why don't you try it out?
> >
>
>
> --
> Greg Spiegelberg
>  Sr. Product Development Engineer
>  Cranel, Incorporated.
>  Phone: 614.318.4314
>  Fax:   614.431.8388
>  Email: gspiegelberg@Cranel.com
> Cranel. Technology. Integrity. Focus.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
----------------------------------------------------------------------
Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/

cancel <3FB12A96.9090401@bigfoot.com>

From
mendola@bigfoot.com
Date:
This message was cancelled from within Mozilla.


Re: Upgrading to Solaris 9

From
Jeff
Date:
On Tue, 11 Nov 2003 13:37:03 -0500
Greg Spiegelberg <gspiegelberg@cranel.com> wrote:

> I did and had too many problems and performance issues.  Solaris-
> PostgreSQL just doesn't gel as wel as Linux-PostgreSQL.  (ouch)
>

7.4 "fixes" a lot of hte performance problems we've seen with PG.
I had a very strong reason to make PG work well on solaris and after
some digging we found that by default, PG was being compiled with no
optimization on solaris.   That resulted in an AMAZING speed increase -
making it comprible to linux.

You can get the same effect on 7.3.x by setting CFLAGS=-O2 before
running configure.

However, establishing connections will not get much of an increase due
to solaris' amazingly slow fork().

The thread issue has been beaten to death on -HACKERS.

You can also check the -performance lists for the threads I posted about
this... oh a couple months ago?

--
Jeff Trout <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/

Re: Upgrading to Solaris 9

From
"scott.marlowe"
Date:
On Tue, 11 Nov 2003, Gaetano Mendola wrote:

> Danielle Cossette wrote:
>
> > Good morning,
> >
> > Could you please let me know if Postgres 7.1.3 will run on Solaris 9.
> > If it does, are you aware of any issues.
>
> Seems that solaris is the worst choice for run Postgres.
>
> Am I completely wrong ?

I thought .org and .info were being run on postgresql/solaris?

As another poster pointed out, the Solaris version was building with no
optimzation, and it was kinda figured to be in the sysadmin's realm to fix
that at build time.

You're likely using Solaris' qsort, which was slow in the olden days but I
thought it had been sped up recently.  If it's been fixed, no worries, as
I'm pretty sure Solaris 9 has a qsort that sorts fast with many identical
keys.

Either way, upgrading to 7.3.4 or 7.4RC2 (for testing, in a couple weeks
release...) should provide a very noticable speed increase over 7.1 due
to many improvements made since that version.

The upgrade to 7.4 might be easier than the upgrade to 7.3 followed by
7.4, as 7.4's pg_dump and pd_dumpall are version aware and can dump a live
7.1.3 database.  So, if you wanna try it, just build a test server and:

pgsql7.4rc2: pg_dumpall -h production_machine_running_7.1.3 |psql -h testbox_running_7.4.rc2

and see what happens.


Re: Upgrading to Solaris 9

From
Andrew Sullivan
Date:
On Tue, Nov 11, 2003 at 07:29:42PM +0100, Gaetano Mendola wrote:
>
> Seems that solaris is the worst choice for run Postgres.
>
> Am I completely wrong ?

Windows is worse ;-)

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Afilias Canada                        Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


Re: Upgrading to Solaris 9

From
Andrew Sullivan
Date:
On Tue, Nov 11, 2003 at 01:52:26PM -0700, scott.marlowe wrote:
>
> I thought .org and .info were being run on postgresql/solaris?

They are.  I'd happily dump the Solaris use overboard, however, if it
weren't for all the nifty hardware support it give us.  It is
dog-slow for handling large numbers of processes.  We get around that
by throwing hardware at the problem.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Afilias Canada                        Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


Re: Upgrading to Solaris 9

From
William Yu
Date:
Danielle Cossette wrote:
> Good morning,
>
> Could you please let me know if Postgres 7.1.3 will run on Solaris 9.
> If it does, are you aware of any issues.

I've run 7.1, 7.2 and 7.3 on Solaris 8 x86 and Solaris 9 x86. 7.1
install, config, run was nearly 100% hands-off. 7.3 takes setting
LD_LIBRARY_PATH to point to /usr/local/lib.

They've run fine for 3+ years ... except I had always allocated a
trivial amount of shared memory to Postgres. A few months back, I
decided to increase the shmmin/shmmax parameters to something a bit more
usable and the OS promptly kernel panic'd upon bootup. It took a few
tries to get values that worked. But this week, Solaris just went nuts
and kept kernel panicing until I dropped shared memory to next to
nothing -- which set Postgres performance back to be unusable.

I blew the OS away, installed Linux and everything runs fine. Actually
better than fine; better performance due to better drivers (especially
for ATA hard drives), better disk cache management, lower memory
footprint, etc. I had already switched to Linux on one server due to a
non-working LSI 32320-R driver and this shared memory problem has pretty
much cemented our plans to move off Solaris.


Re: Upgrading to Solaris 9

From
Christopher Browne
Date:
In the last exciting episode, andrew@libertyrms.info (Andrew Sullivan) wrote:
> On Tue, Nov 11, 2003 at 01:52:26PM -0700, scott.marlowe wrote:
>>
>> I thought .org and .info were being run on postgresql/solaris?
>
> They are.  I'd happily dump the Solaris use overboard, however, if it
> weren't for all the nifty hardware support it give us.  It is
> dog-slow for handling large numbers of processes.  We get around that
> by throwing hardware at the problem.

One might choose to use Solaris for a number of reasons _other_ than
it being the fastest platform for PostgreSQL:

- If some applications are written in Java, Sun might be chosen as
  the hardware vendor because "Java works there best."

- If you're buying hardware in bulk, it may be a better deal to have
  to throw extra money at the DB server if you saved money on the
  other boxes.

- Local familiarity might be worth something; better the devil you
  know than ones you don't.

- Reprovisioned hardware from another project is cheaper than starting
  afresh.

I wouldn't warrant that any of those are necessarily applicable in
this particular case, but "which platform runs PG fastest" could
readily get pushed lower on the list by these sorts of factors...
--
let name="cbbrowne" and tld="ntlug.org" in String.concat "@" [name;tld];;
http://www.ntlug.org/~cbbrowne/postgresql.html
"How much more helpful could I be than to provide you with the
appropriate e-mail address? I could engrave it on a clue-by-four and
deliver it to you in Chicago, I suppose." -- Seen on Slashdot...

Re: Upgrading to Solaris 9

From
Naomi Walker
Date:
At 11:49 AM 11/11/2003, Ray Ontko wrote:
>Sounds like an opportunity for someone at Sun to fund a
>little research project.  Any Sun/Postgresql hackers out
>there?  Any Sun project managers lurking out there?

Does Solaris 8 have the same problem?  We run postgres on Solaris 6 with no
problems at all.


>Ray
>
>On Tue, Nov 11, 2003 at 01:37:03PM -0500, Greg Spiegelberg wrote:
> > I did and had too many problems and performance issues.  Solaris-
> > PostgreSQL just doesn't gel as wel as Linux-PostgreSQL.  (ouch)
> >
> > If PostgreSQL were to get retooled to work with threads the way it
> > works between processes today for Solaris or if someone were to find
> > a tweak to make the Solaris scheduler more process-centric than
> > thread-centric (maybe via dispadmin(1)?) then I'm sure Solaris-PG would
> > clobber Linux-PG.
> >
> > I still spin up 7.3.3 on our Sun V480 4CPU, 8GB, 2 internal fibre
> > drives occasionally and our 7.3.3 on RedHat 7.3 with 2.4.20, 2 1.4GHz,
> > 2GB memory and 2 internal U160 kills it.  I've tried the many options
> > for UFS and VxFS and EXT3 on Linux still beats it.  The database I use
> > on the Sun comes from a pg_dump on the Linux system.
> >
> > But, IMHO Solaris 8 or 9 in comparison to Linux on like hardware,
> > databases, configurations and queries the latter will outperform the
> > former every time.  -= IMHO =-
> >
> > The short answer to your question is yes, it will run on Solaris 9.
> >
> > Greg
> >
> >
> > Peter Eisentraut wrote:
> > >Danielle Cossette writes:
> > >
> > >
> > >>Could you please let me know if Postgres 7.1.3 will run on Solaris 9.
> > >
> > >
> > >Why don't you try it out?
> > >
> >
> >
> > --
> > Greg Spiegelberg
> >  Sr. Product Development Engineer
> >  Cranel, Incorporated.
> >  Phone: 614.318.4314
> >  Fax:   614.431.8388
> >  Email: gspiegelberg@Cranel.com
> > Cranel. Technology. Integrity. Focus.
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 7: don't forget to increase your free space map settings
>----------------------------------------------------------------------
>Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
>Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/
>
>---------------------------(end of broadcast)---------------------------
>TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match


-------------------------------------------------------------------------------------------------------------------------
Naomi Walker                         Chief Information Officer
                                               Eldorado Computing, Inc.
nwalker@eldocomp.com           602-604-3100

-------------------------------------------------------------------------------------------------------------------------
Insanity is doing things in the same way and expecting different results.

------------------------------------------------------------------------------------------------------------------------

-- CONFIDENTIALITY NOTICE --

This message is intended for the sole use of the individual and entity to whom it is addressed, and may contain
informationthat is privileged, confidential and exempt from disclosure under applicable law. If you are not the
intendedaddressee, nor authorized to receive for the intended addressee, you are hereby notified that you may not use,
copy,disclose or distribute to anyone the message or any information contained in the message. If you have received
thismessage in error, please immediately advise the sender by reply email, and delete the message. Thank you.