Re: [GENERAL] select off of a view going slowly

2001-05-07 Thread Tom Lane
Fran Fabrizio <[EMAIL PROTECTED]> writes: > Does a view run its query every time I select from the view? Yes. That's sort of the point. > View definition: SELECT count(*) AS count, log.site_id, log.host_id FROM log > WHERE (((log.status = 'CRIT'::"varchar") OR (log.status = 'EMERG'::"varchar"))

Re: [GENERAL] select off of a view going slowly

2001-05-07 Thread Fran Fabrizio
Hello all, I've finished upgrading to 7.1 and I'm still having trouble getting this view to run respectably. Does a view run its query every time I select from the view? I had been assuming that the view recreates itself when I modify the table to which the view is attached, but Tom mentioned t