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.