Postgres Pro
Downloads
Home   >   mailing lists

Re: is it helpful for the optimiser/planner to add LIMIT 1 - Mailing list pgsql-general

From Gregory Stark
Subject Re: is it helpful for the optimiser/planner to add LIMIT 1
Date
Msg-id 87ve2x2aam.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: is it helpful for the optimiser/planner to add LIMIT 1  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
List pgsql-general
Tree view 
"Ivan Sergio Borgonovo" <mail@webthatworks.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!

pgsql-general by date:

Previous
From: "William Temperley"
Date:
Subject: Re: Secure "where in(a,b,c)" clause.
Next
From: Colin Fox
Date:
Subject: Re: Autograph Annoucement (ERD Tool)