Re: Performance Tuning Article - Mailing list pgsql-performance

From Dave Cramer
Subject Re: Performance Tuning Article
Date
Msg-id EFDE64A7-ABAD-4579-9837-4D1E9107BC54@fastcrypt.com
Whole thread Raw
In response to Re: Performance Tuning Article  (Radu-Adrian Popescu <radu.popescu@aldratech.com>)
Responses Re: Performance Tuning Article  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
AFAIK, the problem was the buffer manager

Dave
On 23-Jun-05, at 9:46 AM, Radu-Adrian Popescu wrote:

> Dave Cramer wrote:
>
>> My understanding is that it isn't particularly XEON processors
>> that  is the problem
>> Any dual processor will exhibit the problem, XEON's with
>> hyperthreading exacerbate the problem though
>> and the good news is that it has been fixed in 8.1
>>
>
> Where's that ? The only information I have is a message from Tom
> Lane saying the buffer manager (or something like that) locking has
> been redone for 8.0. Any pointers ?
>
>
>> Dave
>>
>
> Thanks,
> --
> Radu-Adrian Popescu
> CSA, DBA, Developer
> Aldrapay MD
> Aldratech Ltd.
> +40213212243
>


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: select distinct on varchar - wild performance differences!
Next
From: Elliott Bennett
Date:
Subject: Re: select distinct on varchar - wild performance differences!