Re: Simulating Clog Contention

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Simulating Clog Contention
Дата
Msg-id CAMkU=1z9H-1shJpxeuuf12tZSmu2USsAb587DikVsVW1=GK_Og@mail.gmail.com
обсуждение исходный текст
Ответ на Simulating Clog Contention  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: Simulating Clog Contention  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-hackers
On Thu, Jan 12, 2012 at 4:31 AM, Simon Riggs <simon@2ndquadrant.com> wrote:

> The following patch adds a pgbench option -I to load data using
> INSERTs, so that we can begin benchmark testing with rows that have
> large numbers of distinct un-hinted transaction ids. With a database
> pre-created using this we will be better able to simulate and thus
> more easily measure clog contention. Note that current clog has space
> for 1 million xids, so a scale factor of greater than 10 is required
> to really stress the clog.

Running with this patch with a non-default scale factor generates the
spurious notice:

"Scale option ignored, using pgbench_branches table count = 10"

In fact the scale option is not being ignored, because it was used to
initialize the pgbench_branches table count earlier in this same
invocation.

I think that even in normal (non-initialization) usage, this message
should be suppressed when the provided scale factor
is equal to the pgbench_branches table count.

Cheers,

Jeff


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Dan Scales
Дата:
Сообщение: Re: 16-bit page checksums for 9.2
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: CLOG contention, part 2