I've been having a difficult time finding an answer for this via google, so please excuse me if this is the wrong list, or a stupid question...
We're trying to diagnose a system issue where we ended up with 100's of non-idle queries in pg_stat_activity, but the actual system load didn't correspond to what we should have seen with that query load. Is it possible that a client could cause this by not acknowledging that it has received results, so that postgres will think the query is active even when it's done the hard work of getting the queried data off disk? These were all SELECT queries if that makes any difference.
