PostgreSQL 8.1.9, Linux Redhat ES 4 I am experiencing a timing issue with the following query: SELECT count(procpid) FROM pg_stat_activity WHERE usename='someuser'
If I execute the above query by the client who is user "someuser" and it is executed immediately after connecting I am getting two different results depending on the speed of the connection. If I connect to the database on a local area network of 100Mb/s and immediately execute the statement, I see the result of 0. If I connect to the same database over a slow connection, for example 115kb/s and immediately execute the statement, I see the result of 1. Is this normal behaviour? Regards Donald Fraser
