Craig James <cjames@xxxxxxxxxxxxxx> writes: > I installed 9.2 on our new server and am seeing something odd that doesn't > happen in 8.4: > postgres=# select datname, pid, usename, query from pg_stat_activity where > query != '<IDLE>'; The query column now means "current or last query" --- there's a separate column to check for the idle status. Those DEALLOCATEs are evidently what your app does before going idle. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
