Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 41E1964FCDE
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 20 Aug 2008 09:26:25 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 18396-02 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 20 Aug 2008 09:25:45 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from ti-out-0910.google.com (ti-out-0910.google.com
 [209.85.142.190])
	by postgresql.org (Postfix) with ESMTP id A30B364FD0F
	for <pgsql-performance@postgresql.org>;
	Wed, 20 Aug 2008 09:25:19 -0300 (ADT)
Received: by ti-out-0910.google.com with SMTP id y8so330673tia.5
	for <pgsql-performance@postgresql.org>;
	Wed, 20 Aug 2008 05:25:16 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:mime-version:content-type;
	bh=pUddJrYn3L6zKKhL/bPg6c+UFl+RmMIcGPi+sQPC4ZU=;
	b=A/a/yEJTPQ5GgXueQnsAxiggM4F78V3Cfb+Wcu9/FAOhwA1msOJG9QFuAA3bpdX3iy
	sNj4euAWUGilXOS6br4/aQPwWnyd87bflkgMcFk61Nsbaj3p/+2GHbKtiIbTVZzZPMJl
	XY7g1RiQlBr2PpqEdAIILSOFLeOleqjiPhV/o=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:mime-version:content-type;
	b=ueKUT0/JpBbxqdiOCFveKIMKfWRWbnFEKHUOO2Ea6NkhQkXs2DZv3Tb59JteBZweKZ
	HqFkze3s6slsxPZbsmJfRSkE/l1EyVv+M01BdXk8BFdV5XfzFYUvFPLZG4HQ4ED9dzc9
	SNZ/rAysvD8UO/V1utTlx0e7goyeXxAbFGHVM=
Received: by 10.110.109.12 with SMTP id h12mr8184tic.51.1219235116622;
	Wed, 20 Aug 2008 05:25:16 -0700 (PDT)
Received: by 10.110.8.20 with HTTP; Wed, 20 Aug 2008 05:25:16 -0700 (PDT)
Message-ID: <4478b4ac0808200525ia6eabe8q886ac7fbba53ff05@mail.gmail.com>
Date: Wed, 20 Aug 2008 17:55:16 +0530
From: "=?WINDOWS-1252?Q?Kranti_K_K_Parisa=99?=" <kranti.parisa@gmail.com>
To: pgsql-performance@postgresql.org
Subject: PostgreSQL+Hibernate Performance
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_84055_15972377.1219235116622"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200808/214
X-Sequence-Number: 31095

------=_Part_84055_15972377.1219235116622
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_84055_15972377.1219235116622
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div dir="ltr">Hi,<br><br>Can anyone suggest the performance tips for PostgreSQL using Hibernate.<br><br>One of the queries:<br><br>- 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?<br>
<br>and any more performace aspects ?<br><br>Thanks in advance.<br clear="all"><br>==<br>KP<br> <br>
</div>

------=_Part_84055_15972377.1219235116622--