View previous topic :: View next topic |
Author |
Message |
docyes n00b
Joined: 14 Nov 2011 Posts: 1
|
Posted: Mon Nov 14, 2011 1:48 am Post subject: Parallel UPDATE Performance: dev-db/postgresql-server-9.0.5 |
|
|
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 |
|
|
titanofold Developer
Joined: 30 Dec 2003 Posts: 235 Location: Bryson City, NC USA
|
|
Back to top |
|
|
|