Re: Slow query

On Mon, Oct 27, 2003 at 12:08:31AM +0200, Yonatan Goraly wrote:
> I have a query that uses the same view 6 times. It seems that the
> database engine is calculating the view each time.
> The result is very poor performance. The same query takes 2 sec with MS
> SQL, and more than 10 sec with PostgreSQL.
> Is there a method to improve the performance besides merging the
> components of the view into one table?

Say, have you ANALYZEd your tables ?

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Coge la flor que hoy nace alegre, ufana. ¿Quién sabe si nacera otra mañana?"