Hi, > I'm also trying an EXPLAIN ANALYZE for the SELECT part, but it seems to > take a while too and is seemingly calling only gettimeofday. An update on this. Apart from gettimeofday calls, which I filtered out when logging, I've seen about 80 lseeks recorded every 1h10m (each 1us apart): 2011-12-28 11:06:25.546661500 lseek(10, 0, SEEK_END) = 27623424 2011-12-28 11:06:25.546662500 lseek(10, 0, SEEK_END) = 27623424 2011-12-28 11:06:25.546663500 lseek(10, 0, SEEK_END) = 27623424 ... 2011-12-28 12:16:56.144663500 lseek(10, 0, SEEK_END) = 27623424 ... 2011-12-28 13:28:20.436549500 lseek(10, 0, SEEK_END) = 27623424 ... I've then decided to interrupt the EXPLAIN ANALYZE. But I suppose that the database as it is now will likely allow to further debug what's happening. Cheers -- Matteo Beccati Development & Consulting - http://www.beccati.com/ -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
