Postgres Pro
Downloads
Home   >   mailing lists

Re: Using LIMIT 1 in plpgsql PERFORM statements - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Using LIMIT 1 in plpgsql PERFORM statements
Date
Msg-id 200510231402.35612.josh@agliodbs.com
Whole thread Raw
In response to Using LIMIT 1 in plpgsql PERFORM statements  ("Karl O. Pinc" <kop@meme.com>)
Responses Re: Using LIMIT 1 in plpgsql PERFORM statements
Re: Using LIMIT 1 in plpgsql PERFORM statements
List pgsql-performance
Tree view 
Karl,

> PERFORM 1 FROM foo;
> IF FOUND THEN ...
>
> is any slower than:
>
> PERFORM 1 FROM foo LIMIT 1;
> IF FOUND THEN ...

I'm wondering in what context it makes sense to call PERFORM on a constant.

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Need help in setting optimal configuration for a huge
Next
From: Kishore B
Date:
Subject: Re: Need help in setting optimal configuration for a huge database.