Re: Index creation in postgresql

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