Re: Configuration Recommendations

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Jan Nielsen <jan(dot)sture(dot)nielsen(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Configuration Recommendations
Date: 2012-05-04 16:30:57
Message-ID: CAMkU=1wqc5S5Hf=7XAtUzU_5EOvUy-G_TW3e_tyS8NuyDpzr6Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, May 4, 2012 at 8:07 AM, Jan Nielsen <jan(dot)sture(dot)nielsen(at)gmail(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2012-05-04 16:39:02 Re: Partitioned/inherited tables with check constraints causing slower query plans
Previous Message Kevin Grittner 2012-05-04 15:33:56 Re: Configuration Recommendations