Thread: postgresql amd-64

postgresql amd-64

From
"Merlin Moncure"
Date:
Does anybody have any experiences with postgresql 7.4+ running on amd-64
in 64 bit mode?  Specifically, does it run quicker and if so do the
performance benefits justify the extra headaches running 64 bit linux?

Right now I'm building a dual Opteron 246 with 4 gig ddr400.

Merlin

Re: postgresql amd-64

From
Daniel Ceregatti
Date:
I have two dual opteron 248's with 4g of ram each, 6x36G 15k rpm ultra
320 scsi disks in hardware raid 5, and they are by far the fastest
machines I've user used. As far as this "headache" of using 64 bit
Linux, I've experienced no such thing. I'm using gentoo on both
machines, which are dedicated for postgres 7.4 and replicated with
slony. They're both quite fast and reliable. One machine even runs a
secondary instance of pg, pg 8 beta4 in this case, for development,
which also runs quite well.

Daniel

Merlin Moncure wrote:

>Does anybody have any experiences with postgresql 7.4+ running on amd-64
>in 64 bit mode?  Specifically, does it run quicker and if so do the
>performance benefits justify the extra headaches running 64 bit linux?
>
>Right now I'm building a dual Opteron 246 with 4 gig ddr400.
>
>Merlin
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faqs/FAQ.html
>
>

--

Daniel Ceregatti - Programmer
Omnis Network, LLC

The forest is safe because a lion lives therein and the lion is safe because
it lives in a forest.  Likewise the friendship of persons rests on mutual help.
        -- Laukikanyay.


Re: postgresql amd-64

From
"Merlin Moncure"
Date:
> I have two dual opteron 248's with 4g of ram each, 6x36G 15k rpm ultra
> 320 scsi disks in hardware raid 5, and they are by far the fastest
> machines I've user used. As far as this "headache" of using 64 bit
> Linux, I've experienced no such thing. I'm using gentoo on both
> machines, which are dedicated for postgres 7.4 and replicated with
> slony. They're both quite fast and reliable. One machine even runs a
> secondary instance of pg, pg 8 beta4 in this case, for development,
> which also runs quite well.

Good, I'll give it a shot and see what I come up with...thx.

Merlin

Re: postgresql amd-64

From
"Vishal Kashyap @ [Sai Hertz And Control Systems]"
Date:
Merlin,




> Good, I'll give it a shot and see what I come up with...thx.
>
Do share your experience with us.

--
With Best Regards,
Vishal Kashyap.
Did you know SaiPACS is one and only PACS
Management tool.
http://saihertz.com

Re: postgresql amd-64

From
"Iain"
Date:
I'm hoping I'll have the opportunity to build a similar machine soon and am
wondering about the choice of 64 bit distributions.

Gentoo is obviously a possibility but I'm also condsidering Debian. There is
also a 64 compile of redhat sources somewhere around, but I can't remember
what they call it offhand.

If anyone has opinions about that, I'd be happy to hear.

regards
Iain

----- Original Message -----
From: "Daniel Ceregatti" <daniel@omnis.com>
To: "Merlin Moncure" <merlin.moncure@rcsonline.com>
Cc: <pgsql-performance@postgresql.org>
Sent: Saturday, November 06, 2004 3:23 AM
Subject: Re: [PERFORM] postgresql amd-64


