title: Gradually slow read in Netezza from Java
body: <p>I'm doing fetch from one table from Netezza, by java code with 4 threads( runs overnight).
  At start it takes approximately 7seconds, but gradually this average time increases 200 seconds over 24 hours.
  I've double checked if it is network issue or someone else's query causing slow down. So its only my program working on this database. 
  Any idea why?</p>
  
  <p>Query is select statement:
  <code>select col1,col2 from tab where id >? and id&lt; ?</code>
  Everytime this same query runs with different inputs provided from java code.
  Table contains around 150,000,000 records.
  Though input changes result are fetched in same batchsize.</p>
  
  <p>For example,
  if first query is <code>select col1,col2 from tab where id >1 and id&lt; 100</code>
  <br>
  next will be <code>select col1,col2 from tab where id >201 and id&lt; 300</code>
  <br>keeping records fetch of 100(in this example).</p>
  
  <p>I use Jdbctemplete to execute these queries, which use connections from Pool I believe.</p>