Re: check point segments leakage ?

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