archive_timeout behavior (8.4.6)

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

Responses

Browse pgsql-admin by date

  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