Re: PITR: in use WAL file question

This message is in MIME format. The first part should be readable text,
while the remaining parts are likely unreadable without MIME-aware tools.

---498786332-328574496-1116006152=:6036
Content-Type: TEXT/PLAIN; CHARSET=ISO-8859-1; FORMAT=flowed
Content-Transfer-Encoding: 8BIT
Content-ID: <Pine(dot)LNX(dot)4(dot)62(dot)0505131042381(dot)6036(at)discord(dot)dyndns(dot)org>

On Fri, 13 May 2005, Josh Berkus wrote:

> Jeff,
>
>> Did you mean using CHECKPOINT to force a WAL rollover for use with PITR?
>>  Or did you just mean doing something like this:
>
> Checkpoint to force a WAL rollover.
>
> I'm a bit surprised that you folks aren't turning over WAL segments faster.
> I thought you had more traffic than that?

Probably our traffic is more read intensive.

Assuming I can just look at the modified times of the WAL files in the
pg_xlog directory on the filesystem like so:

-rw------- 1 postgres postgres 16777216 May 13 10:30 0000000C0000009C
-rw------- 1 postgres postgres 16777216 May 13 05:07 0000000C000000A3
-rw------- 1 postgres postgres 16777216 May 12 21:38 0000000C000000A2
-rw------- 1 postgres postgres 16777216 May 12 13:52 0000000C000000A1
-rw------- 1 postgres postgres 16777216 May 12 04:39 0000000C000000A0
-rw------- 1 postgres postgres 16777216 May 11 20:35 0000000C0000009F
-rw------- 1 postgres postgres 16777216 May 11 11:58 0000000C0000009E
-rw------- 1 postgres postgres 16777216 May 11 05:13 0000000C0000009D

Then it's really about every 5 hours. Statting the WAL files makes it seem
like that is actually the case. Of course I could be making a foolish
assumption regarding this, so maybe there is a more reasonable way to look at
this info? This is actually the old running 7.4 system which will be replaced
this weekend.

BTW, running a checkpoint did not appear to make it roll over the WAL log on
7.4...is that behavior different on 8.x?

--
Jeff Frost, Owner <jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---498786332-328574496-1116006152=:6036--