Search Postgresql Archives

Re: pgbench help

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




Sent from my iPad

On 24-Dec-2012, at 17:15, Georges Racinet <gracinet@xxxxxxxxx> wrote:

> 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.
> 
> 
> -- 
> Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

Hi,

Thanks for the extensive discussion.

In my case,vacuum performance plays an important role. Hence, I shall run only one server at a time while profiling.

Thanks a ton,

Atri

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux