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 ?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
