Re: joining views

Tomasz Myrta <jasiek@klaster.net> writes:
> I'd like to split queries into views, but I can't join them - planner
> search all of records instead of using index. It works very slow.

I think this is the same issue that Stephan identified in his response
to your other posting ("sub-select with aggregate").  When you write
    FROM x join y using (col) WHERE x.col = const
the WHERE-restriction is only applied to x.  I'm afraid you'll need
to write
    FROM x join y using (col) WHERE x.col = const AND y.col = const
Ideally you should be able to write just
    FROM x join y using (col) WHERE col = const
but I think that will be taken the same as "x.col = const" :-(

            regards, tom lane