Deterioration in performance when query executed in multi threads

From: Anne Rosset <arosset(at)collab(dot)net>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Deterioration in performance when query executed in multi threads
Date: 2013-05-01 14:05:06
Message-ID: 9A6B86D66BD3C2438AFACFA09354890F20A2DF6D@EXCH01.sp.corp.collab.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi all,
We are running a stress test that executes one select query with multiple threads.
The query executes very fast (10ms). It returns 100 rows. I see deterioration in the performance when we have multiple threads executing the query. With 100 threads, the query takes between 3s and 8s.

I suppose there is a way to tune our database. What are the parameters I should look into? (shared_buffer?, wal_buffer?)

Thanks for your help,
Anne

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2013-05-01 14:06:55 Re: In progress INSERT wrecks plans on table
Previous Message stefan 2013-05-01 12:48:07 BUG #8130: Hashjoin still gives issues