Index creation in postgresql

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

On 29/10/12 06:22, nadeesh t v wrote:

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

Go to the web site and search for the documentation, it is not hard to find.

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