Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
Parallel UPDATE Performance: dev-db/postgresql-server-9.0.5
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Portage & Programming
View previous topic :: View next topic  
Author Message
docyes
n00b
n00b


Joined: 14 Nov 2011
Posts: 1

PostPosted: Mon Nov 14, 2011 1:48 am    Post subject: Parallel UPDATE Performance: dev-db/postgresql-server-9.0.5 Reply with quote

This is more of a postgresql tuning related problem but I suspect it relates to the stock config for postgresql.

If I perform 1-9 parallel UPDATEs to a table the average time per query is ~10 ms (fast).

If I perform >9 the average time per query is ~20,000ms (slow).

Any seasoned gentoo postgresql tuning experts with any hints?
Back to top
View user's profile Send private message
titanofold
Developer
Developer


Joined: 30 Dec 2003
Posts: 226
Location: Bryson City, NC USA

PostPosted: Wed Nov 16, 2011 4:39 am    Post subject: Reply with quote

Seems like a buffers issue.

How many connections? What's the UPDATE statement? Are you using a prepared query for the UPDATE statement?

Have you tweaked any of the postgresql.conf settings found in: http://www.postgresql.org/docs/current/static/runtime-config-resource.html
_________________
The best things in life are free.
Guy-1: Surely, you will fold with me...
Guy-2: Alright, but don't call me Shirley
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Portage & Programming All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum