Re: is it helpful for the optimiser/planner to add LIMIT 1

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: "Ivan Sergio Borgonovo" <mail(at)webthatworks(dot)it>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: is it helpful for the optimiser/planner to add LIMIT 1
Date: 2008-04-04 10:18:09
Message-ID: 87ve2x2aam.fsf@oxford.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Ivan Sergio Borgonovo" <mail(at)webthatworks(dot)it> writes:

> Summarising it up: is it worth to add it here and there as an
> optimisation flag?

Probably not. Unless you're not planning on reading all the resulting records
anyways and want the planner to optimize with that assumption.

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's PostGIS support!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrea 2008-04-04 10:45:34 Newby Help needed
Previous Message William Temperley 2008-04-04 09:11:35 Re: Secure "where in(a,b,c)" clause.