Skip site navigation (1) Skip section navigation (2)

Re: Zen and art if WAL and dump file mainteance

From: dx k9 <bitsandbytes88(at)hotmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: posgres support <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Zen and art if WAL and dump file mainteance
Date: 2008-01-29 01:47:02
Message-ID: BAY116-W2388F96F5DFFEBFCA8CF3D1350@phx.gbl (view raw or flat)
Thread:
Lists: pgsql-admin
I notice in 'pg_data' that a file will stay in pg_xlog until it passes 16 MB, then it goes to the archive pretty much right away.  So, when it's busy you get a lot of files swapping into the archive , but when it's not you can get one file taking an hour or more to get up to 16 MB before it swaps over to the archive.  In reading the documentation "every 5 minutes or 36 log file segments which ever is first" - -  74 files in my case.  But I noticed when it's slow it's more it can be longer than 5 minutes.  I'm thinking the "5 minutes or 36 log segments" rule applies to just after files hit 16 MB in size, until then, they are building up.
 
Does that all sound right?> To: bitsandbytes88(at)hotmail(dot)com> CC: pgsql-admin(at)postgresql(dot)org> Subject: Re: [ADMIN] Zen and art if WAL and dump file mainteance > Date: Mon, 28 Jan 2008 16:27:05 -0500> From: tgl(at)sss(dot)pgh(dot)pa(dot)us> > dx k9 <bitsandbytes88(at)hotmail(dot)com> writes:> > We are trying to figure out why maintenance on A (zipping up & removing files) would have an affect on production processing (killed it) on pgdata - B.> > Sounds like an OOM kill problem --- do you have memory overcommit> disabled on that machine?> > regards, tom lane
_________________________________________________________________
Climb to the top of the charts! Play the word scramble challenge with star power.
http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_jan

In response to

pgsql-admin by date

Next:From: dx k9Date: 2008-01-29 02:01:59
Subject: Re: Zen and art if WAL and dump file mainteance
Previous:From: Julio LeyvaDate: 2008-01-29 01:26:12
Subject: WAL files and heckpoints

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group