Re: [HACKERS] Create a separate test file for exercising system views

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: [HACKERS] Create a separate test file for exercising system views
Дата
Msg-id 20170129211219.nauhnm6uhcisysrq@alap3.anarazel.de
обсуждение исходный текст
Ответ на [HACKERS] Create a separate test file for exercising system views  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi,

On 2017-01-29 16:02:21 -0500, Tom Lane wrote:
> I did not do anything about testing the various pg_stat_xxx views.
> Those could be added later, or maybe they deserve their own home.
> (In many cases, those would need something smarter than the basic
> count(*) technique used here, because the C functions are invoked
> in the view's SELECT list not in FROM, so the planner would throw
> away those calls.)

I've previously wished there were a portable equivalent of \o /dev/null
that'd not be perfect, but it'd still exercise more than what we
currently have.  Alternatively casting the entire row to text should
allow to use count(*) trickery in some of the cases at least.

> Comments/objections?

Sounds like a good idea here.

Greetings,

Andres Freund



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

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: [HACKERS] CONNECTION LIMIT and Parallel Query don't play well together
Следующее
От: David Rowley
Дата:
Сообщение: Re: [HACKERS] Performance improvement for joins where outer side is unique