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

From Richard Huxton
Subject Re: What is the quickest query in the database?
Date
Msg-id 200302201929.19071.dev@archonet.com
Whole thread Raw
In response to What is the quickest query in the database?  (P G <pg_dba@yahoo.com>)
List pgsql-general
On Thursday 20 Feb 2003 5:52 pm, P G wrote:
> What is the quickest and least intrusive query in the
> database that will always succeed?
>
> select current_user;
>
> -- OR --
>
> select datname from pg_database where datname =
> 'some_database';
>
> Or would it be something else?

Probably something like

SELECT 1;

--
  Richard Huxton

pgsql-general by date:

Previous
From: Tariq Muhammad
Date:
Subject: Re: Dealing with schema in psql utility?
Next
From: Richard Huxton
Date:
Subject: Re: A problem with sequences...