> When I tested this feature, I had 30 caches per 5 minutes, and only a
> few from these queries had a sense. Switch between off and on is not
> user friendly. I believe so there can be other solution than mine, but
> a possibility to friendly clean unwanted caches is necessary.
If you know that you'll need the result of a query beforehand, you can
always use SELECT ... INTO ... . No client-side features required.
This feature is intended for people running plenty of ad-hoc queries, when
every result could potentially be useful.