Postgres Pro
Downloads
Home   >   mailing lists

amount of WAL logs larger than expected - Mailing list pgsql-admin

From Mark Steben
Subject amount of WAL logs larger than expected
Date
Msg-id CADyzmywE6B6SXnDxofNNVGagnH8wj0+44f09_QiJ7pzPDP0a=w@mail.gmail.com
Whole thread Raw
Responses Re: amount of WAL logs larger than expected  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: amount of WAL logs larger than expected  (bricklen <bricklen@gmail.com>)
List pgsql-admin
Tree view
Good afternoon

We run postgres 9.2.12  and run vacuum on a 540GB database.

I've attached a 'show all' for your reference.  With CHECkPOINT_SEGMENTS set at 128
and CHECKPOINT_COMPLETION_TARGET set at 0.9 I wouldn't expect the number of logs in pg_xlog to creep much over 400.  But when we run vacuum, the number can climb to over 5000 and threatens to blow out on space.  Is there something else I should be looking at causing this unexpected number of logs?

Our server is also master for a slony1.2.2.3 slave and also to a hot standby server.

Any insight /recommendations welcome.  Thank you
 

--
Mark Steben
 Database Administrator
@utoRevenue | Autobase 
  CRM division of Dominion Dealer Solutions 
95D Ashley Ave.
West Springfield, MA 01089
t: 413.327-3045
f: 413.383-9567

www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
 www.drivedominion.com





Attachment

pgsql-admin by date:

Previous
From: Shreeyansh Dba
Date:
Subject: Re: postgres_fdw for porstgresql 9.2 installation
Next
From: "Joshua D. Drake"
Date:
Subject: Re: amount of WAL logs larger than expected