title: Java 8 JPA Repository Stream row-by-row in Postgresql
body: <p>Reading <a href="http://knes1.github.io/blog/2015/2015-10-19-streaming-mysql-results-using-java8-streams-and-spring-data.html" rel="noreferrer">this</a> about MySQL defines certain query hints (<code>@QueryHints</code> annotation) that are <strong>required</strong> in order to make MySQL process the result set row-by-row.  Does anyone know for sure what (if anything) is required for PostgreSQL?</p>
  
  <p>Here is the reference query definition in the repository for MySQL:</p>
  
  <pre><code>@QueryHints(value = @QueryHint(name = HINT_FETCH_SIZE, value = "" + Integer.MIN_VALUE))
  @Query(value = "select t from Todo t")
  Stream&lt;Todo&gt; streamAll();
  </code></pre>