Re: error in insertion

On 29 Oct 2002 at 13:58, Florian Litot wrote:

> i have got this error
> what is it?

This is not error. It's just a message.
>
> DEBUG: recycled transaction log file 0000000000000048
> DEBUG: recycled transaction log file 0000000000000049

Postgresql uses some WAL files which are fixed in size and fixed in number for
a running instance. Obviously for a running instance there are going to be more
transactions than it can hold it in WAL. But transaction in WAL are
periodically flushed to main database. After this flush is complete, the WAL
file can be used to hold another set of transaction(rather WAL file name, if I
understand it correctly..) This message just says that it's reusing WAL files.
If this is too frequent, consider increasing wal_files in postgresql.conf, but
anything beyond 5 or 10 is overkill, given that each WAL file is 16MB in size..

HTH

Bye
Shridhar

--
design, v.: What you regret not doing later on.