Re: Premature view materialization in 8.2?

From: Tom Lane
Subject: Re: Premature view materialization in 8.2?
Date: ,
Msg-id: 15399.1175882434@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: Re: Premature view materialization in 8.2?  ("Jonathan Ellis")
Responses: Re: Premature view materialization in 8.2?  ("Jonathan Ellis")
List: pgsql-performance

Tree view

Premature view materialization in 8.2?  ("Jonathan Ellis", )
 Re: Premature view materialization in 8.2?  (Tom Lane, )
  Re: Premature view materialization in 8.2?  ("Jonathan Ellis", )
   Re: Premature view materialization in 8.2?  (Tom Lane, )
    Re: Premature view materialization in 8.2?  ("Jonathan Ellis", )
     Re: Premature view materialization in 8.2?  (Tom Lane, )
      Re: Premature view materialization in 8.2?  ("Jonathan Ellis", )
       Re: Premature view materialization in 8.2?  (Tom Lane, )
        Re: Premature view materialization in 8.2?  ("Jonathan Ellis", )
         Re: Premature view materialization in 8.2?  (Tom Lane, )
          Re: Premature view materialization in 8.2?  ("Jonathan Ellis", )

"Jonathan Ellis" <> writes:
> I can do that...  you don't think the fact I mentioned, that
> redefining the view to leave out the expensive function fixes the
> problem, is relevant?

Hm, I'd not have thought that an expensive function would get evaluated
partway up the join tree, but maybe that's wrong.  You never did show
us the actual view definition ...

            regards, tom lane


pgsql-performance by date:

From: Mark Kirkwood
Date:
Subject: Re: SCSI vs SATA
From: Bruce Momjian
Date:
Subject: Re: SCSI vs SATA