From: | Brian Fehrle <brianf(at)consistentstate(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Cc: | Kevin Kempter <kevink(at)consistentstate(dot)com> |
Subject: | archive_timeout behavior (8.4.6) |
Date: | 2011-04-23 00:23:22 |
Message-ID: | 4DB21BFA.4030800@consistentstate.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi all,
We thought we were having issues with our warm standby (postgres
8.4.6), but think we figured it out, however I'd like someone to confirm
what we think is true.
If a cluster has zero activity whatsoever, but we have archive_timeout
set (say to 60 seconds), will it create a WAL file anyways, or knowing
there was zero activity does it skip it? We turned it on (temporarily)
to force WAL files to go to a newly set up warm standby so we could
verify that we have the whole end-to-end process correct, but we didn't
have any WAL files transfer to the warm standby. After some trouble
shooting, we notice that we do get a WAL file shortly after we insert a
single row into a table.
The confusion is probably because I remember this same scenario on older
versions of 8.4, and watching it generate wal files even with no activity.
So long story short, if a cluster has zero activity, and archive_timeout
is not set to 0, when it reaches that timeout should it generate a file,
or just skip because it would be 100% empty?
Thanks in advance,
Brian F
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-04-23 03:17:48 | Re: select for update |
Previous Message | Craig James | 2011-04-22 23:10:36 | Re: select for update |