pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Dennis <dennis@zserve.com>
To: pgsql-sql@postgresql.org
Subject: Multiple Indexes
Date: Mon, 2 Jul 2001 09:36:15 -0600
Message-ID: <9hq4dh$13a$1@news.tht.net> (raw)

Hi Group,

Lets say table a has fields: id serial, name varchar(20) not null, and 
somedata int not null.

I'll be doing lots of queries on this table so I'll want to define and 
index. ( or two? ).

Some queries will only look up the name.  Others will look up the name 
depending on somedata.

If I were to define and index like this:

1) create index i on sometable ( name, somedata );

and another one like this:

2) create index i2 on sometable ( name );

Would that be better than defining only the first index?

What I am asking is:

Should I have an index devoted to just the name field, or 
would that first index work just fine?  I know that more indexes
means slower time on inserts.

Any suggestions appreciated.

-Dennis



Message-ID: <9hq4dh$13a$1@news.tht.net>
Permalink:  ../9hq4dh$13a$1@news.tht.net/
Also on:    postgresql.org/message-id/9hq4dh$13a$1@news.tht.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: dennis@zserve.com
  Subject: Re: Multiple Indexes
  In-Reply-To: <9hq4dh$13a$1@news.tht.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox