Re: Fetch a single record

David Shadovitz wrote:
> 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.

This is hard to believe.  The first technique should be the fasted, but 
might suffer from a bad plan.  Please make sure that you have run 
ANALYZE, and then post EXPLAIN ANALYZE output.