Hi all,
We are working on a patch which targets the overhead of spinlock in buffer
cache.In this regard, we need to exercise buffer spinlock contention on a 16
core machine.
Could anyone please suggest some good methods for exercising the same?
Regards,
Atri
Sent from my iPad
--
Sent via p
On 13-04-13 04:54 PM, Jeff Janes wrote:
On Sat, Apr 13, 2013 at 9:14 AM, Steve Singer mailto:ssin...@ca.afilias.info>> wrote:
indexTotalCost += index->pages * spc_random_page_cost / 10.0;
Is driving my high costs on the inner loop. The index has 2-5
million pages depending on t
On Sun, Apr 14, 2013 at 7:34 PM, Jeff Janes wrote:
> On Saturday, April 13, 2013, Rodrigo Barboza wrote:
>
>>
>>
>>
>> On Sat, Apr 13, 2013 at 4:51 PM, Jeff Janes wrote:
>>
>>> On Sat, Apr 13, 2013 at 10:29 AM, Rodrigo Barboza <
>>> rodrigombu...@gmail.com> wrote:
>>>
I was receiv
On Saturday, April 13, 2013, Rodrigo Barboza wrote:
>
>
>
> On Sat, Apr 13, 2013 at 4:51 PM, Jeff Janes
>
> > wrote:
>
>> On Sat, Apr 13, 2013 at 10:29 AM, Rodrigo Barboza <
>> rodrigombu...@gmail.com > 'rodrigombu...@gmail.com');>> wrote:
>>
>>>
>>>
>>> I was receiving warning messages of pgsta
On Sat, 13 Apr 2013 20:08:16 +0200
Rikard Pavelic wrote:
> While one could argue that optimizer doesn't know to optimize left
> join with group by its primary key, you can replace that join with
> some other joins (ie left join to another table pk) and the same
> behavior will be displayed (joini
