Re: What is the quickest query in the database?

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: What is the quickest query in the database?
Дата
Msg-id 200302201929.19071.dev@archonet.com
обсуждение исходный текст
Ответ на What is the quickest query in the database?  (P G <pg_dba@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: Tariq Muhammad
Дата:
Сообщение: Re: Dealing with schema in psql utility?
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: A problem with sequences...