Postgres Pro
Downloads
Home   >   mailing lists

Re: Cache Hash Index meta page. - Mailing list pgsql-hackers

From Mithun Cy
Subject Re: Cache Hash Index meta page.
Date
Msg-id CAD__OujqR4zmss5-jGgXSQh6_gQ+j7bUJxJHmO5nGmDtJCPSEA@mail.gmail.com
Whole thread Raw
In response to Re: Cache Hash Index meta page.  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-hackers
Tree view
On Tue, Oct 4, 2016 at 11:55 PM, Jeff Janes <jeff.janes@gmail.com> wrote:
>Can you describe your benchmarking machine?  Your benchmarking data went up to 128 clients.  But how many cores does the machine have?  Are
>you testing how well it can use the resources it has, or how well it can deal with oversubscription of the resources?

It is a power2 machine with 192 hyperthreads.

Architecture:          ppc64le
Byte Order:            Little Endian
CPU(s):                192
On-line CPU(s) list:   0-191
Thread(s) per core:    8
Core(s) per socket:    1
Socket(s):             24
NUMA node(s):          4
Model:                 IBM,8286-42A
L1d cache:             64K
L1i cache:             32K
L2 cache:              512K
L3 cache:              8192K
NUMA node0 CPU(s):     0-47
NUMA node1 CPU(s):     48-95
NUMA node2 CPU(s):     96-143
NUMA node3 CPU(s):     144-191
 
 >Also, was the file supposed to be named .ods?  I didn't find it to be openable as an .odc file.

Yes .ods right it is a spreadsheet in ODF.

--
Thanks and Regards
Mithun C Y

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: improving on pgrminclude / pgcompinclude ?
Next
From: Robert Haas
Date:
Subject: Re: improving on pgrminclude / pgcompinclude ?