Re: What is the quickest query in the database?

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
>

In response to

Responses

Browse pgsql-general by date

  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?