>I have two dual opteron 248's with 4g of ram each, 6x36G 15k rpm ultra
> 320 scsi disks in hardware raid 5, and they are by far the fastest
> machines I've user used. As far as this "headache" of using 64 bit
> Linux, I've experienced no such thing. I'm using gentoo on both
> machines, which are dedicated for postgres 7.4 and replicated with
> slony. They're both quite fast and reliable. One machine even runs a
> secondary instance of pg, pg 8 beta4 in this case, for development,
> which also runs quite well.
>
> Daniel
>
> Merlin Moncure wrote:
>
>>Does anybody have any experiences with postgresql 7.4+ running on amd-64
>>in 64 bit mode?  Specifically, does it run quicker and if so do the
>>performance benefits justify the extra headaches running 64 bit linux?
>>
>>Right now I'm building a dual Opteron 246 with 4 gig ddr400.
>>
>>Merlin
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 5: Have you checked our extensive FAQ?
>>
>>               http://www.postgresql.org/docs/faqs/FAQ.html
>>
>>
>
> --
>
> Daniel Ceregatti - Programmer
> Omnis Network, LLC
>
> The forest is safe because a lion lives therein and the lion is safe
> because
> it lives in a forest.  Likewise the friendship of persons rests on mutual
> help.
> -- Laukikanyay.
>
>
> ---------------------------(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


Re: postgresql amd-64

From
"Iain"
Date:
Hi Andrew,

I had never heard of Ubuntu before, thanks for the tip.

regards
iain
----- Original Message -----
From: "Andrew McMillan" <andrew@catalyst.net.nz>
To: "Iain" <iain@mst.co.jp>
Sent: Monday, November 08, 2004 12:51 PM
Subject: Re: [PERFORM] postgresql amd-64

On Mon, 2004-11-08 at 11:13 +0900, Iain wrote:
> I'm hoping I'll have the opportunity to build a similar machine soon and
> am
> wondering about the choice of 64 bit distributions.
>
> Gentoo is obviously a possibility but I'm also condsidering Debian. There
> is
> also a 64 compile of redhat sources somewhere around, but I can't remember
> what they call it offhand.
>
> If anyone has opinions about that, I'd be happy to hear.

Hi Iain,

We are using Debian on a few dual-Opteron systems and a number of AMD64
desktop systems and it is working fine.

We are also using Ubuntu, which can be installed with the "Custom"
options for a server, is Debian based, and includes PostgreSQL in the
basic supported package set.

Due to the better security support for AMD64 in Ubuntu we are likely to
migrate our server environments to that, at least until there is a more
officially support AMD64 port for Debian.

Cheers,
     Andrew.

-------------------------------------------------------------------------
Andrew @ Catalyst .Net .NZ  Ltd,  PO Box 11-053, Manners St,  Wellington
WEB: http://catalyst.net.nz/            PHYS: Level 2, 150-154 Willis St
DDI: +64(4)803-2201      MOB: +64(272)DEBIAN      OFFICE: +64(4)499-2267
                        Don't get to bragging.
-------------------------------------------------------------------------



Re: postgresql amd-64

From
Radu-Adrian Popescu
Date:
Iain wrote:
> I'm hoping I'll have the opportunity to build a similar machine soon and
> am wondering about the choice of 64 bit distributions.
>
> Gentoo is obviously a possibility but I'm also condsidering Debian.
> There is also a 64 compile of redhat sources somewhere around, but I
> can't remember what they call it offhand.
>

RedHat's community OS is now called Fedora: http://fedora.redhat.com/
There's been two AMD64 releases of this OS, Fedora Core 1 and Fedora Core 2.
Core 3 is just around the corner.
I've been running FC2 x86_64 with kernel 2.6 as a desktop system for quite some
time now, with PostgreSQL 7.4.2 / 64bit installed.
I find Fedora to be a really good Linux distro, continuing and improving upon
the fine tradition of RedHat's releases.
You can also get RedHat's commercial releases on AMD64; according to
http://www.redhat.com/software/rhel/features/
you can also get a EM64T release.

> If anyone has opinions about that, I'd be happy to hear.

--
Radu-Adrian Popescu
CSA, DBA, Developer
Aldrapay MD
Aldratech Ltd.
+40213212243

Attachment

Re: postgresql amd-64

From
"Merlin Moncure"
Date:
> > Good, I'll give it a shot and see what I come up with...thx.
> >
> Do share your experience with us.

Will do.  I have to ship the server on Friday, and the parts are on
order.  If they come today, I'll have time to test Gentoo, Redhat 32/64,
and win32 by then.  If I can't get it built until tomorrow,
unfortunately the Gentoo test will have to be skipped.

The win32 test is forced because our clients prefer win32 and I have to
justify any platform change with a reasonable performance advantage.  I
have to compile and install a lot of software (including subversion,
which I'm using to manage our application binaries), and I'm wary of 64
bit library issues which will hold me up.  Any major roadblocks and I'll
be forced to drop the test.

When I'm finished I'll throw a link to this list, probably Friday.

Merlin