Thread: Index creation in postgresql
hi all,<br /> I am newbee in Postgresql.As a part of an assignment I need to create indexes for certain set of queries andevaluate its performance.<br />Can u guys throw some light in this?<br /><br />Thanking in advance<br />Reagards<br />nanti<br />
nadeesh t v wrote: > I am newbee in Postgresql.As a part of an assignment I need to > create indexes for certain set of queries and evaluate its > performance. > Can u guys throw some light in this? This is the wrong list for this question. I recommend you read up on indexes and make some attempts at solving the problem yourself. If you can't reach the level of performance you expect, try to present a more specific question to pgsql-novice (if it is about how indexes in PostgreSQL work in general) or pgsql-performance (if you can't understand why a particular attempt to solve the problem is not performing as well as you think it should. http://www.postgresql.org/docs/current/static/sql-createindex.html http://www.postgresql.org/docs/current/static/indexes.html http://wiki.postgresql.org/wiki/SlowQueryQuestions -Kevin
<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 />