Обсуждение: what's this debug mean?

DEBUG:  XLogWrite: new log file created - consider increasing WAL_FILES

Epi

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

Jason Earl <jason.earl@simplot.com> writes:
> This means that a new file was created and you need to consider
> increasing the WAL_FILES attribute in postgresql.conf :).

It's only worth worrying about if you see it regularly.

There is some documentation about this in the administrator's guide, eg
http://candle.pha.pa.us/main/writings/pgsql/sgml/wal-configuration.html
(That's 7.2 docs and some of the statements are not true for 7.1, but
it's close enough, and I think the exposition is better than in the 7.1
docs.)

            regards, tom lane