Re: Table Design question for gurus (without going to "NoSQL")...

From: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
To: Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>
Cc: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Table Design question for gurus (without going to "NoSQL")...
Date: 2011-11-21 01:50:04
Message-ID: CAFWfU=vVPiEXsY_e47HqEpAkBoRv0v-peyDXxcSHK5oz0mBB2w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Nov 21, 2011 at 7:26 AM, Gavin Flower
<GavinFlower(at)archidevsys(dot)co(dot)nz> wrote:

> How about having 2 indexes: one on each of ip & url_md5? Pg will combine the
> indexes as required, or will just use one if that is best.

Thanks Gavin. Question: what if I have a joined index? If from a
joined index I only use the first column (say, "ip") will a joined
index still be used?

It is cleaner to create two indexes for the two columns. Which is recommended?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tomas Vondra 2011-11-21 01:56:54 Re: Installed. Now what?
Previous Message Phoenix Kiula 2011-11-21 01:44:25 Re: Installed. Now what?