Fetch a single record

Поиск
Список
Период
Сортировка
От david_shadovitz@xontech.com (David Shadovitz)
Тема Fetch a single record
Дата
Msg-id 8b37e2e5.0312051351.4045b4e@posting.google.com
обсуждение исходный текст
Ответы Re: Fetch a single record  (Peter Eisentraut <peter_e@gmx.net>)
Re: Fetch a single record  (Paul Thomas <paul@tmsl.demon.co.uk>)
Re: Fetch a single record  (greg@turnstep.com)
Список pgsql-sql
I'm looking for the fastest way to fetch a single record from a table.I don't care what record it is.

Here are two techniques I've explored:

1. Use LIMIT
SELECT * FROM myTable LIMIT 1

2. Get a valid OID and then get the record.
SELECT MIN(oid) AS anOID FROM myTable
SELECT * FROM myTable WHERE oid = anOID

The 1st technique is slow.  (I think PostgreSQL fetches all records
and then returns just one.)  The 2nd is faster, but not fast enough.

Any other ideas?  Please reply to me personally (david@shadovitz.com)
as well as to the list.

Thanks.
-David


В списке pgsql-sql по дате отправления:

Предыдущее
От: "Ganesan Kanavathy"
Дата:
Сообщение: Field Size
Следующее
От: "Marc A. Leith"
Дата:
Сообщение: Re: [ADMIN] Field Size