Re: SELECT very slow

On 09.06.2005 03:13 Alain wrote:

> 
> 
> 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;
> 

No I want the whole result.

Thomas