Who is How Parallel?

Product

Version/HW

Cores per Node

UoP per Node

Notes

Teradata EDW 6700H

16

32

Uses hyper-threads.
Greenplum DCA UAP Edition

16

8

Recommends 1 Segment instance for each 2 cores.
Exadata X3

12

12-24

Maybe only 12… cannot find if they use hyper-threads.
Netezza Striper

16

16

May use hyper-threads but limited by 16 FPGAs.
HANA Any Xeon E7-4800

40

80

Uses hyper-threads.

A unit of parallelism (UoP) is defined as the maximum number of  instructions that can execute in parallel on a single node for a single query. Since any program can start threads that wait I do not count these as UoP. On some CPUs vendors such as Intel allow two threads to execute instructions in-parallel in a core. This is called hyper-threading and, if implemented, it allows for two UoP on a single core.

Please feel free to comment if there is an update you would like to see included.

Update Log

April 24, 2013: Original Post… I’ll try to keep this updated over time.

2 thoughts on “Who is How Parallel?

  1. Pingback: Who Out-performs Who: A Story… | Database Fog Blog

  2. Hi Rob

    Sorry…I did try, but I can’t find a definitive reference on the Hyperthreading for Exadata either, but I can say that it uses Xeon E5-2690 (X3-2) or E7-8870 (X3-8) CPUs, which do offer HT and that there are several references (google search) from respected people/organisations indicating they use it on their X3 systems. For what it’s worth, one of my clients uses a HP DL980 G7 with E7-2830 Xeons in it and has HT enabled on that so I can’t see why they wouldn’t enable it, if it was appropriate for the type of workload.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s