Re: pgbench help

From: Georges Racinet <gracinet(at)anybox(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pgbench help
Date: 2012-12-24 11:45:50
Message-ID: 50D8406E.3070702@anybox.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 12/24/2012 12:32 PM, John R Pierce wrote:
> On 12/24/2012 2:43 AM, Georges Racinet wrote:
>> Make sure both servers aren't running at the same time
>
> why? its perfectly OK to ahve severla postgres servers running at
> once, as long as they are on different port numbers. I generally use
> 5432, 5433, 5434, etc for this. mostly for development, or for
> migration, not so much on a production system where performance is
> important.
>
>
You're perfectly right. I'm used to have several clusters on the same
host (application testing in my case).
In this benchmark context, though, I just was being wary that they may
interfere, For instance, I suppose that an autovacuum wakeup in one
should lower performance results of the other.

Sorry it that sounded more general than that.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Arnold 2012-12-24 11:49:10 Re: Insert Assertion Failed in strcoll_l.c:112
Previous Message John R Pierce 2012-12-24 11:32:22 Re: pgbench help