Re: Postgresql on SUN Server

Поиск
Список
Период
Сортировка
От scott.marlowe
Тема Re: Postgresql on SUN Server
Дата
Msg-id Pine.LNX.4.33.0305270902140.12134-100000@css120.ihs.com
обсуждение исходный текст
Ответ на Re: Postgresql on SUN Server  (Martin Marques <martin@bugs.unl.edu.ar>)
Ответы Relation hash table  (Nailah Ogeer <ogeer@cs.queensu.ca>)
Re: Postgresql on SUN Server  (Andrew Sullivan <andrew@libertyrms.info>)
Список 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 по дате отправления:

Предыдущее
От: Damien
Дата:
Сообщение: Re: speed w/ OFFSET/LIMIT
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: pg_dump and data consistency in the backup