Re: error in insertion
От | Shridhar Daithankar |
---|---|
Тема | Re: error in insertion |
Дата | |
Msg-id | 3DBEE105.13978.52F8083@localhost обсуждение исходный текст |
Ответ на | error in insertion (Florian Litot <flitot@besancon.sema.slb.com>) |
Список | 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.
В списке pgsql-general по дате отправления: