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