Postgres Pro
Downloads
Home   >   mailing lists

Re: Configuration Recommendations - Mailing list pgsql-performance

From Jeff Janes
Subject Re: Configuration Recommendations
Date
Msg-id CAMkU=1wqc5S5Hf=7XAtUzU_5EOvUy-G_TW3e_tyS8NuyDpzr6Q@mail.gmail.com
Whole thread Raw
In response to Re: Configuration Recommendations  (Jan Nielsen <jan.sture.nielsen@gmail.com>)
List pgsql-performance
Tree view 
On Fri, May 4, 2012 at 8:07 AM, Jan Nielsen <jan.sture.nielsen@gmail.com> wrote:
> Starting to get some quantitative data now. Here is the results from the
> pgbench scaling:
>
>   pgbench -t 2000 -c 32 -S pgbench

A single thread of pgbench is probably not enough to saturate 32
sessions.  What if you try -j 16 or -j 32?

Also, -t 2000 is mighty low.

Cheers,

Jeff

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Configuration Recommendations
Next
From: Tom Lane
Date:
Subject: Re: Partitioned/inherited tables with check constraints causing slower query plans