[GENERAL] Slow query in 8.2.0

Hi all, 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: 8.2.0 ciencias=# explain analyze SELECT registro_id FROM vregacd.registro_trayectoria WHERE cuenta = '086521071' AND grupo_id = '160940';

Re: [GENERAL] 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?

Re: [GENERAL] Slow query in 8.2.0

Tom Lane [EMAIL PROTECTED] writes: 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 ... Oh well, you are indeed right, I went through the whole view hierarchy and

Re: [GENERAL] Slow query in 8.2.0

Manuel Sugawara masm@fciencias.unam.mx writes: Tom Lane [EMAIL PROTECTED] writes: 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 ... Just out of curiosity, why the