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 for your example. The "raise notice" is a good debugging
idea. I will post again if the problem comes back and I can construct a
repeatable test case.
Regards,
--Phil.