I have a view which is very slow to computer, but doesn't change often.
I'd like to materialize it. I thought I'd do a simple poor man's materialize by:
1) ALTER VIEW myview RENAME to _myview
2) SELECT * INTO myview FROM _myview
The only problem is that all my other views, which are dependent on
myview, automatically rename to _myview. That would normally be very
helpful but is exactly the opposite of what I want!
Is there a work around?
I'm running Postgres 8.3 - upgrading is a possibility but difficult.