Re: problem with from_collapse_limit and joined views

Поиск
Список
Период
Сортировка
От Markus Schulz
Тема Re: problem with from_collapse_limit and joined views
Дата
Msg-id 201012041124.03154.msc@antzsystem.de
обсуждение исходный текст
Ответ на Re: problem with from_collapse_limit and joined views  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-performance
Дерево обсуждения 
Am Freitag, 3. Dezember 2010 schrieb Kevin Grittner:
> Markus Schulz <msc@antzsystem.de> wrote:
> > i have a big performance problem
> >
> > [joining two complex views for reporting]
>
> What version of PostgreSQL is this?  How is PostgreSQL configured?
> (The postgresql.conf file with all comments removed is good.)

Production System is 8.4 (config attached).
But i've tried 9.0 with same result.

Regards
msc
Вложения

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

Предыдущее
От: John Papandriopoulos
Дата:
Сообщение: Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT
Следующее
От: Mathieu De Zutter
Дата:
Сообщение: Slow query to get last created row using CURRVAL