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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
