Thread: postgresql amd-64
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
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.
> 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
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
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
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.
-------------------------------------------------------------------------
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
> > 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