Thread: hot standby data folder bigger than primary
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 -- View this message in context: http://postgresql.1045698.n5.nabble.com/hot-standby-data-folder-bigger-than-primary-tp5800402.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
On 4/16/2014 2:52 PM, yhe wrote: > 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 > Are you using streaming or wal shipping (or both)? The data folder is to general, there are a bunch of folders in there. Can you compare the sizes of the folders inside? (things like base and pg_xlog) Assuming you have wal shipping, do you have the archive_cleanup_command set in your recovery.conf? -Andy
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 locks. Is there some process that can clean these two folder when the lock is not needed? Thanks. best, Ying -- View this message in context: http://postgresql.1045698.n5.nabble.com/hot-standby-data-folder-bigger-than-primary-tp5800402p5800505.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
Hi, On 2014-04-17 06:28:52 -0700, yhe wrote: > 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 locks. Is there some process that can clean these two folder when > the lock is not needed? Which version are you using? that might be recently (9.3.2 and corresponding releases) fixed problem. Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
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 from the PostgreSQL - general mailing list archive at Nabble.com.