Re: Performance problems on 4-way AMD Opteron 875 (dual core)

From: Michael Stone
Subject: Re: Performance problems on 4-way AMD Opteron 875 (dual core)
Date: ,
Msg-id: 20050805122719.GW19080@mathom.us
(view: Whole thread, Raw)
In response to: Performance problems on 4-way AMD Opteron 875 (dual core)  (Dirk Lutzebäck)
Responses: Re: Performance problems on 4-way AMD Opteron 875 (dual  (Dirk Lutzebäck)
List: pgsql-performance

Tree view

Performance problems on 4-way AMD Opteron 875 (dual core)  (Dirk Lutzebäck, )
 Re: Performance problems on 4-way AMD Opteron 875 (dual core)  (Michael Stone, )
  Re: Performance problems on 4-way AMD Opteron 875 (dual  (Dirk Lutzebäck, )
 Re: Performance problems on 4-way AMD Opteron 875 (dual core)  (Tom Lane, )

On Fri, Aug 05, 2005 at 01:11:31PM +0200, Dirk Lutzebäck wrote:
>I will compile the latest PostgreSQL 8.1 snapshot for 32bit to evaluate
>the new shared buffer code from Tom.
>I think, the 64bit is slow because my queries are CPU intensive.

Have you actually tried it or are you guessing? If you're guessing, then
compile it as a 64 bit binary and benchmark that.

Mike Stone


pgsql-performance by date:

From: Tom Lane
Date:
Subject: Re: Performance problems on 4-way AMD Opteron 875 (dual core)
From: Rhett Garber
Date:
Subject: Why hash join instead of nested loop?