Re: Postgresql on SUN Server - Mailing list pgsql-general

From scott.marlowe
Subject Re: Postgresql on SUN Server
Date
Msg-id Pine.LNX.4.33.0305270902140.12134-100000@css120.ihs.com
Whole thread Raw
In response to Re: Postgresql on SUN Server  (Martin Marques <martin@bugs.unl.edu.ar>)
Responses Relation hash table  (Nailah Ogeer <ogeer@cs.queensu.ca>)
Re: Postgresql on SUN Server  (Andrew Sullivan <andrew@libertyrms.info>)
List pgsql-general
On Sat, 24 May 2003, Martin Marques wrote:

> On Vie 23 May 2003 17:01, scott.marlowe wrote:
> >
> > None really.  You may as well set --enable-integer-datetimes when
> > compiling since there should be no great performance penalty for
> > running 64 bit values for datetime.
> >
> > Other than that, no great difference.  note that being on 64 bit
> > hardware means you can likely have much more shared buffer memory than
> > on X86 hardware, where you're limited to ~2 gig.
>
> Those this mean no more the ~2Gig total shared memory? Or each aplication?

Correct.  The max shared memory segment on 64 bit hardware is larger than
any amount of RAM currently installable.  I'm pretty sure the limit is
so large that the overhead of handling a large segment would become a
problem long before you'd be able to hit a hard limit.

>
> > > Is the difference only at the OS level which is redhat or are there
> > > impacts on the database ?
> >
> > Mostly the OS.  I know RedHat had dropped their Sparc line, but there
> > is a project out there (can't recall the name, but you can google for
> > it) that 'ports' RedHat's releases to Sparc hardware.
>
> http://auroralinux.org/

Thanks for the link, I was looking for it and couldn't find it just a day
or two after seeing it.

> > Debian maintains a Sparc port if you want to use debian.
>
> Here we are starting to use Debian, but due to the fact that one of the
> Admins has switched to it. And you know how fundamentalists they are! :-)

Oh yes.  Right up there with some of the "Solaris on X86" folks I've met.



pgsql-general by date:

Previous
From: Damien
Date:
Subject: Re: speed w/ OFFSET/LIMIT
Next
From: "scott.marlowe"
Date:
Subject: Re: pg_dump and data consistency in the backup