Re: [PERFORM] pgbench intriguing results: better tps figures for larger scale factor

2013-03-04 Thread Merlin Moncure
On Thu, Feb 28, 2013 at 11:20 AM, Pavan Deolasee pavan.deola...@gmail.com wrote: On Wed, Feb 27, 2013 at 3:15 AM, Costin Oproiu costin.opr...@gmail.com wrote: I took some time to figure out a reasonable tuning for my fresh 9.2.3 installation when I've noticed the following: [costin@fsr

Re: [PERFORM] pgbench intriguing results: better tps figures for larger scale factor

2013-03-04 Thread Greg Smith
On 2/26/13 4:45 PM, Costin Oproiu wrote: First, I've got no good explanation for this and it would be nice to have one. As far as I can understand this issue, the heaviest update traffic should be on the branches table and should affect all tests. From

Re: [PERFORM] pgbench intriguing results: better tps figures for larger scale factor

2013-02-28 Thread Pavan Deolasee
On Wed, Feb 27, 2013 at 3:15 AM, Costin Oproiu costin.opr...@gmail.com wrote: I took some time to figure out a reasonable tuning for my fresh 9.2.3 installation when I've noticed the following: [costin@fsr costin]$ /home/pgsql/bin/pgbench -h 192.1.1.2 -p 5432 -U postgres -i -s 1 ... 10