On 21 Aug 2006, at 10:48, [EMAIL PROTECTED] wrote:
On Mon, Aug 21, 2006 at 12:00:58PM +0300, Alexander Kirpa wrote:
WRT 64-bit and Postgres, it depends on the CPU as to whether you
see a simple performance benefit. On the Opteron you will see a
benefit when doing CPU bound work. When
On Mon, Aug 21, 2006 at 02:56:10PM +1200, Andrej Ricnik-Bay wrote:
On 8/21/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Is there an interest, or any active project to examine PostgreSQL in
the area of 64-bit processors? Has it already been done? I don't recall
seeing a reference to it in my
On Sun, Aug 20, 2006 at 11:00:26PM -0400, Douglas McNaught wrote:
[EMAIL PROTECTED] writes:
Is there an interest, or any active project to examine PostgreSQL in
the area of 64-bit processors? Has it already been done? I don't recall
seeing a reference to it in my travels. I'm also not sure
[EMAIL PROTECTED] wrote:
This is what I mean by after thought. PostgreSQL is designed for
32-bit processors. Which is fine. I'm not complaining. The question
was whether there is an interest in pursuing 64-bit specific
optimizations. In the PostgreSQL code, a quick check points me only to
has
On Mon, Aug 21, 2006 at 09:16:46AM -0400, [EMAIL PROTECTED] wrote:
This is what I mean by after thought. PostgreSQL is designed for
32-bit processors. Which is fine. I'm not complaining. The question
was whether there is an interest in pursuing 64-bit specific
optimizations. In the PostgreSQL
Martijn van Oosterhout kleptog@svana.org writes:
Can you think of any places at all where 64-bit would make a difference
to processing? 64-bit gives you more memory, and on some x86 chips, more
registers, but that's it.
It would be interesting to look into making int8 and float8 be
[EMAIL PROTECTED] writes:
I believe the answer is no. No or few 64-bit optimization possibilities
have been chased down, probably because some or many of these would:
1) require significant re-architecture
2) reduce the performance in a 32-bit world
Honestly, I think the main
WRT 64-bit and Postgres, it depends on the CPU as to whether you
see a simple performance benefit. On the Opteron you will see a
benefit when doing CPU bound work. When doing the CPU portion, the
additional registers of the Opteron running in 64-bit mode are used
by the compiler to produce
On Mon, Aug 21, 2006 at 10:23:16AM -0400, Douglas McNaught wrote:
[EMAIL PROTECTED] writes:
I believe the answer is no. No or few 64-bit optimization possibilities
have been chased down, probably because some or many of these would:
1) require significant re-architecture
2) reduce
On Mon, Aug 21, 2006 at 12:00:58PM +0300, Alexander Kirpa wrote:
WRT 64-bit and Postgres, it depends on the CPU as to whether you
see a simple performance benefit. On the Opteron you will see a
benefit when doing CPU bound work. When doing the CPU portion, the
additional registers of the
On Mon, Aug 21, 2006 at 10:46:56AM -0400, [EMAIL PROTECTED] wrote:
Compilers are getting smarter, but having code profiled, and hand tuned
for 32-bits does not automatically get compiled with a 64-bit compiler,
to code that has been profile, and hand tuned for 64-bit.
I don't see any evidence
On Mon, Aug 21, 2006 at 05:13:58PM +0200, Martijn van Oosterhout wrote:
On the whole, PostgreSQL is still in the phase where we're trying to
find the best algorithms. When that's done (if ever), we can start
worrying about processor optimisations...
I don't disagree. :-)
You claimed that
[EMAIL PROTECTED] writes:
What re-architecting would be needed?
I'm asking that it be admitted that it has not been looked at. Not
seriously. Nor is this unique to PostgreSQL. I expect the performance
for Linux applications in general to slowly improve on 64-bit
processors as more and more
On Mon, Aug 21, 2006 at 01:05:13PM -0400, Tom Lane wrote:
[EMAIL PROTECTED] writes:
What re-architecting would be needed?
I'm asking that it be admitted that it has not been looked at. Not
seriously. Nor is this unique to PostgreSQL. I expect the performance
for Linux applications in
[EMAIL PROTECTED] writes:
On Mon, Aug 21, 2006 at 01:05:13PM -0400, Tom Lane wrote:
What you seem to be asking for is that we engage in a lot of
machine-specific tuning for some particular processor or other.
The question was whether PostgreSQL was optimized for 64-bit Linux.
The answer is
I have a PostgreSQL installation on a Debian box that had the 64bit SMP
kernel installed before PostgreSQL was compiled and installed on it.
Does PostgreSQL take any advantage of the 64 bit environment or have we
not done anything to move into the 64 bit world yet?
Regards,
- Naz
Naz Gassiep [EMAIL PROTECTED] writes:
I have a PostgreSQL installation on a Debian box that had the 64bit
SMP kernel installed before PostgreSQL was compiled and installed on
it. Does PostgreSQL take any advantage of the 64 bit environment or
have we not done anything to move into the 64 bit
Douglas McNaught wrote:
Naz Gassiep [EMAIL PROTECTED] writes:
I have a PostgreSQL installation on a Debian box that had the 64bit
SMP kernel installed before PostgreSQL was compiled and installed on
it. Does PostgreSQL take any advantage of the 64 bit environment or
have we not
Naz Gassiep [EMAIL PROTECTED] writes:
I just compiled as the manual says. I guess I must have compiled it
in 32. I'll recompile in 64 when I upgrade to 8.2 when it's out.
The 'file' command will tell you whether a binary is 32- or 64-bit.
If you have a full 64-bit install, you'll get a 64-bit
On Sun, Aug 20, 2006 at 04:46:30PM -0400, Douglas McNaught wrote:
Naz Gassiep [EMAIL PROTECTED] writes:
I have a PostgreSQL installation on a Debian box that had the 64bit
SMP kernel installed before PostgreSQL was compiled and installed on
it. Does PostgreSQL take any advantage of the 64
On 8/21/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Is there an interest, or any active project to examine PostgreSQL in
the area of 64-bit processors? Has it already been done? I don't recall
seeing a reference to it in my travels. I'm also not sure on what to
expect for results, as the
[EMAIL PROTECTED] writes:
Is there an interest, or any active project to examine PostgreSQL in
the area of 64-bit processors? Has it already been done? I don't recall
seeing a reference to it in my travels. I'm also not sure on what to
expect for results, as the territory is still new. 64-bit
Naz,
On 8/20/06 12:59 PM, Naz Gassiep [EMAIL PROTECTED] wrote:
I have a PostgreSQL installation on a Debian box that had the 64bit SMP
kernel installed before PostgreSQL was compiled and installed on it.
Does PostgreSQL take any advantage of the 64 bit environment or have we
not done
WRT 64-bit and Postgres, it depends on the CPU as to whether you see a
simple performance benefit. On the Opteron you will see a benefit when
doing CPU bound work. When doing the CPU portion, the additional registers
of the Opteron running in 64-bit mode are used by the compiler to produce a
Josh,
On 8/20/06 8:52 PM, Joshua D. Drake [EMAIL PROTECTED] wrote:
Is that true of even Woodcrest?
Joshua D. Drake
Not sure - haven't read anything about the register set on the Core 2 to
make me think it benefits from 64 bit.
The point may be academic from now on though - the comparisons
25 matches
Mail list logo