From: Brian Fehrle <brianf@consistentstate.com>
To: pgsql-admin@postgresql.org
Subject: Re: Should data directories match between master and hot standby?
Date: Wed, 03 Oct 2012 14:48:42 -0600
Message-ID: <506CA4AA.6000709@consistentstate.com> (raw)
In-Reply-To: <506C99A6.2030708@consistentstate.com>
References: <506C99A6.2030708@consistentstate.com>
Hi all,
Looks like I found the reason. There is a huge query on the slave that
has been running for 5 hours. It's doing major sorting and has claimed
29 gigs in the base/pgsql_tmp/ directory, which is the excact
discrepancy between the master and the slave.
So makes sense, I'm good,
- Brian F
On 10/03/2012 02:01 PM, Brian Fehrle wrote:
> Hi all,
>
> I have a hot standby (via streaming replication) set up on a
> postgresql 9.0.4 system.
>
> (I'm looking at base to eliminate differences in xlog and pg_log, etc)
> The size of my base directory on the master is 775G, the size of the
> base directory on the hot standby is 804G.
>
> Is this normal? Collecting the info from the master and the slave
> using the following shows I'm in sync:
>
> [on the master] select pg_current_xlog_location() ->
> pg_xlogfile_name_offset -> (0000000100007AB0000000E7,7282688)
> [on the slave] select pg_last_xlog_receive_location() ->
> pg_xlogfile_name_offset -> (0000000100007AB0000000E7,7282688)
> [on the slave] select pg_last_xlog_replay_location() ->
> pg_xlogfile_name_offset -> (0000000100007AB0000000E7,7281296)
>
> So I'm in sync, not like the slave is waiting on a huge delete or
> anything.
>
> Any thoughts or ideas what this could be?
>
> Thanks in advance,
>
> - Brian F
>
>
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: brianf@consistentstate.com
Subject: Re: Should data directories match between master and hot standby?
In-Reply-To: <506CA4AA.6000709@consistentstate.com>
* 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