Re: Tunning PostgreSQL performance for views on Windows

["Harald Armin Massa" <haraldarminmassa@xxxxxxxxx>]

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!