Обсуждение: 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

hi all,
 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?

Thanking in advance
Reagards
nanti

Creating indexes is well documented. There some specific recommendations that depend what you need indexes for, but first ensure you know the basics for creating an index.  Note that knowing how to RTFM is an important skill for developers...

I know the package that comes with Fedora includes documentation, so you might have documentation already on your machine.

Also it is best to say what operating system and what version of Postgres you are using.


Cheers,
Gavin