Re: Streaming Questions and Sizing

On 06/30/2015 09:14 PM, Andy Erskine wrote:
> I have db of 123GB Currently and this is streaming to a secondary DB
> which also shows a size of 123GB (Using pgAdmin)
>
> The db's both reside on a 250GB directorys and on the Master i'm using
> 60% of capacity which seems expected
> On the secondary i am using 88% of the disks capacity. I assume this is
> something to do with the WAL segments ? which is currently
> wal_keep_segments = 500

That is for the server sending the segments, so I would assume you are
getting this number from the master not the standby?

>
> If this is the issue how do i go about tuning this to what is required ?
>
> If i make the segments to small then a restore may end up with an un
> synchronised database right ?
>
> thanks.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com