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
- Is LIMIT n in Spark SQL useful? Yi Zhang
- Re: Is LIMIT n in Spark SQL useful? Robin East
- Re: Is LIMIT n in Spark SQL useful? Robin East
- Re: Is LIMIT n in Spark SQL useful? Michael Armbrust
- Re: Is LIMIT n in Spark SQL useful? Yi Zhang
- Re: Is LIMIT n in Spark SQL useful? Robin East