Re: : Postgres IX - Mailing list pgsql-general

From Shaun Clements
Subject Re: : Postgres IX
Date
Msg-id 100F78F2B203444BB161BBA7077FF6131CD9D4@srldbexc003.relyant.co.za
Whole thread Raw
In response to : Postgres IX  (Shaun Clements <ShaunC@relyant.co.za>)
Responses Re: : Postgres IX  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Or better yet.
Can anyone explain the use of indexing, effecting the performance of select query, using INDEXED columns, and non indexed columns.
 
I.E.
 
Select from table where column1 = 'xxxx' and column2 = 'xxxxx'
 
WHERE COLUMN1 is indexed, and COLUMN2 isnt.
 
Thanks in advance
 
A {FONT-FAMILY: verdana; TEXT-DECORATION: none } A:active {COLOR: #ff0000; FONT-FAMILY: verdana; TEXT-DECORATION: none } A:link {COLOR: #003366; FONT-FAMILY: verdana; TEXT-DECORATION: none } A:visited {COLOR: #003366; FONT-FAMILY: verdana; TEXT-DECORATION: none } A:hover {COLOR: #ff0000; FONT-FAMILY: verdana; TEXT-DECORATION: underline } .small_text {FONT-SIZE: 9px; COLOR: #003366; FONT-FAMILY: verdana } Kind Regards,
Shaun Clements
 

pgsql-general by date:

Previous
From: "Philippe Lang"
Date:
Subject: PL/PERL with composite return values & PGSQL 7.4?
Next
From: Richard Huxton
Date:
Subject: Re: : Postgres IX