Re: Performance Tuning Article - Mailing list pgsql-performance

From Tom Lane
Subject Re: Performance Tuning Article
Date
Msg-id 6451.1119546924@sss.pgh.pa.us
Whole thread Raw
In response to Re: Performance Tuning Article  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-performance
Dave Cramer <pg@fastcrypt.com> writes:
> AFAIK, the problem was the buffer manager

The buffer manager was the place that seemed to be hit hardest by Xeon's
problems with spinlock contention.  I think we've partially fixed that
issue in 8.1, but as we continue to improve the system's performance,
it's likely to surface as a bottleneck again in other places.

            regards, tom lane

pgsql-performance by date:

Previous
From: Elliott Bennett
Date:
Subject: Re: select distinct on varchar - wild performance differences!
Next
From: Josh Berkus
Date:
Subject: Re: parameterized LIKE does not use index