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
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org