and a further question - have you tried running this query in pqsl? what’s the
performance like there?
> On 4 May 2015, at 16:04, Robin East <robin.e...@xense.co.uk> wrote:
>
> What query are you running. It may be the case that your query requires
> PosgreSQL to do a large amount of work before identifying the first n rows
>> On 4 May 2015, at 15:52, Yi Zhang <zhangy...@yahoo.com.INVALID
>> <mailto:zhangy...@yahoo.com.INVALID>> wrote:
>>
>> I am trying to query PostgreSQL using LIMIT(n) to reduce memory size and
>> improve query performance, but I found it took long time as same as querying
>> not using LIMIT. It let me confused. Anybody know why?
>>
>> Thanks.
>>
>> Regards,
>> Yi
>