Skip site navigation (1) Skip section navigation (2)

Re: error in insertion

From: "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: error in insertion
Date: 2002-10-29 13:57:01
Message-ID: 3DBEE105.13978.52F8083@localhost (view raw or flat)
Thread:
Lists: pgsql-general
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.


In response to

pgsql-general by date

Next:From: Shridhar DaithankarDate: 2002-10-29 14:03:03
Subject: Re: ONE MORE PERFORMANCE ISSUE WITH POSTGRES
Previous:From: Brice MasonDate: 2002-10-29 13:49:15
Subject: Windows Installation HELP!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group