> 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.
