Alex,
> please do 'explain select * from yourview'
I can't figure out how to get Explain to output to a file instead of the
screen. Embarassing, I know, but the command seems to subbornly resist
all command-line re-direction.
>
> also make sure all tables are vacuumed
They are.
-Josh
