title: Query parallelization for single connection in Postgres
body: <p>I am aware that multiple connections use multiple CPU cores in postgres and hence run in parallel.But when I execute a long running query say 30 seconds(Let's assume that this cannot be optimized further), the I/O is blocked and it does not run any other query from the same client/connection.</p>
  
  <p>Is this by design or can it be improved ?</p>
  
  <p>So I am assuming that the best way to run long running queries is to get a new connection or not to run any other query in the same connection until that query is complete ?</p>