At 12:47 05/11/02, Richard Huxton wrote:
>On Tuesday 05 Nov 2002 11:14 am, Florian Litot wrote:
> > At 11:47 05/11/02, Richard Huxton wrote:
> > >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.
> >
> > but the problem is it never recycle this file so i have a got a px_log 2Go
> > how i can resolve this problem?
> > why it doesn't recycle?
>
>According to the log you posted it was being recycled.
>
>How many files are there in pg_xlog and what dates do they have?
>What are the WAL settings in your postgresql.conf file?
>Do you have any clients that have been running a long time?
>
>--
> Richard Huxton
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo@postgresql.org so that your
>message can get through to the mailing list cleanly
i have got 66 files
i have got a new file to 16 minutes
#
# Write-ahead log (WAL)
#
wal_files = 64 # range 0-64
#wal_sync_method = fsync # the default varies across platforms:
# # fsync, fdatasync, open_sync, or open_datasync
#wal_debug = 0 # range 0-16
#commit_delay = 0 # range 0-100000
#commit_siblings = 5 # range 1-1000
#checkpoint_segments = 3 # in logfile segments (16MB each), min 1
#checkpoint_timeout = 300 # in seconds, range 30-3600
#fsync = true
it's standard
i make some insertion i make 1 insertion every 2 seconds