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
pgsql-bugs by date
|Next:||From: Philip Warner||Date: 2002-11-01 02:14:51|
|Subject: Re: Bug #809: View not using index|
|Previous:||From: pgsql-bugs||Date: 2002-11-01 01:40:52|
|Subject: Bug #809: View not using index|