postgresql « Performance « JPA Q&A

1. Performance and Postgresql

Newbie Joined: Mon Oct 25, 2004 4:34 pm Posts: 6 Hibernate version: 2.1.6 Code between sessionFactory.openSession() and session.close(): Code: private static void runHQL(int runs) { Session s = null; LongType lt = new LongType(); ...

2. Blob performance faster on postgresql/mysql than oracle

No, we test only with one user but it's not a reason to not use a database. We need to use a database because with manage version and later we will be multi-user. You think, it's just the superiority of the locking mechanism, maybe you are right. I was thinking, it's due to the implementation of the jdbc driver processing blob ...

3. Hibernate+PostgreSQL Performance Issues

Hi, Can anyone suggest the performance tips for PostgreSQL using Hibernate. One of the queries: - PostgreSQL has INDEX concept and Hibernate also has Column INDEXes. Which is better among them? or creating either of them is enough? or need to create both of them? and any more performace aspects ? Thanks in advance. == KP