Re: SELECT very slow

From: Alain <alainm(at)pobox(dot)com>
To: Sql-Postgre <pgsql-sql(at)postgresql(dot)org>
Subject: Re: SELECT very slow
Date: 2005-06-09 01:13:25
Message-ID: 42A797B5.3060300@pobox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Tom Lane escreveu:
> Thomas Kellerer <spam_eater(at)gmx(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Dmitri Bichko 2005-06-09 02:23:42 Indices and user defined operators
Previous Message Tom Lane 2005-06-09 00:06:46 Re: SELECT very slow