Re: SELECT very slow - Mailing list pgsql-sql

From Alain
Subject Re: SELECT very slow
Date
Msg-id 42A797B5.3060300@pobox.com
Whole thread Raw
In response to Re: SELECT very slow  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: SELECT very slow  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-sql

Tom Lane escreveu:
> Thomas Kellerer <spam_eater@gmx.net> writes:
> 
>>Is there anything I can do, to convince PG to return the first row more 
>>quickly?

Are you now looking for the LIMIT ?

SELECT * FROM table LIMIT 1;

and when when you wnat the rest of it:

SELECT * FROM table OFFSET 1;

Alain


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: SELECT very slow
Next
From: "Dmitri Bichko"
Date:
Subject: Indices and user defined operators