show pool_status like...

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

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.

Sorry, I accidently posted to pgsql-hackers, not pgpool-hackers. This
proposal was not for PostgreSQL and please forget this.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp