Re: Sorting Improvements for 8.4

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Sorting Improvements for 8.4
Date: 2007-12-20 14:41:13
Message-ID: Pine.GSO.4.64.0712200934390.17085@westnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, 20 Dec 2007, Martijn van Oosterhout wrote:

> The way around this is a NUMA architecture, but that's a whole
> other ball of wax.

Quick note for those reading Ulrich's paper: he refers in a couple of
places to Intel's upcoming CSI approach to NUMA. This has now been
renamed QuickPath, and it looks like it will be late 2008 before that even
makes it to Itanium processors.

The fact that AMD has a good NUMA implementation in their Opteron lines
while Intel's Xeon processors do not is one area AMD still has a clear
competative lead on. But you need memory bandwidth starved application
before that matters more than the fact that the current Xeons are faster
in general.

--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Brian Hurt 2007-12-20 14:42:09 Re: Sorting Improvements for 8.4
Previous Message NikhilS 2007-12-20 14:08:36 Re: duplicate columns with COPY