From: dx k9 <bitsandbytes88@hotmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: posgres support <pgsql-admin@postgresql.org>
Subject: Re: Zen and art if WAL and dump file mainteance
Date: Mon, 28 Jan 2008 20:47:02 -0500
Message-ID: <BAY116-W2388F96F5DFFEBFCA8CF3D1350@phx.gbl> (raw)
In-Reply-To: <7479.1201555625@sss.pgh.pa.us>
References: <BAY116-W326F5FEA10C498D47792CDD1340@phx.gbl>
<7479.1201555625@sss.pgh.pa.us>
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@hotmail.com> CC: pgsql-admin@postgresql.org> Subject: Re: [ADMIN] Zen and art if WAL and dump file mainteance > Date: Mon, 28 Jan 2008 16:27:05 -0500> From: tgl@sss.pgh.pa.us> > dx k9 <bitsandbytes88@hotmail.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=
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: bitsandbytes88@hotmail.com, tgl@sss.pgh.pa.us
Subject: Re: Zen and art if WAL and dump file mainteance
In-Reply-To: <BAY116-W2388F96F5DFFEBFCA8CF3D1350@phx.gbl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox