Re: Index creation in postgresql - Mailing list pgsql-hackers

From Gavin Flower
Subject Re: Index creation in postgresql
Date
Msg-id 508ED819.1080902@archidevsys.co.nz
Whole thread Raw
In response to Index creation in postgresql  (nadeesh t v <nadeeshtv@gmail.com>)
List pgsql-hackers
<div class="moz-cite-prefix">On 29/10/12 06:22, nadeesh t v wrote:<br /></div><blockquote
cite="mid:CAB7psUOGVKpjc-W=X1KYGRq16caZkK8nTpj50kkyoUFyC-_d+g@mail.gmail.com"type="cite">hi all,<br />  I am newbee in
Postgresql.Asa part of an assignment I need to create  indexes for certain set of queries and evaluate its
performance.<br/> Can u guys throw some light in this?<br /><br /> Thanking in advance<br /> Reagards<br /> nanti<br
/></blockquote>Go to the web site and search for the documentation, it is not hard to find.<br /><p class="western"
style="margin-bottom:0cm">Creating indexes is well documented. There some specific recommendations that depend what you
needindexes for, but first ensure you know the basics for creating an index.  Note that knowing how to RTFM is an
importantskill for developers...<br /><br /> I know the package that comes with Fedora includes documentation, so you
mighthave documentation already on your machine.<br /><br /> Also it is best to say what operating system and what
versionof Postgres you are using.<br /><br /><br /> Cheers,<br /> Gavin<br /><br /> 

pgsql-hackers by date:

Previous
From: Cédric Villemain
Date:
Subject: Re: [PATCH] Prefetch index pages for B-Tree index scans
Next
From: Claudio Freire
Date:
Subject: Re: [PATCH] Prefetch index pages for B-Tree index scans