Re: Planner debug views

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Planner debug views
Дата
Msg-id 20150803160043.GI2441@postgresql.org
обсуждение исходный текст
Ответ на Re: Planner debug views  (Qingqing Zhou <zhouqq.postgres@gmail.com>)
Список pgsql-hackers
Qingqing Zhou wrote:
> On Thu, Jul 30, 2015 at 2:42 PM, Jim Nasby <Jim.Nasby@bluetreble.com> wrote:
> >
> > I think a better option would be shoving it into a backend tuplestore and
> > just leaving it there (maybe with a command to clear it for the paranoid).
> > That gives a relation you can query against, insert into another table, etc.
> 
> This is something I don't know how to do it: in my understanding, a
> tuplestore is an internal store, which means it has no name exposed.
> Thus we can't reference it later.

Yeah, that doesn't sound the kind of project you should attempt here.
EXPLAIN already knows to return tuples, so I was assuming you would
return your stuff using that mechanism.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



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

Предыдущее
От: Geoff Winkless
Дата:
Сообщение: ON CONFLICT DO UPDATE using EXCLUDED.column gives an error about mismatched types
Следующее
От: Geoff Winkless
Дата:
Сообщение: Re: ON CONFLICT DO UPDATE using EXCLUDED.column gives an error about mismatched types