Re: postgres & smp - Mailing list pgsql-admin

From Tom Lane
Subject Re: postgres & smp
Date
Msg-id 20126.982537373@sss.pgh.pa.us
Whole thread Raw
In response to Re: postgres & smp  (Thomas Graichen <news-list.pgsql.admin@innominate.de>)
List pgsql-admin
Thomas Graichen <news-list.pgsql.admin@innominate.de> writes:
> Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Hm, did you set commit_delay to zero?  What are the other postmaster
>> parameters (especially -B) ?

> i used 32 clients -N set to 128 and -B to 256 - commit_delay was
> set to 5 (default) - do you expect much better smp results with
> commit_delay=0?

Possibly.  See adjacent thread about 7.1b4 performance.

            regards, tom lane

pgsql-admin by date:

Previous
From: Dmitry Morozovsky
Date:
Subject: Re: v7.1b4 bad performance
Next
From: Tatsuo Ishii
Date:
Subject: Re: Re: [ADMIN] v7.1b4 bad performance