Re: [HACKERS] postgresql scalability issue

2010-11-08 Thread Tom Lane
umut orhan writes: > When I pin a single query to an individual core, its execution time is > observed > as 111 seconds. This result is my base case. Then, I fire two instances of > the > same query concurrently and pin them to two different cores separately. > However, > each execution time

[HACKERS] postgresql scalability issue

2010-11-08 Thread umut orhan
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,