Re: Review: query result history in psql

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Review: query result history in psql
Дата
Msg-id CAFj8pRBh0dMZaJjHrYbrTKyggJa3KfuWCYHjbLVULp2=OOvxrA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Review: query result history in psql  (Maciej Gajewski <maciej.gajewski0@gmail.com>)
Ответы Re: Review: query result history in psql  (Ian Link <ian@ilink.io>)
Список pgsql-hackers
2013/7/1 Maciej Gajewski <maciej.gajewski0@gmail.com>:
>
>> 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.
>

a idea is good, but I don't think, it can be useful with current
implementation. How I can identify, what is correct answer for my
query? Have I remember twenty numbers and twenty queries?

Regards

Pavel



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Maciej Gajewski
Дата:
Сообщение: Re: Review: query result history in psql
Следующее
От: KONDO Mitsumasa
Дата:
Сообщение: Re: [PATCH] add --progress option to pgbench (submission 3)