Re: [PERFORM] PostgreSQL+Hibernate Performance

2008-08-21 Thread Kranti K K Parisa™
Hi Mark, Thanks again for the info. I shall create diff sets of indexes and see the query execution time. And one of such tables might get around 700,000 records over a period of 4-5 months. So what kind of other measures I need to focus on. I thought of the following 1) Indexes 2) Better Hardware

Re: [PERFORM] PostgreSQL+Hibernate Performance

2008-08-21 Thread Mark Lewis
On Thu, 2008-08-21 at 12:33 +0530, Kranti K K Parisa™ wrote: > On Wed, Aug 20, 2008 at 8:54 PM, Matthew Wakeling > <[EMAIL PROTECTED]> wrote: > On Wed, 20 Aug 2008, Kranti K K Parisa™ wrote: > creating multiple indexes on same column will effect > performanc

Re: [PERFORM] PostgreSQL+Hibernate Performance

2008-08-21 Thread Kranti K K Parisa™
Thanks Matthew, does that mean i can just have index1, index3, index4? On Wed, Aug 20, 2008 at 8:54 PM, Matthew Wakeling <[EMAIL PROTECTED]>wrote: > On Wed, 20 Aug 2008, Kranti K K Parisa™ wrote: > >> creating multiple indexes on same column will effect performance? >> for example: >> >> index1

Re: [PERFORM] PostgreSQL+Hibernate Performance

2008-08-21 Thread Kranti K K Parisa™
Thanks Mark, We are using DBCP and i found something about pgpool in some forum threads, which gave me queries on it. But I am clear now. On Wed, Aug 20, 2008 at 8:59 PM, Mark Lewis <[EMAIL PROTECTED]> wrote: > Yes, we use connection pooling. As I recall Hibernate ships with c3p0 > connection p

Re: [PERFORM] PostgreSQL+Hibernate Performance

2008-08-20 Thread Mark Lewis
Yes, we use connection pooling. As I recall Hibernate ships with c3p0 connection pooling built-in, which is what we use. We were happy enough with c3p0 that we ended up moving our other non-hibernate apps over to it, away from DBCP. pgpool does connection pooling at a socket level instead of in

Re: [PERFORM] PostgreSQL+Hibernate Performance

2008-08-20 Thread Mark Lewis
The tradeoffs for multiple indexes are more or less as follows: 1. Having the right indexes makes queries faster, often dramatically so. 2. But more indexes makes inserts/updates slower, although generally not dramatically slower. 3. Each index requires disk space. With several indexes, you can

Re: [PERFORM] PostgreSQL+Hibernate Performance

2008-08-20 Thread Matthew Wakeling
On Wed, 20 Aug 2008, Kranti K K Parisa™ wrote: creating multiple indexes on same column will effect performance?  for example: index1 : column1, column2, column3 index2: column1 index3: column2, index4: column3 index5: column1,column2 The sole purpose of indexes is to affect performance. Howe

Re: [PERFORM] PostgreSQL+Hibernate Performance

2008-08-20 Thread Kranti K K Parisa™
creating multiple indexes on same column will effect performance? for example: index1 : column1, column2, column3 index2: column1 index3: column2, index4: column3 index5: column1,column2 which means, i am trying fire the SQL queries keeping columns in the where conditions. and the possibilities

Re: [PERFORM] PostgreSQL+Hibernate Performance

2008-08-20 Thread Nikolas Everett
The only thing thats bitten me about hibernate + postgres is that when inserting into partitioned tables, postgres does not reply with the number of rows that hibernate expected. My current (not great) solution is to define a specific SQLInsert annotation and tell it not to do any checking like so

Re: [PERFORM] PostgreSQL+Hibernate Performance

2008-08-20 Thread Kranti K K Parisa™
Hi Mark, Thank you very much for the information. I will analyse the DB structure and create indexes on PG directly. Are you using any connection pooling like DBCP? or PG POOL? Regards, KP On Wed, Aug 20, 2008 at 8:05 PM, Mark Lewis <[EMAIL PROTECTED]> wrote: > On Wed, 2008-08-20 at 17:55 +053

Re: [PERFORM] PostgreSQL+Hibernate Performance

2008-08-20 Thread Mark Lewis
On Wed, 2008-08-20 at 17:55 +0530, Kranti K K Parisa™ wrote: > 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 t

[PERFORM] PostgreSQL+Hibernate Performance

2008-08-20 Thread Kranti K K Parisa™
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