Re: join to view over custom aggregate seems like it should be faster

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: join to view over custom aggregate seems like it should be faster
Дата
Msg-id 10651.1176152866@sss.pgh.pa.us
обсуждение исходный текст
Ответ на join to view over custom aggregate seems like it should be faster  ("Merlin Moncure" <mmoncure@gmail.com>)
Ответы Re: join to view over custom aggregate seems like it should be faster  ("Merlin Moncure" <mmoncure@gmail.com>)
Re: join to view over custom aggregate seems like it should be faster  ("Merlin Moncure" <mmoncure@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
"Merlin Moncure" <mmoncure@gmail.com> writes:
> I have an odd performance issue on 8.2 that I'd thought I'd document
> here.  I have a workaround, but I'm if there is something that I'm not
> seeing.

It's hard to comment on this without seeing the full details of the view
and tables.  I'm wondering where the SubPlans are coming from, for instance.

            regards, tom lane

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

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: Please humor me ...
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: how to efficiently update tuple in many-to-many relationship?