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 wor
[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 answe
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 applicat
[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 m
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 Po
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 evidenc
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
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
> 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 prod
[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
Martijn van Oosterhout 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
pass-by-value datatypes to
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 PostgreS
[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 lo
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
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 i
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 compar
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
2
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
[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-
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 te
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
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-
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 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
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
-
25 matches
Mail list logo
