Home > mailing lists

using limit - Mailing list pgsql-admin

From	Anibal David Acosta
Subject	using limit
Date	December 16, 2010 18:18:57
Msg-id	001f01cb9d56$13d69790$3b83c6b0$@devshock.com Whole thread Raw
Responses	Re: using limit (Michael Holt <michael@aers.ca>)
List	pgsql-admin

Tree view

I really like to do efficient SQL queries so, my question is if I am expecting no more than one row from a select, using the LIMIT 1 could improve the performance?

If I use my logic, the LIMIT 1 instruction tell to postgres that stop searching when found 1 record, but maybe it is unnecessary

Thanks

Anibal

pgsql-admin by date:

From: Frederiko Costa
Date: 16 December 2010, 06:57:33
Subject: Re: restore database files

From: "Tsing, Vadim"
Date: 16 December 2010, 18:29:41
Subject: Copying database directory

using limit - Mailing list pgsql-admin

Previous

Next