Postgres Pro
Downloads
Home   >   mailing lists

Re: Low Budget Performance, Part 2 - Mailing list pgsql-performance

From Tom Lane
Subject Re: Low Budget Performance, Part 2
Date
Msg-id 21018.1038424762@sss.pgh.pa.us
Whole thread Raw
In response to Low Budget Performance, Part 2  (eric soroos <eric-psql@soroos.net>)
Responses Re: Low Budget Performance, Part 2
List pgsql-performance
Tree view 
eric soroos <eric-psql@soroos.net> writes:
> Running pgbench with: scaling factor=1, # transactions = 100, and
> #clients =1,2,3,5,10,15

The scaling factor has to at least equal the max # of clients you intend
to test, else pgbench will spend most of its time fighting update
contention (parallel transactions wanting to update the same row).

            regards, tom lane

pgsql-performance by date:

Previous
From: eric soroos
Date:
Subject: Low Budget Performance, Part 2
Next
From: eric soroos
Date:
Subject: Re: Low Budget Performance, Part 2