Re: what's this debug mean?

Поиск
Список
Период
Сортировка
От Jason Earl
Тема Re: what's this debug mean?
Дата
Msg-id 87k7w8ks2o.fsf@npa01zz001.simplot.com
обсуждение исходный текст
Ответ на what's this debug mean?  (Ewald Geschwinde <postgres@cybertec.at>)
Ответы Re: what's this debug mean?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
This means that a new file was created and you need to consider
increasing the WAL_FILES attribute in postgresql.conf :).

Basically what happens is that PostgreSQL keeps track of a whole bunch
of transaction information in these wal files (check out the pg_xlog
directory in your postgresql "data" directory).  Each of these files
are 16 Megs (or so) and they are filled with null data when they are
first created so that they are guaranteed to actually be written to
the filesystem.  In other words, they are somewhat expensive to
create.  If PostgreSQL is creating quite a few of these "on the fly,"
say if you have a lot of large transactions, then you should consider
creating more of them at startup so that you will have them lying
around when you need them.

You can safely ignore the message if your database is fast enough :).

Jason

Ewald Geschwinde <postgres@cybertec.at> writes:

> DEBUG:  XLogWrite: new log file created - consider increasing WAL_FILES
>
> Epi
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

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

Предыдущее
От: Ewald Geschwinde
Дата:
Сообщение: what's this debug mean?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: what's this debug mean?