Postgres Pro
Downloads
Home   >   mailing lists

question - Mailing list pgsql-general

From Emi Lu
Subject question
Date
Msg-id 5432B042.3000409@encs.concordia.ca
Whole thread Raw
Responses Re: question  (Andy Colson <andy@squeakycode.net>)
List pgsql-general
Tree view 
Hello List,

      May I know will <idle> cause any potential performance
      issues for psql8.3 please?
      version (PostgreSQL 8.3.18 on x86_64-unknown-linux-gnu, compiled
      by GCC 4.1.2)

      E.g., got 10 idle connections for 10 days.
       select current_query from pg_stat_activity  where usename
      ='test';

                             

current_query                              

--------------------------------------------------------------------------
       <IDLE>
       <IDLE>
       <IDLE>
       <IDLE>
       <IDLE>
       <IDLE>
       <IDLE>
       <IDLE>
       <IDLE>
       <IDLE>

      Thanks a lot!
      Emi

pgsql-general by date:

Previous
From: Andy Colson
Date:
Subject: Re: Converting char to varchar automatically
Next
From: Merlin Moncure
Date:
Subject: Re: How to find greatest record before known values fast