postgresql « Fetch « JPA Q&A





1. Query.setFetchSize seems not work for PostgreSQL    forum.hibernate.org

I am using pg74.216.jdbc3.jar driver to access PostgreSQL db. I try to select all records in a table which has 100,000 records to inspect the performance with setFetchSize() mechanism. My code like this: Code: public static void pagingSelect(int fetchSize, int displayCount){ Session session = ConnectionBean.getCurrentSession(); Query query = session.createQuery("from Customer"); query.setFetchSize(fetchSize); ...