Shams Khan wrote: > Whenever the load of server increases, I find this query running in which seems to me the reason. Is > there any other way I can written in such a way so that it doesn't hang up the entire process? Oh, I see. Try to follow http://wiki.postgresql.org/wiki/Slow_Query_Questions if you want to receive a meaningful answer. Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin