Re: log file?

On Tuesday 05 Nov 2002 8:56 am, Florian Litot wrote:
> hi
> i have got a lot of file which is create
> DEBUG:  recycled transaction log file 0000000100000037
> DEBUG:  recycled transaction log file 0000000100000038
> DEBUG:  recycled transaction log file 0000000100000039
> DEBUG:  recycled transaction log file 000000010000003A
> DEBUG:  recycled transaction log file 000000010000003B
> DEBUG:  recycled transaction log file 000000010000003C
> why is it create?
> and what is this folder? pg_xlog
> how i can reduce the number of this files because it takes a lot of place
> thanks

PG writes all transactions to disk before actually making changes so that you
can recover in the event of a crash. It splits this transaction log into
chunks and recycles them when all the transactions it refers to are no longer
of interest.

Read up on WAL for more details and configuration options in the
postgresql.conf file.

--
  Richard Huxton