Re: [SQL] SELECT very slow

[Alain]

Tom Lane escreveu:

Thomas Kellerer <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])