Re: Configuring BLCKSZ and XLOGSEGSZ (in 8.3)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Configuring BLCKSZ and XLOGSEGSZ (in 8.3)
Дата
Msg-id 10574.1165349679@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Configuring BLCKSZ and XLOGSEGSZ (in 8.3)  ("Simon Riggs" <simon@2ndquadrant.com>)
Ответы Re: Configuring BLCKSZ and XLOGSEGSZ (in 8.3)  ("Simon Riggs" <simon@2ndquadrant.com>)
Список pgsql-hackers
"Simon Riggs" <simon@2ndquadrant.com> writes:
> On Mon, 2006-11-27 at 18:26 -0500, Tom Lane wrote:
>> [ studies code a bit more... ]  I'm also wondering whether the forced
>> pg_control update at each xlog seg switch is worth its keep.  Offhand
>> it seems like the checkpoint pointer is enough; why are we maintaining
>> logId/logSeg in pg_control?

> We maintain the values in shared memory to allow us to determine whether
> or not its time to checkpoint, and also to ensure that there is one and
> only one call to checkpoint. So we need to keep track of this somewhere
> and that may as well be where it already is.

Say again?  AFAICT those fields are write-only; the only place we
consult them is to decide whether they need to be updated.  My thought
was to remove 'em altogether.

            regards, tom lane

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

Предыдущее
От: "Pavel Stehule"
Дата:
Сообщение: trappable warnings, dynamic change of minimal level for PG_RE_THROW
Следующее
От: Tom Lane
Дата:
Сообщение: Re: trappable warnings, dynamic change of minimal level for PG_RE_THROW