On 18/05/15 13:44, Sachin Srivastava wrote: > But currently my pg_xlog size is 60 GB and there are 3740 WAL file in > this folder and in Last week this was 400 GB(pg_xlog folder) and WAL > file were approx. 30000. Due to archiving pg_xlog folder size is > decreasing now but it’s taking one week to come in normal size.
Any chance you have unfinished transactions running for a week? pg_stat_activity should be able to tell you that. Torsten -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
