JDBC Query Postgres Process in subsets

[Romeu Carvalho]

Hi all.

I'm connecting to a Postgres DB using the official driver.

I have a process that make a query that will return big amounts of data, so I'm using the process in subsets feature.

The problem is that the first time that it queries the DB it takes a huge amount of time/memory (the same as if I'm not using subsets).

I tried the same using a Oracle DB and it works fine and as expected.

Did anyone faced this problem

Is there any known issue with using postrges driver

Any workaround

Thank you all.

Best Regards