Re: 7.3.1 New install, large queries are slow

Поиск
Список
Период
Сортировка
От Tomasz Myrta
Тема Re: 7.3.1 New install, large queries are slow
Дата
Msg-id 3E12BBEA.5020105@klaster.net
обсуждение исходный текст
Ответ на Re: 7.3.1 New install, large queries are slow  ("Roman Fail" <rfail@posportal.com>)
Список pgsql-performance
Roman Fail wrote:
> The same result columns and JOINS are performed all day with variations on the WHERE clause;
Are there any where clauses which all of theses variation have?
If yes - query can be reordered to contain explicit joins for these clauses and
to let Postgres to find best solution for other joins.

I know, it is not best solution, but sometimes I prefer finding best join order by myself.
I create then several views returning the same values, but manualy ordered for specific where clauses.

Tomasz Myrta



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

Предыдущее
От: "Roman Fail"
Дата:
Сообщение: Re: 7.3.1 New install, large queries are slow
Следующее
От: Kevin Brown
Дата:
Сообщение: Re: 7.3.1 New install, large queries are slow