Hi Tom,
Thanks for writing. On Saturday I had a query that took 3000 ms but
reduced to only 1200 ms when I took out the date formatting functions
from the views. Now it takes only 700 ms with or without the functions.
Perhaps an ANALYZE in the meantime has changed everything.
Anyway, thanks
Phil Endecott <[EMAIL PROTECTED]> writes:
> Instead it looks as if the functions are applied to every row, i.e. V is
> completely built, and then the one row is selected.
This would depend very largely on the details of V and on the details of
the calling query ... not to mention which Postgres v