Re: show pool_status like... - Mailing list pgsql-hackers

From Tom Lane
Subject Re: show pool_status like...
Date
Msg-id 23989.1315883447@sss.pgh.pa.us
Whole thread Raw
In response to show pool_status like...  (Tatsuo Ishii <ishii@sraoss.co.jp>)
Responses Re: show pool_status like...
List pgsql-hackers
Tatsuo Ishii <ishii@sraoss.co.jp> writes:
> While I took a look at MySQL manual (mainly for checking query cache
> functionality), I noticed that MySQL has following syntx:

> show .... like 'foo%';

> I think this is usefull for "show pool_status" command since it has
> lengthy output now.

> Usage of show pool_status and like will be something like:

> show pool_status like 'client_idle%' will only show the status of
> client_idle_limit and client_idle_limit_in_recovery.

> Comments?

I think you need to rethink how you've got pool_status defined.
The above kluge isn't going to play nicely at all with the pg_settings
view, for example.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Alpha 1 for 9.2
Next
From: Robert Haas
Date:
Subject: Re: Re: [BUGS] BUG #6189: libpq: sslmode=require verifies server certificate if root.crt is present