Re: [planner] Ignore "order by" in subselect if parrent do count(*) - Mailing list pgsql-performance

From Marcin Mirosław
Subject Re: [planner] Ignore "order by" in subselect if parrent do count(*)
Date
Msg-id 4F4F6937.4090200@mejor.pl
Whole thread Raw
In response to Re: [planner] Ignore "order by" in subselect if parrent do count(*)  (Szymon Guz <mabewlun@gmail.com>)
List 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 by date:

Previous
From: Szymon Guz
Date:
Subject: Re: [planner] Ignore "order by" in subselect if parrent do count(*)
Next
From: Jeff Janes
Date:
Subject: Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?