From: | Tino Wildenhain <tino(at)wildenhain(dot)de> |
---|---|
To: | P G <pg_dba(at)yahoo(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: What is the quickest query in the database? |
Date: | 2003-02-20 18:47:00 |
Message-ID: | 20030220194700.0caad03f.tino@wildenhain.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2003-02-20 19:23:01 | Re: Fwd: REWRITE_INVOKE_MAX and "query may contain cycles" |
Previous Message | Dan Delaney | 2003-02-20 18:46:08 | Dealing with schema in psql utility? |