Re: Using LIMIT 1 in plpgsql PERFORM statements

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: "Karl O(dot) Pinc" <kop(at)meme(dot)com>
Subject: Re: Using LIMIT 1 in plpgsql PERFORM statements
Date: 2005-10-23 21:02:35
Message-ID: 200510231402.35612.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kishore B 2005-10-23 21:35:38 Re: Need help in setting optimal configuration for a huge database.
Previous Message Tomasz Rybak 2005-10-23 17:17:56 Re: Need help in setting optimal configuration for a huge