hot standby data folder bigger than primary

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general