hi,
I have a primary/standby setup and I noticed after many days running, the
standby's data folder is growing bigger than the primary, and it keeps
growing bigger, now it is almost 4 times the size, eg, primary data folder
is 2G, standby is 8G.
Does anyone know why it is so?
best,
Ying
--
hi, Andy,
We are using streaming hot standby, no wal shipping.
I checked and base and pg_xlog. both are fine.
The extra space is used by /pg_multixact/members(about 5G) and
/pg_multixact/offsets(about 1.5G)
The doc said that pg_multixact contains multitransaction data used for
shared row lock
hi, Andy,
Thanks. Right we are using 9.2.4 but plan to upgrade soon. I read 9.3.2
release notes and it is fixed specifically for this.
best,
Ying
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/hot-standby-data-folder-bigger-than-primary-tp5800402p5800545.html
Sent fr
