Re: Scaling PostgreSQL at multicore Power8 - Mailing list pgsql-hackers

From Tomas Vondra
Subject Re: Scaling PostgreSQL at multicore Power8
Date
Msg-id 55E478A9.30809@2ndquadrant.com
Whole thread Raw
In response to Re: Scaling PostgreSQL at multicore Power8  (Andres Freund <andres@anarazel.de>)
Responses Re: Scaling PostgreSQL at multicore Power8  (Andres Freund <andres@anarazel.de>)
Re: Scaling PostgreSQL at multicore Power8  (YUriy Zhuravlev <u.zhuravlev@postgrespro.ru>)
List pgsql-hackers

On 08/31/2015 05:48 PM, Andres Freund wrote:
> On 2015-08-31 17:43:08 +0200, Tomas Vondra wrote:
>> Well, I could test the patch on a x86 machine with 4 sockets (64 cores), but
>> I wonder whether it makes sense at this point, as the patch really is not
>> correct (judging by what Andres says).
>
> Additionally it's, for default pgbench, really mostly a bottlneck after
> GetSnapshotData() is fixed. You can make it a problem much earlier if
> you have index nested loops over a lot of rows.

[scratches head] So does this mean it's worth testing the patch on x86 
or not, in it's current state? Or should we come up with another test 
case, exercising the nested loops?

regards

--
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Scaling PostgreSQL at multicore Power8
Next
From: Andres Freund
Date:
Subject: Re: Scaling PostgreSQL at multicore Power8