Alvaro Herrera wrote:
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 ?
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
