Re: what's this debug mean? - Mailing list pgsql-novice

From Jason Earl
Subject Re: what's this debug mean?
Date
Msg-id 87k7w8ks2o.fsf@npa01zz001.simplot.com
Whole thread Raw
In response to what's this debug mean?  (Ewald Geschwinde <postgres@cybertec.at>)
Responses Re: what's this debug mean?
List 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 by date:

Previous
From: Ewald Geschwinde
Date:
Subject: what's this debug mean?
Next
From: Tom Lane
Date:
Subject: Re: what's this debug mean?