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
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
are like the above.
if we create such indexes will it effect on performance?
and what is the best go in this case?
On Wed, Aug 20, 2008 at 8:10 PM, Mark Lewis <[EMAIL PROTECTED]> wrote:
> On Wed, 2008-08-20 at 17:55 +0530, Kranti K K Parisa™ wrote:
> > Hi,
> >
>
ry different thing. If your app is
> the only thing talking to this database, and you don't have a
> multi-database configuration, then it will be easier for you to use a
> Java-based connection pooling library like c3p0 or DBCP than to use
> pgpool.
>
> -- Mark
>
>
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 performanc
ti 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
> >
