Skip site navigation (1) Skip section navigation (2)

Re: Performance Tuning Article

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 (view raw or flat)
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
>


In response to

Responses

pgsql-performance by date

Next:From: Elliott BennettDate: 2005-06-23 17:09:07
Subject: Re: select distinct on varchar - wild performance differences!
Previous:From: Tom LaneDate: 2005-06-23 15:34:55
Subject: Re: select distinct on varchar - wild performance differences!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group