Skip site navigation (1) Skip section navigation (2)

Re: Select query takes long to execute

From: SZUCS Gábor <surrano(at)mailbox(dot)hu>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Select query takes long to execute
Date: 2003-05-30 08:57:33
Message-ID: 001c01c32689$82da1050$0403a8c0@fejleszt4 (view raw or flat)
Thread:
Lists: pgsql-performance
Nikolaus,

I think that shouldn't be any more effective. As I experienced, it's
irrelevant how many cols an index has as long as you only use the first
column. And, after that, if you use another column, how could a missing
second column be any better?

G.
------------------------------- cut here -------------------------------
----- Original Message ----- 
From: "Nikolaus Dilger" <nikolaus(at)dilger(dot)cc>
Sent: Friday, May 30, 2003 4:44 AM


> Kevin,
>
> How about creating a new index just on column6?
> That should be much more effective than the multicolumn
> index.
>
> Regards,
> Nikolaus



In response to

Responses

pgsql-performance by date

Next:From: Peter ChildsDate: 2003-05-30 09:21:51
Subject: Re: db growing out of proportion
Previous:From: Tomas SzepeDate: 2003-05-30 07:24:42
Subject: Re: db growing out of proportion

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group