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
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.