Re: Wrong docs on checkpoint_segments?

От: Andres Freund
Тема: Re: Wrong docs on checkpoint_segments?
Дата: ,
Msg-id: 201101071439.32053.andres@anarazel.de
(см: обсуждение, исходный текст)
Ответ на: Wrong docs on checkpoint_segments?  (Florian Weimer)
Ответы: Re: Wrong docs on checkpoint_segments?  (Florian Weimer)
Список: pgsql-performance

Скрыть дерево обсуждения

Wrong docs on checkpoint_segments?  (Florian Weimer, )
 Re: Wrong docs on checkpoint_segments?  (Andres Freund, )
  Re: Wrong docs on checkpoint_segments?  (Florian Weimer, )
   Re: Wrong docs on checkpoint_segments?  (Andres Freund, )

On Friday, January 07, 2011 01:45:25 PM Florian Weimer wrote:
> On 9.0, this configuration
>
> checkpoint_segments = 512     # in logfile segments, min 1, 16MB each
>
> results in 1034 segments, so the effective logfile segment size is 32 MB.
Um. Is it possible that you redefined XLOG_SEG_SIZE or used --with-wal-
segsize=SEGSIZE?

The default is still:
andres@alap2:~/src/postgresql$ grep XLOG_SEG_SIZE src/include/pg_config.h
/* XLOG_SEG_SIZE is the size of a single WAL file. This must be a power of 2
   XLOG_BLCKSZ). Changing XLOG_SEG_SIZE requires an initdb. */
#define XLOG_SEG_SIZE (16 * 1024 * 1024)

Andres


В списке pgsql-performance по дате сообщения:

От: Greg Smith
Дата:
Сообщение: Re: Wrong docs on wal_buffers?
От: Greg Smith
Дата:
Сообщение: pgbench to the MAXINT