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

Re: Bug #809: View not using index

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: <pjw(at)rhyme(dot)com(dot)au>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Bug #809: View not using index
Date: 2002-11-01 02:03:12
Message-ID: 20021031180112.C49388-100000@megazone23.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Thu, 31 Oct 2002 pgsql-bugs(at)postgresql(dot)org wrote:

> Philip Warner (pjw(at)rhyme(dot)com(dot)au) reports a bug with a severity of 2
> The lower the number the more severe it is.
>
> Short Description
> View not using index
>
> Long Description

> It seems that a UNION view fails to use underlying table indexes. This
> is a major pain when using subclassed tables which are updated
> frquently - even if the underlying tables are vacuumued regularly, the
> seq scan can take a very long time.

Reasonably current 7.3 beta sources show it doing an index scan for a
sequence like the below on t1.




In response to

Responses

pgsql-bugs by date

Next:From: Philip WarnerDate: 2002-11-01 02:14:51
Subject: Re: Bug #809: View not using index
Previous:From: pgsql-bugsDate: 2002-11-01 01:40:52
Subject: Bug #809: View not using index

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