Re: Slow query in 8.2.0

Manuel Sugawara <masm@fciencias.unam.mx> writes:
> I have a query that use to work fine in 3 or 4 releases before 8.2 but
> now it's very slow, same database same data set, explain analyze
> follows:

You've omitted all the interesting details --- obviously
registro_trayectoria is a view, but of what?  Please show the table and
view definitions involved.

8.2 is a good bit more conservative than previous releases about
optimizing views involving volatile functions, so I'm wondering whether
that could have anything to do with it ...

            regards, tom lane