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

From: Marcin Mirosław <marcin(at)mejor(dot)pl>
To: Szymon Guz <mabewlun(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: [planner] Ignore "order by" in subselect if parrent do count(*)
Date: 2012-03-01 12:19:03
Message-ID: 4F4F6937.4090200@mejor.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

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