why are there so many idle transactions, why doesnt webpy close the db pools once the query is over?
echo "select current_query,datname from pg_stat_activity where current_query!='<IDLE>' and current_query!='END'" | psql -U postgres -h $host <IDLE> in transaction | pop <IDLE> in transaction | pop <IDLE> in transaction | pop <IDLE> in transaction | pop <IDLE> in transaction | pop <IDLE> in transaction | pop <IDLE> in transaction | pop <IDLE> in transaction | pop <IDLE> in transaction | pop <IDLE> in transaction | pop <IDLE> in transaction | pop <IDLE> in transaction | pop <IDLE> in transaction | pop <IDLE> in transaction | pop <IDLE> in transaction | pop <IDLE> in transaction | pop <IDLE> in transaction | pop <IDLE> in transaction | pop -- BidEgg - Worlds best low price Auction site http://bidegg.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web.py" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/webpy?hl=en -~----------~----~----~----~------~----~------~--~---
