Re: Is LIMIT n in Spark SQL useful？

[Robin East]

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