On 11/08/10 7:33 AM, umut orhan wrote:
> Hi all,
>
> I've collected some interesting results during my experiments which I
> couldn't figure out the reason behind them and need your assistance.
>
> I'm running PostgreSQL 9.0 on a quad-core machine having two level
> on-chip cache hierarchy. PostgreSQL has a large and warmed-up buffer
> cache thus, no disk I/O is observed during experiments (i.e. for each
> query buffer cache hit rate is 100%). I'm pinning each query/process
> to an individual core. Queries are simple read-only queries (only
> selects). Nested loop (without materialize) is used for the join operator.
> ....
did pinning the processes to CPU cores make any measurable difference ?