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.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
