Re: [planner] Ignore "order by" in subselect if parrent do count(*)

Поиск
Список
Период
Сортировка
От Marcin Mirosław
Тема Re: [planner] Ignore "order by" in subselect if parrent do count(*)
Дата
Msg-id 4F4F6937.4090200@mejor.pl
обсуждение исходный текст
Ответ на Re: [planner] Ignore "order by" in subselect if parrent do count(*)  (Szymon Guz <mabewlun@gmail.com>)
Список pgsql-performance
W dniu 01.03.2012 13:09, Szymon Guz pisze:
> Could you provide the postgres version and the structure of
> users_profile table (with indexes)?

Argh, i forgot about version. It's postgresql-9.1.3.
I don't think structre of users_profile is important here. Me idea is
let planner ignore sorting completly. I don't want to have sort quicker
(in this case, surely;)), i'd like to skip sorting completly because it
doesn't influence for query result.
Table isn't "real life", it only demonstrates than planner sometimes can
safely skip some steps.
Regards,
Marcin

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

Предыдущее
От: Szymon Guz
Дата:
Сообщение: Re: [planner] Ignore "order by" in subselect if parrent do count(*)
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?