Dann Corbit kirjutas T, 16.12.2003 kell 12:40: > I suspect if you do "explain" against the SQL of the view, the answer > will be apparent. > > Donning my "Karnak the magnificent hat {borrowed from Johnny Carson}": > You are missing an index. > > For the best help, post the SQL of your view, and also the Schema > definition for the tables involved.
Also, the best place for asking about performance is the pgsql-performance list :) ------------ Hannu ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html