Souquieres Adam <adam.souquieres@xxxxxxxxx> writes: > When i relaunch my ANALYSE VERBOSE, pg_locks table grows quickly from 20 > lines to more than 1000 lines and still growing, all the lines are owned > by the same "virtual transaction" and the same "pid". Hm. I experimented a bit and looked at the code, and I find I was not remembering ANALYZE's behavior exactly right: it only processes all the tables inside one transaction if you start it inside a transaction block (ie, after BEGIN, or inside a function). If you just run it by itself then it does a transaction per table, just like VACUUM. So I'm thinking there's something you're not telling us about exactly how you invoke ANALYZE. > When i finish to write this email, i juste hit more than 3200 lock owned > by the same transaction ! Could you show us some of those locks (a few dozen lines from pg_locks)? regards, tom lane
