Postgresql & AMD x86-64

Hi guys,

Does anyone want remote access to the upcoming AMD 64 bit architecture,
to make sure PostgreSQL runs well on it?

It's only via remote access at present, but the AMD guys are willing to
help us out here.

Regards and best wishes,

Justin Clift

-------- Original Message --------
Subject: RE: Postgresql AMD x86-64
Date: Fri, 4 Apr 2003 10:29:24 -0800
From: marc(dot)miller(at)amd(dot)com
To: justin(at)postgresql(dot)org
CC: aj(at)suse(dot)de, chris(dot)rimer(at)amd(dot)com

Justin,

I apologize for the delayed response. Unfortunately, at the moment I
don't have a system available to send you. If I could get you access to
a machine remotely, would that be useful to you? I will need to check
machine availability before I can promise you anything, but I'm willing
to be your sponsor in the AMD Developer Center and approve a request for
access.

-----Original Message-----
From: Justin Clift [mailto:justin(at)postgresql(dot)org]
Sent: Monday, March 10, 2003 7:31 PM
To: Andreas Jaeger
Subject: Re: AMD x86-64

Hi Andreas,

Have you heard anything back from the AMD guys in relation to this?

We've not heard a single thing from them.

:-(

Regards and best wishes,

Justin Clift

Andreas Jaeger wrote:
> Justin Clift <justin(at)postgresql(dot)org> writes:
<snip>
>>Yep, the aim is to allow PostgreSQL developers access to a system
>>running x86-64 hardware as needed.
>>
>>Trying to get ahead of the ballgame these days. :)
>>
>>>If you have hammer Hardware, I can provide you with a prerelease of
>>>our software,
>>
>>That would be cool Andreas, thanks.
>>
>>Now, just need to secure the hardware somehow. Personally, I feel
>>that an email forwarded from you to the right people at AMD may help
>>that significantly. At least, people from AMD should get in contact
>>with us to see if something beneficial can be arranged.
>
> Ok, I forwarded your note and let's see whether they're interested
> (there're already a few commercial database like IBM DB2 ported).
> From past experience, it might be difficult to get hardware directly
> but let's wait for their answer.
>
> If you don't hear anything this week, feel free to ask me again,
>
> Andreas

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi

Hi folks,

We recently built a dual K8D-based Opteron box running Linux in 64-bit
mode (Debian 'testing' distribution with newly compiled binutils, gcc,
and various support libraries for amd64 architecture).

The Postgres 7.3.3 "port" was simply a matter of setting the appropriate
flags to take of the biarchectecture nature of the Linux port. (that is,
"-m64" to generate 64 bit code and either "gcc -m64" or "ld -melf_x86_64"
for linking"). There were no other issues in the compile. In the
install, I had to re-init due to the incompatibility of pg_control.

All the regression tests went smoothly (the one "failure" was in geometry
and is due to round off in the least sig figs of the doubles in the Point
structure or machine zero differences).

I compared a simple query on local data in both 32bit mode and 64bit mode;
the execute time difference was not significant but this was not a compute
intensive verification (summing up column values in a table). We have
some other 32-bit amd machines here; I would be happy to try a few other
tests.

Good job, developers!!!

On Mon, 07 Apr 2003 18:34:05 +0800
Justin Clift <justin(at)postgresql(dot)org> wrote:

> Hi guys,
>
> Does anyone want remote access to the upcoming AMD 64 bit architecture,
> to make sure PostgreSQL runs well on it?
>
> It's only via remote access at present, but the AMD guys are willing to
> help us out here.
>
> Regards and best wishes,
>
> Justin Clift
>
>
> -------- Original Message --------
> Subject: RE: Postgresql AMD x86-64
> Date: Fri, 4 Apr 2003 10:29:24 -0800
> From: marc(dot)miller(at)amd(dot)com
> To: justin(at)postgresql(dot)org
> CC: aj(at)suse(dot)de, chris(dot)rimer(at)amd(dot)com
>
> Justin,
>
> I apologize for the delayed response. Unfortunately, at the moment I
> don't have a system available to send you. If I could get you access to
> a machine remotely, would that be useful to you? I will need to check
> machine availability before I can promise you anything, but I'm willing
> to be your sponsor in the AMD Developer Center and approve a request for
> access.
>
> -----Original Message-----
> From: Justin Clift [mailto:justin(at)postgresql(dot)org]
> Sent: Monday, March 10, 2003 7:31 PM
> To: Andreas Jaeger
> Subject: Re: AMD x86-64
>
>
> Hi Andreas,
>
> Have you heard anything back from the AMD guys in relation to this?
>
> We've not heard a single thing from them.
>
> :-(
>
> Regards and best wishes,
>
> Justin Clift
>
>
> Andreas Jaeger wrote:
> > Justin Clift <justin(at)postgresql(dot)org> writes:
> <snip>
> >>Yep, the aim is to allow PostgreSQL developers access to a system
> >>running x86-64 hardware as needed.
> >>
> >>Trying to get ahead of the ballgame these days. :)
> >>
> >>>If you have hammer Hardware, I can provide you with a prerelease of
> >>>our software,
> >>
> >>That would be cool Andreas, thanks.
> >>
> >>Now, just need to secure the hardware somehow. Personally, I feel
> >>that an email forwarded from you to the right people at AMD may help
> >>that significantly. At least, people from AMD should get in contact
> >>with us to see if something beneficial can be arranged.
> >
> > Ok, I forwarded your note and let's see whether they're interested
> > (there're already a few commercial database like IBM DB2 ported).
> > From past experience, it might be difficult to get hardware directly
> > but let's wait for their answer.
> >
> > If you don't hear anything this week, feel free to ask me again,
> >
> > Andreas
>
>
> --
> "My grandfather once told me that there are two kinds of people: those
> who work and those who take the credit. He told me to try to be in the
> first group; there was less competition there."
> - Indira Gandhi
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
Martin Weinberg Phone: (413) 545-3821
Dept. of Astronomy FAX: (413) 545-4223
530 Graduate Research Tower weinberg(at)astro(dot)umass(dot)edu
University of Massachusetts http://www.astro.umass.edu/~weinberg/
Amherst, MA 01003-4525

Hi folks,

We recently built a dual K8D-based Opteron box running Linux in 64-bit
mode (Debian 'testing' distribution with newly compiled binutils, gcc,
and various support libraries for amd64 architecture).

The Postgres 7.3.3 "port" was simply a matter of setting the appropriate
flags to take of the biarchectecture nature of the Linux port. (that is,
"-m64" to generate 64 bit code and either "gcc -m64" or "ld -melf_x86_64"
for linking"). There were no other issues in the compile. In the
install, I had to re-init due to the incompatibility of pg_control.

All the regression tests went smoothly (the one "failure" was in geometry
and is due to round off in the least sig figs of the doubles in the Point
structure or machine zero differences).

I compared a simple query on local data in both 32bit mode and 64bit mode;
the execute time difference was not significant but this was not a compute
intensive verification (summing up column values in a table). We have
some other 32-bit amd machines here; I would be happy to try a few other
tests.

Good job, developers!!!

On Mon, 07 Apr 2003 18:34:05 +0800
Justin Clift <justin(at)postgresql(dot)org> wrote:

> Hi guys,
>
> Does anyone want remote access to the upcoming AMD 64 bit architecture,
> to make sure PostgreSQL runs well on it?
>
> It's only via remote access at present, but the AMD guys are willing to
> help us out here.
>
> Regards and best wishes,
>
> Justin Clift
>
>
> -------- Original Message --------
> Subject: RE: Postgresql AMD x86-64
> Date: Fri, 4 Apr 2003 10:29:24 -0800
> From: marc(dot)miller(at)amd(dot)com
> To: justin(at)postgresql(dot)org
> CC: aj(at)suse(dot)de, chris(dot)rimer(at)amd(dot)com
>
> Justin,
>
> I apologize for the delayed response. Unfortunately, at the moment I
> don't have a system available to send you. If I could get you access to
> a machine remotely, would that be useful to you? I will need to check
> machine availability before I can promise you anything, but I'm willing
> to be your sponsor in the AMD Developer Center and approve a request for
> access.
>
> -----Original Message-----
> From: Justin Clift [mailto:justin(at)postgresql(dot)org]
> Sent: Monday, March 10, 2003 7:31 PM
> To: Andreas Jaeger
> Subject: Re: AMD x86-64
>
>
> Hi Andreas,
>
> Have you heard anything back from the AMD guys in relation to this?
>
> We've not heard a single thing from them.
>
> :-(
>
> Regards and best wishes,
>
> Justin Clift
>
>
> Andreas Jaeger wrote:
> > Justin Clift <justin(at)postgresql(dot)org> writes:
> <snip>
> >>Yep, the aim is to allow PostgreSQL developers access to a system
> >>running x86-64 hardware as needed.
> >>
> >>Trying to get ahead of the ballgame these days. :)
> >>
> >>>If you have hammer Hardware, I can provide you with a prerelease of
> >>>our software,
> >>
> >>That would be cool Andreas, thanks.
> >>
> >>Now, just need to secure the hardware somehow. Personally, I feel
> >>that an email forwarded from you to the right people at AMD may help
> >>that significantly. At least, people from AMD should get in contact
> >>with us to see if something beneficial can be arranged.
> >
> > Ok, I forwarded your note and let's see whether they're interested
> > (there're already a few commercial database like IBM DB2 ported).
> > From past experience, it might be difficult to get hardware directly
> > but let's wait for their answer.
> >
> > If you don't hear anything this week, feel free to ask me again,
> >
> > Andreas
>
>
> --
> "My grandfather once told me that there are two kinds of people: those
> who work and those who take the credit. He told me to try to be in the
> first group; there was less competition there."
> - Indira Gandhi
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
Martin Weinberg Phone: (413) 545-3821
Dept. of Astronomy FAX: (413) 545-4223
530 Graduate Research Tower weinberg(at)astro(dot)umass(dot)edu
University of Massachusetts http://www.astro.umass.edu/~weinberg/
Amherst, MA 01003-4525

Can you send us a patch?

---------------------------------------------------------------------------

Martin D. Weinberg wrote:
> Hi folks,
>
> We recently built a dual K8D-based Opteron box running Linux in 64-bit
> mode (Debian 'testing' distribution with newly compiled binutils, gcc,
> and various support libraries for amd64 architecture).
>
> The Postgres 7.3.3 "port" was simply a matter of setting the appropriate
> flags to take of the biarchectecture nature of the Linux port. (that is,
> "-m64" to generate 64 bit code and either "gcc -m64" or "ld -melf_x86_64"
> for linking"). There were no other issues in the compile. In the
> install, I had to re-init due to the incompatibility of pg_control.
>
> All the regression tests went smoothly (the one "failure" was in geometry
> and is due to round off in the least sig figs of the doubles in the Point
> structure or machine zero differences).
>
> I compared a simple query on local data in both 32bit mode and 64bit mode;
> the execute time difference was not significant but this was not a compute
> intensive verification (summing up column values in a table). We have
> some other 32-bit amd machines here; I would be happy to try a few other
> tests.
>
> Good job, developers!!!
>
> On Mon, 07 Apr 2003 18:34:05 +0800
> Justin Clift <justin(at)postgresql(dot)org> wrote:
>
> > Hi guys,
> >
> > Does anyone want remote access to the upcoming AMD 64 bit architecture,
> > to make sure PostgreSQL runs well on it?
> >
> > It's only via remote access at present, but the AMD guys are willing to
> > help us out here.
> >
> > Regards and best wishes,
> >
> > Justin Clift
> >
> >
> > -------- Original Message --------
> > Subject: RE: Postgresql AMD x86-64
> > Date: Fri, 4 Apr 2003 10:29:24 -0800
> > From: marc(dot)miller(at)amd(dot)com
> > To: justin(at)postgresql(dot)org
> > CC: aj(at)suse(dot)de, chris(dot)rimer(at)amd(dot)com
> >
> > Justin,
> >
> > I apologize for the delayed response. Unfortunately, at the moment I
> > don't have a system available to send you. If I could get you access to
> > a machine remotely, would that be useful to you? I will need to check
> > machine availability before I can promise you anything, but I'm willing
> > to be your sponsor in the AMD Developer Center and approve a request for
> > access.
> >
> > -----Original Message-----
> > From: Justin Clift [mailto:justin(at)postgresql(dot)org]
> > Sent: Monday, March 10, 2003 7:31 PM
> > To: Andreas Jaeger
> > Subject: Re: AMD x86-64
> >
> >
> > Hi Andreas,
> >
> > Have you heard anything back from the AMD guys in relation to this?
> >
> > We've not heard a single thing from them.
> >
> > :-(
> >
> > Regards and best wishes,
> >
> > Justin Clift
> >
> >
> > Andreas Jaeger wrote:
> > > Justin Clift <justin(at)postgresql(dot)org> writes:
> > <snip>
> > >>Yep, the aim is to allow PostgreSQL developers access to a system
> > >>running x86-64 hardware as needed.
> > >>
> > >>Trying to get ahead of the ballgame these days. :)
> > >>
> > >>>If you have hammer Hardware, I can provide you with a prerelease of
> > >>>our software,
> > >>
> > >>That would be cool Andreas, thanks.
> > >>
> > >>Now, just need to secure the hardware somehow. Personally, I feel
> > >>that an email forwarded from you to the right people at AMD may help
> > >>that significantly. At least, people from AMD should get in contact
> > >>with us to see if something beneficial can be arranged.
> > >
> > > Ok, I forwarded your note and let's see whether they're interested
> > > (there're already a few commercial database like IBM DB2 ported).
> > > From past experience, it might be difficult to get hardware directly
> > > but let's wait for their answer.
> > >
> > > If you don't hear anything this week, feel free to ask me again,
> > >
> > > Andreas
> >
> >
> > --
> > "My grandfather once told me that there are two kinds of people: those
> > who work and those who take the credit. He told me to try to be in the
> > first group; there was less competition there."
> > - Indira Gandhi
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
>
>
> --
> Martin Weinberg Phone: (413) 545-3821
> Dept. of Astronomy FAX: (413) 545-4223
> 530 Graduate Research Tower weinberg(at)astro(dot)umass(dot)edu
> University of Massachusetts http://www.astro.umass.edu/~weinberg/
> Amherst, MA 01003-4525
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

Can you send in a report for the supported platforms list?
http://developer.postgresql.org/docs/postgres/supported-platforms.html

Robert Treat

On Tue, 2003-06-10 at 13:16, Martin D. Weinberg wrote:
> Hi folks,
>
> We recently built a dual K8D-based Opteron box running Linux in 64-bit
> mode (Debian 'testing' distribution with newly compiled binutils, gcc,
> and various support libraries for amd64 architecture).
>
> The Postgres 7.3.3 "port" was simply a matter of setting the appropriate
> flags to take of the biarchectecture nature of the Linux port. (that is,
> "-m64" to generate 64 bit code and either "gcc -m64" or "ld -melf_x86_64"
> for linking"). There were no other issues in the compile. In the
> install, I had to re-init due to the incompatibility of pg_control.
>
> All the regression tests went smoothly (the one "failure" was in geometry
> and is due to round off in the least sig figs of the doubles in the Point
> structure or machine zero differences).
>
> I compared a simple query on local data in both 32bit mode and 64bit mode;
> the execute time difference was not significant but this was not a compute
> intensive verification (summing up column values in a table). We have
> some other 32-bit amd machines here; I would be happy to try a few other
> tests.
>
> Good job, developers!!!
>
> On Mon, 07 Apr 2003 18:34:05 +0800
> Justin Clift <justin(at)postgresql(dot)org> wrote:
>
> > Hi guys,
> >
> > Does anyone want remote access to the upcoming AMD 64 bit architecture,
> > to make sure PostgreSQL runs well on it?
> >
> > It's only via remote access at present, but the AMD guys are willing to
> > help us out here.
> >
> > Regards and best wishes,
> >
> > Justin Clift
> >
> >
> > -------- Original Message --------
> > Subject: RE: Postgresql AMD x86-64
> > Date: Fri, 4 Apr 2003 10:29:24 -0800
> > From: marc(dot)miller(at)amd(dot)com
> > To: justin(at)postgresql(dot)org
> > CC: aj(at)suse(dot)de, chris(dot)rimer(at)amd(dot)com
> >
> > Justin,
> >
> > I apologize for the delayed response. Unfortunately, at the moment I
> > don't have a system available to send you. If I could get you access to
> > a machine remotely, would that be useful to you? I will need to check
> > machine availability before I can promise you anything, but I'm willing
> > to be your sponsor in the AMD Developer Center and approve a request for
> > access.
> >
> > -----Original Message-----
> > From: Justin Clift [mailto:justin(at)postgresql(dot)org]
> > Sent: Monday, March 10, 2003 7:31 PM
> > To: Andreas Jaeger
> > Subject: Re: AMD x86-64
> >
> >
> > Hi Andreas,
> >
> > Have you heard anything back from the AMD guys in relation to this?
> >
> > We've not heard a single thing from them.
> >
> > :-(
> >
> > Regards and best wishes,
> >
> > Justin Clift
> >
> >
> > Andreas Jaeger wrote:
> > > Justin Clift <justin(at)postgresql(dot)org> writes:
> > <snip>
> > >>Yep, the aim is to allow PostgreSQL developers access to a system
> > >>running x86-64 hardware as needed.
> > >>
> > >>Trying to get ahead of the ballgame these days. :)
> > >>
> > >>>If you have hammer Hardware, I can provide you with a prerelease of
> > >>>our software,
> > >>
> > >>That would be cool Andreas, thanks.
> > >>
> > >>Now, just need to secure the hardware somehow. Personally, I feel
> > >>that an email forwarded from you to the right people at AMD may help
> > >>that significantly. At least, people from AMD should get in contact
> > >>with us to see if something beneficial can be arranged.
> > >
> > > Ok, I forwarded your note and let's see whether they're interested
> > > (there're already a few commercial database like IBM DB2 ported).
> > > From past experience, it might be difficult to get hardware directly
> > > but let's wait for their answer.
> > >
> > > If you don't hear anything this week, feel free to ask me again,
> > >
> > > Andreas
> >
> >
> > --
> > "My grandfather once told me that there are two kinds of people: those
> > who work and those who take the credit. He told me to try to be in the
> > first group; there was less competition there."
> > - Indira Gandhi
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
>
>
> --
> Martin Weinberg Phone: (413) 545-3821
> Dept. of Astronomy FAX: (413) 545-4223
> 530 Graduate Research Tower weinberg(at)astro(dot)umass(dot)edu
> University of Massachusetts http://www.astro.umass.edu/~weinberg/
> Amherst, MA 01003-4525
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

Bruce,

I didn't change the source tree at all. I used:

env CFLAGS='-O3 -m64' LD='/usr/bin/ld -melf_x86_64' ./configure --with-CXX --without-zlib

with the experimental gcc and bintils from www.x86-64.org. I needed
--without-zlib because I don't have a 64 bit compile yet for zlib.

make
make install-all-headers
make check CC='gcc -m64'

The last one is needed to make sure that the shared library gets made
in the amd64 architecture.

That's it!

On Tue, 10 Jun 2003 14:14:22 -0400 (EDT)
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> wrote:

>
> Can you send us a patch?
>
> ---------------------------------------------------------------------------
>
> Martin D. Weinberg wrote:
> > Hi folks,
> >
> > We recently built a dual K8D-based Opteron box running Linux in 64-bit
> > mode (Debian 'testing' distribution with newly compiled binutils, gcc,
> > and various support libraries for amd64 architecture).
> >
> > The Postgres 7.3.3 "port" was simply a matter of setting the appropriate
> > flags to take of the biarchectecture nature of the Linux port. (that is,
> > "-m64" to generate 64 bit code and either "gcc -m64" or "ld -melf_x86_64"
> > for linking"). There were no other issues in the compile. In the
> > install, I had to re-init due to the incompatibility of pg_control.
> >
> > All the regression tests went smoothly (the one "failure" was in geometry
> > and is due to round off in the least sig figs of the doubles in the Point
> > structure or machine zero differences).
> >
> > I compared a simple query on local data in both 32bit mode and 64bit mode;
> > the execute time difference was not significant but this was not a compute
> > intensive verification (summing up column values in a table). We have
> > some other 32-bit amd machines here; I would be happy to try a few other
> > tests.
> >
> > Good job, developers!!!
> >
> > On Mon, 07 Apr 2003 18:34:05 +0800
> > Justin Clift <justin(at)postgresql(dot)org> wrote:
> >
> > > Hi guys,
> > >
> > > Does anyone want remote access to the upcoming AMD 64 bit architecture,
> > > to make sure PostgreSQL runs well on it?
> > >
> > > It's only via remote access at present, but the AMD guys are willing to
> > > help us out here.
> > >
> > > Regards and best wishes,
> > >
> > > Justin Clift
> > >
> > >
> > > -------- Original Message --------
> > > Subject: RE: Postgresql AMD x86-64
> > > Date: Fri, 4 Apr 2003 10:29:24 -0800
> > > From: marc(dot)miller(at)amd(dot)com
> > > To: justin(at)postgresql(dot)org
> > > CC: aj(at)suse(dot)de, chris(dot)rimer(at)amd(dot)com
> > >
> > > Justin,
> > >
> > > I apologize for the delayed response. Unfortunately, at the moment I
> > > don't have a system available to send you. If I could get you access to
> > > a machine remotely, would that be useful to you? I will need to check
> > > machine availability before I can promise you anything, but I'm willing
> > > to be your sponsor in the AMD Developer Center and approve a request for
> > > access.
> > >
> > > -----Original Message-----
> > > From: Justin Clift [mailto:justin(at)postgresql(dot)org]
> > > Sent: Monday, March 10, 2003 7:31 PM
> > > To: Andreas Jaeger
> > > Subject: Re: AMD x86-64
> > >
> > >
> > > Hi Andreas,
> > >
> > > Have you heard anything back from the AMD guys in relation to this?
> > >
> > > We've not heard a single thing from them.
> > >
> > > :-(
> > >
> > > Regards and best wishes,
> > >
> > > Justin Clift
> > >
> > >
> > > Andreas Jaeger wrote:
> > > > Justin Clift <justin(at)postgresql(dot)org> writes:
> > > <snip>
> > > >>Yep, the aim is to allow PostgreSQL developers access to a system
> > > >>running x86-64 hardware as needed.
> > > >>
> > > >>Trying to get ahead of the ballgame these days. :)
> > > >>
> > > >>>If you have hammer Hardware, I can provide you with a prerelease of
> > > >>>our software,
> > > >>
> > > >>That would be cool Andreas, thanks.
> > > >>
> > > >>Now, just need to secure the hardware somehow. Personally, I feel
> > > >>that an email forwarded from you to the right people at AMD may help
> > > >>that significantly. At least, people from AMD should get in contact
> > > >>with us to see if something beneficial can be arranged.
> > > >
> > > > Ok, I forwarded your note and let's see whether they're interested
> > > > (there're already a few commercial database like IBM DB2 ported).
> > > > From past experience, it might be difficult to get hardware directly
> > > > but let's wait for their answer.
> > > >
> > > > If you don't hear anything this week, feel free to ask me again,
> > > >
> > > > Andreas
> > >
> > >
> > > --
> > > "My grandfather once told me that there are two kinds of people: those
> > > who work and those who take the credit. He told me to try to be in the
> > > first group; there was less competition there."
> > > - Indira Gandhi
> > >
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 4: Don't 'kill -9' the postmaster
> > >
> >
> >
> > --
> > Martin Weinberg Phone: (413) 545-3821
> > Dept. of Astronomy FAX: (413) 545-4223
> > 530 Graduate Research Tower weinberg(at)astro(dot)umass(dot)edu
> > University of Massachusetts http://www.astro.umass.edu/~weinberg/
> > Amherst, MA 01003-4525
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
> >
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
> + If your life is a hard drive, | 13 Roberts Road
> + Christ can be your backup. | Newtown Square, Pennsylvania 19073
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

--
Martin Weinberg Phone: (413) 545-3821
Dept. of Astronomy FAX: (413) 545-4223
530 Graduate Research Tower weinberg(at)astro(dot)umass(dot)edu
University of Massachusetts http://www.astro.umass.edu/~weinberg/
Amherst, MA 01003-4525

"Martin D. Weinberg" <weinberg(at)osprey(dot)astro(dot)umass(dot)edu> writes:
> I didn't change the source tree at all. I used:

> env CFLAGS='-O3 -m64' LD='/usr/bin/ld -melf_x86_64' ./configure --with-CXX --without-zlib

BTW, see Jeff Baker's nearby report in pgsql-general that s_lock.h needs
to be tweaked to use spinlocks on this platform. If you're using
semaphores instead then you're taking a big performance hit.

regards, tom lane

The s_lock.h change will be in 7.4.

---------------------------------------------------------------------------

Tom Lane wrote:
> "Martin D. Weinberg" <weinberg(at)osprey(dot)astro(dot)umass(dot)edu> writes:
> > I didn't change the source tree at all. I used:
>
> > env CFLAGS='-O3 -m64' LD='/usr/bin/ld -melf_x86_64' ./configure --with-CXX --without-zlib
>
> BTW, see Jeff Baker's nearby report in pgsql-general that s_lock.h needs
> to be tweaked to use spinlocks on this platform. If you're using
> semaphores instead then you're taking a big performance hit.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

Interesting. The compiler doesn't do x86_64 by default --- you have to
enable it in the compile.

Any idea how to handle this in our builds? It doesn't seem like a
property of the OS as much as a property of the compiler --- we
already do 64-bit on some platforms without flags.

What is the full ac_cv_host value in config.log?

ac_cv_host=i386-pc-bsdi4.3.1

I assume there is something special in the first field before the dash
that could trigger these compile/link flags automatically.

As I already mentioned, the s_lock.h changes will appear in 7.4 and are
in CVS now.

---------------------------------------------------------------------------

Martin D. Weinberg wrote:
> Bruce,
>
> I didn't change the source tree at all. I used:
>
> env CFLAGS='-O3 -m64' LD='/usr/bin/ld -melf_x86_64' ./configure --with-CXX --without-zlib
>
> with the experimental gcc and bintils from www.x86-64.org. I needed
> --without-zlib because I don't have a 64 bit compile yet for zlib.
>
> make
> make install-all-headers
> make check CC='gcc -m64'
>
> The last one is needed to make sure that the shared library gets made
> in the amd64 architecture.
>
> That's it!
>
>
> On Tue, 10 Jun 2003 14:14:22 -0400 (EDT)
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> wrote:
>
> >
> > Can you send us a patch?
> >
> > ---------------------------------------------------------------------------
> >
> > Martin D. Weinberg wrote:
> > > Hi folks,
> > >
> > > We recently built a dual K8D-based Opteron box running Linux in 64-bit
> > > mode (Debian 'testing' distribution with newly compiled binutils, gcc,
> > > and various support libraries for amd64 architecture).
> > >
> > > The Postgres 7.3.3 "port" was simply a matter of setting the appropriate
> > > flags to take of the biarchectecture nature of the Linux port. (that is,
> > > "-m64" to generate 64 bit code and either "gcc -m64" or "ld -melf_x86_64"
> > > for linking"). There were no other issues in the compile. In the
> > > install, I had to re-init due to the incompatibility of pg_control.
> > >
> > > All the regression tests went smoothly (the one "failure" was in geometry
> > > and is due to round off in the least sig figs of the doubles in the Point
> > > structure or machine zero differences).
> > >
> > > I compared a simple query on local data in both 32bit mode and 64bit mode;
> > > the execute time difference was not significant but this was not a compute
> > > intensive verification (summing up column values in a table). We have
> > > some other 32-bit amd machines here; I would be happy to try a few other
> > > tests.
> > >
> > > Good job, developers!!!
> > >
> > > On Mon, 07 Apr 2003 18:34:05 +0800
> > > Justin Clift <justin(at)postgresql(dot)org> wrote:
> > >
> > > > Hi guys,
> > > >
> > > > Does anyone want remote access to the upcoming AMD 64 bit architecture,
> > > > to make sure PostgreSQL runs well on it?
> > > >
> > > > It's only via remote access at present, but the AMD guys are willing to
> > > > help us out here.
> > > >
> > > > Regards and best wishes,
> > > >
> > > > Justin Clift
> > > >
> > > >
> > > > -------- Original Message --------
> > > > Subject: RE: Postgresql AMD x86-64
> > > > Date: Fri, 4 Apr 2003 10:29:24 -0800
> > > > From: marc(dot)miller(at)amd(dot)com
> > > > To: justin(at)postgresql(dot)org
> > > > CC: aj(at)suse(dot)de, chris(dot)rimer(at)amd(dot)com
> > > >
> > > > Justin,
> > > >
> > > > I apologize for the delayed response. Unfortunately, at the moment I
> > > > don't have a system available to send you. If I could get you access to
> > > > a machine remotely, would that be useful to you? I will need to check
> > > > machine availability before I can promise you anything, but I'm willing
> > > > to be your sponsor in the AMD Developer Center and approve a request for
> > > > access.
> > > >
> > > > -----Original Message-----
> > > > From: Justin Clift [mailto:justin(at)postgresql(dot)org]
> > > > Sent: Monday, March 10, 2003 7:31 PM
> > > > To: Andreas Jaeger
> > > > Subject: Re: AMD x86-64
> > > >
> > > >
> > > > Hi Andreas,
> > > >
> > > > Have you heard anything back from the AMD guys in relation to this?
> > > >
> > > > We've not heard a single thing from them.
> > > >
> > > > :-(
> > > >
> > > > Regards and best wishes,
> > > >
> > > > Justin Clift
> > > >
> > > >
> > > > Andreas Jaeger wrote:
> > > > > Justin Clift <justin(at)postgresql(dot)org> writes:
> > > > <snip>
> > > > >>Yep, the aim is to allow PostgreSQL developers access to a system
> > > > >>running x86-64 hardware as needed.
> > > > >>
> > > > >>Trying to get ahead of the ballgame these days. :)
> > > > >>
> > > > >>>If you have hammer Hardware, I can provide you with a prerelease of
> > > > >>>our software,
> > > > >>
> > > > >>That would be cool Andreas, thanks.
> > > > >>
> > > > >>Now, just need to secure the hardware somehow. Personally, I feel
> > > > >>that an email forwarded from you to the right people at AMD may help
> > > > >>that significantly. At least, people from AMD should get in contact
> > > > >>with us to see if something beneficial can be arranged.
> > > > >
> > > > > Ok, I forwarded your note and let's see whether they're interested
> > > > > (there're already a few commercial database like IBM DB2 ported).
> > > > > From past experience, it might be difficult to get hardware directly
> > > > > but let's wait for their answer.
> > > > >
> > > > > If you don't hear anything this week, feel free to ask me again,
> > > > >
> > > > > Andreas
> > > >
> > > >
> > > > --
> > > > "My grandfather once told me that there are two kinds of people: those
> > > > who work and those who take the credit. He told me to try to be in the
> > > > first group; there was less competition there."
> > > > - Indira Gandhi
> > > >
> > > >
> > > > ---------------------------(end of broadcast)---------------------------
> > > > TIP 4: Don't 'kill -9' the postmaster
> > > >
> > >
> > >
> > > --
> > > Martin Weinberg Phone: (413) 545-3821
> > > Dept. of Astronomy FAX: (413) 545-4223
> > > 530 Graduate Research Tower weinberg(at)astro(dot)umass(dot)edu
> > > University of Massachusetts http://www.astro.umass.edu/~weinberg/
> > > Amherst, MA 01003-4525
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 6: Have you searched our list archives?
> > >
> > > http://archives.postgresql.org
> > >
> >
> > --
> > Bruce Momjian | http://candle.pha.pa.us
> > pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
> > + If your life is a hard drive, | 13 Roberts Road
> > + Christ can be your backup. | Newtown Square, Pennsylvania 19073
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> > (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
> >
>
>
> --
> Martin Weinberg Phone: (413) 545-3821
> Dept. of Astronomy FAX: (413) 545-4223
> 530 Graduate Research Tower weinberg(at)astro(dot)umass(dot)edu
> University of Massachusetts http://www.astro.umass.edu/~weinberg/
> Amherst, MA 01003-4525
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

The following patch automatically enables 64-bit mode on AMD opteron.
We already had spinlock support for it, but I added some comments.

The big question is whether all the operating systems running gcc on
Opteron support the 64-bit flags, and if we want to enable them by
default on Opteron.

If either of these is false, I will need to add a configure flag to
control 64-bit Opteron mode, though we could probably automatically
detect if gcc understand the 64-bit flags. Another question is whether
any OS reports ia64 without having gcc understand -m64. I am sure there
are lots of non-ia64-aware OS's running on Opteron, but do any of those
report ia64 as their CPU?

This might be one of those patches that we apply and see what reports we
get during beta.

---------------------------------------------------------------------------

Martin D. Weinberg wrote:
> Bruce,
>
> I didn't change the source tree at all. I used:
>
> env CFLAGS='-O3 -m64' LD='/usr/bin/ld -melf_x86_64' ./configure --with-CXX --without-zlib
>
> with the experimental gcc and bintils from www.x86-64.org. I needed
> --without-zlib because I don't have a 64 bit compile yet for zlib.
>
> make
> make install-all-headers
> make check CC='gcc -m64'
>
> The last one is needed to make sure that the shared library gets made
> in the amd64 architecture.
>
> That's it!
>
>
> On Tue, 10 Jun 2003 14:14:22 -0400 (EDT)
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> wrote:
>
> >
> > Can you send us a patch?
> >
> > ---------------------------------------------------------------------------
> >
> > Martin D. Weinberg wrote:
> > > Hi folks,
> > >
> > > We recently built a dual K8D-based Opteron box running Linux in 64-bit
> > > mode (Debian 'testing' distribution with newly compiled binutils, gcc,
> > > and various support libraries for amd64 architecture).
> > >
> > > The Postgres 7.3.3 "port" was simply a matter of setting the appropriate
> > > flags to take of the biarchectecture nature of the Linux port. (that is,
> > > "-m64" to generate 64 bit code and either "gcc -m64" or "ld -melf_x86_64"
> > > for linking"). There were no other issues in the compile. In the
> > > install, I had to re-init due to the incompatibility of pg_control.
> > >
> > > All the regression tests went smoothly (the one "failure" was in geometry
> > > and is due to round off in the least sig figs of the doubles in the Point
> > > structure or machine zero differences).
> > >
> > > I compared a simple query on local data in both 32bit mode and 64bit mode;
> > > the execute time difference was not significant but this was not a compute
> > > intensive verification (summing up column values in a table). We have
> > > some other 32-bit amd machines here; I would be happy to try a few other
> > > tests.
> > >
> > > Good job, developers!!!
> > >
> > > On Mon, 07 Apr 2003 18:34:05 +0800
> > > Justin Clift <justin(at)postgresql(dot)org> wrote:
> > >
> > > > Hi guys,
> > > >
> > > > Does anyone want remote access to the upcoming AMD 64 bit architecture,
> > > > to make sure PostgreSQL runs well on it?
> > > >
> > > > It's only via remote access at present, but the AMD guys are willing to
> > > > help us out here.
> > > >
> > > > Regards and best wishes,
> > > >
> > > > Justin Clift
> > > >
> > > >
> > > > -------- Original Message --------
> > > > Subject: RE: Postgresql AMD x86-64
> > > > Date: Fri, 4 Apr 2003 10:29:24 -0800
> > > > From: marc(dot)miller(at)amd(dot)com
> > > > To: justin(at)postgresql(dot)org
> > > > CC: aj(at)suse(dot)de, chris(dot)rimer(at)amd(dot)com
> > > >
> > > > Justin,
> > > >
> > > > I apologize for the delayed response. Unfortunately, at the moment I
> > > > don't have a system available to send you. If I could get you access to
> > > > a machine remotely, would that be useful to you? I will need to check
> > > > machine availability before I can promise you anything, but I'm willing
> > > > to be your sponsor in the AMD Developer Center and approve a request for
> > > > access.
> > > >
> > > > -----Original Message-----
> > > > From: Justin Clift [mailto:justin(at)postgresql(dot)org]
> > > > Sent: Monday, March 10, 2003 7:31 PM
> > > > To: Andreas Jaeger
> > > > Subject: Re: AMD x86-64
> > > >
> > > >
> > > > Hi Andreas,
> > > >
> > > > Have you heard anything back from the AMD guys in relation to this?
> > > >
> > > > We've not heard a single thing from them.
> > > >
> > > > :-(
> > > >
> > > > Regards and best wishes,
> > > >
> > > > Justin Clift
> > > >
> > > >
> > > > Andreas Jaeger wrote:
> > > > > Justin Clift <justin(at)postgresql(dot)org> writes:
> > > > <snip>
> > > > >>Yep, the aim is to allow PostgreSQL developers access to a system
> > > > >>running x86-64 hardware as needed.
> > > > >>
> > > > >>Trying to get ahead of the ballgame these days. :)
> > > > >>
> > > > >>>If you have hammer Hardware, I can provide you with a prerelease of
> > > > >>>our software,
> > > > >>
> > > > >>That would be cool Andreas, thanks.
> > > > >>
> > > > >>Now, just need to secure the hardware somehow. Personally, I feel
> > > > >>that an email forwarded from you to the right people at AMD may help
> > > > >>that significantly. At least, people from AMD should get in contact
> > > > >>with us to see if something beneficial can be arranged.
> > > > >
> > > > > Ok, I forwarded your note and let's see whether they're interested
> > > > > (there're already a few commercial database like IBM DB2 ported).
> > > > > From past experience, it might be difficult to get hardware directly
> > > > > but let's wait for their answer.
> > > > >
> > > > > If you don't hear anything this week, feel free to ask me again,
> > > > >
> > > > > Andreas
> > > >
> > > >
> > > > --
> > > > "My grandfather once told me that there are two kinds of people: those
> > > > who work and those who take the credit. He told me to try to be in the
> > > > first group; there was less competition there."
> > > > - Indira Gandhi
> > > >
> > > >
> > > > ---------------------------(end of broadcast)---------------------------
> > > > TIP 4: Don't 'kill -9' the postmaster
> > > >
> > >
> > >
> > > --
> > > Martin Weinberg Phone: (413) 545-3821
> > > Dept. of Astronomy FAX: (413) 545-4223
> > > 530 Graduate Research Tower weinberg(at)astro(dot)umass(dot)edu
> > > University of Massachusetts http://www.astro.umass.edu/~weinberg/
> > > Amherst, MA 01003-4525
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 6: Have you searched our list archives?
> > >
> > > http://archives.postgresql.org
> > >
> >
> > --
> > Bruce Momjian | http://candle.pha.pa.us
> > pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
> > + If your life is a hard drive, | 13 Roberts Road
> > + Christ can be your backup. | Newtown Square, Pennsylvania 19073
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> > (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
> >
>
>
> --
> Martin Weinberg Phone: (413) 545-3821
> Dept. of Astronomy FAX: (413) 545-4223
> 530 Graduate Research Tower weinberg(at)astro(dot)umass(dot)edu
> University of Massachusetts http://www.astro.umass.edu/~weinberg/
> Amherst, MA 01003-4525
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

Bruce Momjian wrote:

> if test "$enable_debug" = yes && test "$ac_cv_prog_cc_g" = yes; then
> CFLAGS="$CFLAGS -g"
> fi
>+
>+ /* Compile AMD Opteron using gcc in 64-bit mode */
>+ if test "$GCC" = yes; then
>+ case $host in
>+ ia64-*) CFLAGS="$CFLAGS -m64"
>+ LDFLAGS="$LDFLAGS -melf_x86_64";;
>+ esac
>+ fi
>+
>
Sorry, I think I confused you:
ia64-* is Intel's Itanium system. They are 64-bit only cpus (the 32-bit
emulation is too slow to be usable). It's supported by multiple
operating systems, among them HP UX, Linux, Windows. As far as I can see
it's supported directly, by 7.3.3, at least RedHat builds their ia64
version without any patches.
x86_64 is AMD's Operon/Athlon 64 system. They support concurrent 32-bit
and 64-bit. Right now only supported by Linux, BSD and Windows support
expected soon.
Thus the test must be for "x86_64-*".

Martin: you are using debian-testing, correct? I've asked a Suse
developer, and on their Linux distribution, -m64 is the default, i.e.
you don't need any switches.

--
Manfred

Manfred Spraul wrote:
> Bruce Momjian wrote:
>
> > if test "$enable_debug" = yes && test "$ac_cv_prog_cc_g" = yes; then
> > CFLAGS="$CFLAGS -g"
> > fi
> >+
> >+ /* Compile AMD Opteron using gcc in 64-bit mode */
> >+ if test "$GCC" = yes; then
> >+ case $host in
> >+ ia64-*) CFLAGS="$CFLAGS -m64"
> >+ LDFLAGS="$LDFLAGS -melf_x86_64";;
> >+ esac
> >+ fi
> >+
> >
> Sorry, I think I confused you:

I am easily confused. It certainly makes more sense fir ia64 to be
Intel, not AMD. :-)

> ia64-* is Intel's Itanium system. They are 64-bit only cpus (the 32-bit
> emulation is too slow to be usable). It's supported by multiple
> operating systems, among them HP UX, Linux, Windows. As far as I can see
> it's supported directly, by 7.3.3, at least RedHat builds their ia64
> version without any patches.
> x86_64 is AMD's Operon/Athlon 64 system. They support concurrent 32-bit
> and 64-bit. Right now only supported by Linux, BSD and Windows support
> expected soon.
> Thus the test must be for "x86_64-*".
>
> Martin: you are using debian-testing, correct? I've asked a Suse
> developer, and on their Linux distribution, -m64 is the default, i.e.
> you don't need any switches.

I have applied the following patch to document the cpus supported by
each define.

Martin mentioned that he has applied a special 64-bit kit to do the
compile, so perhaps he needs it, but most will not. I will keep the
patch around and see if others need it during beta.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

Bruce Momjian writes:

> The following patch automatically enables 64-bit mode on AMD opteron.
> We already had spinlock support for it, but I added some comments.

This sort of thing belongs into the template file, not directly in
configure.in.

--
Peter Eisentraut peter_e(at)gmx(dot)net

Peter Eisentraut wrote:
> Bruce Momjian writes:
>
> > The following patch automatically enables 64-bit mode on AMD opteron.
> > We already had spinlock support for it, but I added some comments.
>
> This sort of thing belongs into the template file, not directly in
> configure.in.

I knew you were going to say that, but which template file? It is a
product of the cpu/compiler, not a specific OS.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073