Re: What is the quickest query in the database? - Mailing list pgsql-general

From Tino Wildenhain
Subject Re: What is the quickest query in the database?
Date
Msg-id 20030220194700.0caad03f.tino@wildenhain.de
Whole thread Raw
In response to What is the quickest query in the database?  (P G <pg_dba@yahoo.com>)
Responses Re: What is the quickest query in the database?  (Jonathan Bartlett <johnnyb@eskimo.com>)
List pgsql-general
Hi P G,

On Thu, 20 Feb 2003 09:52:07 -0800 (PST)
P G <pg_dba@yahoo.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@postgresql.org so that your
> message can get through to the mailing list cleanly
>

pgsql-general by date:

Previous
From: Dan Delaney
Date:
Subject: Dealing with schema in psql utility?
Next
From: Bruno Wolff III
Date:
Subject: Re: Fwd: REWRITE_INVOKE_MAX and "query may contain cycles"