in addition to the good advise of "materialzing the view" as in "create table <whatever> as select * from <viewwhatever>" once a day,
and to provide more information, PLEASE take notice that Good places to start with tuning:
http://www.powerpostgresql.com/PerfList http://www.varlena.com/GeneralBits/Tidbits/perf.html
those performance-recommendations are primarly based on Unix-Systems (Linux, BSD, Solaris). Especially shared buffers have totally different effects on win32. Best wishes, Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned!