Postgres Pro
Downloads
Home   >   mailing lists

Large Number of Files in pg_xlog - Mailing list pgsql-admin

From Bob Lunney
Subject Large Number of Files in pg_xlog
Date
Msg-id 793643.73193.qm@web39705.mail.mud.yahoo.com
Whole thread Raw
Responses Re: Large Number of Files in pg_xlog  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
Is it possible to reduce the number of files in pg_xlog.  Currently, checkpoint_segments is set to 512, which if I
understandcorrectly, means there could be up to 1025 files in pg_xlog, 16Gb of WAL.  Right now there are 833 files.
I'vetried setting checkpoint_segments to a lower number and restarting the database, but to no avail.  Is there another
methodthat doesn't involve running a dump, initdb, and restore? 

Thanks in advance,

Bob Lunney

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: setting up a client only service
Next
From: Tom Lane
Date:
Subject: Re: Large Number of Files in pg_xlog