| From: | "Harald Armin Massa" <haraldarminmassa(at)gmail(dot)com> |
|---|---|
| To: | "Bill Moran" <wmoran(at)potentialtech(dot)com> |
| Cc: | "Ranieri Mazili" <ranieri(dot)oliveira(at)terra(dot)com(dot)br>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Tunning PostgreSQL performance for views on Windows |
| Date: | 2007-07-26 15:17:03 |
| Message-ID: | 7be3f35d0707260817h7c9eb639hc2979cb452321418@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
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!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bekar Bartaia | 2007-07-26 16:48:20 | The database slows down after a few weeks |
| Previous Message | Bill Moran | 2007-07-26 14:49:05 | Re: Tunning PostgreSQL performance for views on Windows |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dmitry Ruban | 2007-07-27 00:59:38 | unique index on fields with possible null values |
| Previous Message | Stephan Szabo | 2007-07-26 15:00:59 | Re: How to cast, if type has spaces in the name |