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

Re: why sequential scan is used on indexed column ???

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgus-general(at)postgresql(dot)org
Cc: Julius Tuskenis <julius(dot)tuskenis(at)gmail(dot)com>
Subject: Re: why sequential scan is used on indexed column ???
Date: 2008-06-15 20:33:16
Message-ID: 200806151333.16798.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgus-general
Julius,

> I have a question concerning performance. One of my queries take a long
> to execute. I tried to do "explain analyse" and I see that the
> sequential scan is being used, although I have indexes set on columns
> that are used in joins. The question is - WHY, and how to change that
> behavior???

This is not the right mailing list for your question.  Please send it to 
pgsql-performance mailing list instead.

-- 
Josh Berkus
PostgreSQL @ Sun
San Francisco

In response to

pgus-general by date

Next:From: Joshua D. DrakeDate: 2008-06-16 17:58:22
Subject: Re: Draft bylaws are now available
Previous:From: Julius TuskenisDate: 2008-06-14 14:41:20
Subject: why sequential scan is used on indexed column ???

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