Joshua D. Drake wrote:
> Hello,>> Perhaps you have an open transaction that isn't closing and thus the> pg_xlog continues to grow?>>
Sincerely,>>Joshua D. Drake
I was thinking about it but unfortunately there is no transaction open.
On my development database, were I simulate the same operation that I
did in production I have the same situation: 34 files and same
configuration, right now there are 5 connection and no one of them have
a transaction opened:
template1=# select * from pg_locks ; relation | database | transaction | pid | mode | granted
----------+----------+-------------+-------+-----------------+--------- 16759 | 1 | | 15910 |
AccessShareLock| t | | 7714652 | 15910 | ExclusiveLock | t
Regards
Gaetano Mendola