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 <[email protected]> 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 <[email protected]
>> <mailto:[email protected]>> 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
>
