> as you see, explain analyze says it will execute in 175.952ms and > because of network transfer of data executing this from pgadmin in > another machine it runs for 17s... but from time to time pgFouine is > shown upto 345.11 sec Well, 86000 rows is not enough to give PostgreSQL a headache, even on mediocre hardware. So I think that most likely culprit is the application that is reading the data - pgadmin or pgFouine. ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
