| From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
|---|---|
| To: | radu(dot)popescu(at)aldratech(dot)com |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Performance Tuning Article |
| Date: | 2005-06-23 16:16:57 |
| Message-ID: | EFDE64A7-ABAD-4579-9837-4D1E9107BC54@fastcrypt.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Elliott Bennett | 2005-06-23 17:09:07 | Re: select distinct on varchar - wild performance differences! |
| Previous Message | Tom Lane | 2005-06-23 15:34:55 | Re: select distinct on varchar - wild performance differences! |