Re: What is the quickest query in the database?

It sounds like the caller is simply trying to see if the engine is up
and operational.
If that is the case, then just connect, disconnect.

Jonathan Bartlett wrote:

>Might select NULL; be faster, since the number doesn't have to be parsed,
>and null is probably a keyword?
>
>Jon
>
>On Thu, 20 Feb 2003, Tino Wildenhain wrote:
>
>
>
>>Hi P G,
>>
>>On Thu, 20 Feb 2003 09:52:07 -0800 (PST)
>>P G <pg_dba(at)yahoo(dot)com> wrote:
>>
>>
>>
>>>What is the quickest and least intrusive query in the
>>>database that will always succeed?
>>>
>>>
>>select 1;
>>
>>:o)
>>
>>Regards
>>Tino
>>
>>
>>
>>
>>>select current_user;
>>>
>>>-- OR --
>>>
>>>select datname from pg_database where datname =
>>>'some_database';
>>>
>>>Or would it be something else?
>>>
>>>TIA.
>>>
>>>__________________________________________________
>>>Do you Yahoo!?
>>>Yahoo! Tax Center - forms, calculators, tips, more
>>>http://taxes.yahoo.com/
>>>
>>>---------------------------(end of broadcast)---------------------------
>>>TIP 3: if posting/reading through Usenet, please send an appropriate
>>>subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>>>message can get through to the mailing list cleanly
>>>
>>>
>>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 5: Have you checked our extensive FAQ?
>>
>>http://www.postgresql.org/users-lounge/docs/faq.html
>>
>>
>>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>message can get through to the mailing list cleanly
>
>