From: Harald Armin Massa <haraldarminmassa@gmail.com>
To: Bill Moran <wmoran@potentialtech.com>
Cc: Ranieri Mazili <ranieri.oliveira@terra.com.br>
Cc: pgsql-general@postgresql.org
Subject: Re: Tunning PostgreSQL performance for views on Windows
Date: Thu, 26 Jul 2007 17:17:03 +0200
Message-ID: <7be3f35d0707260817h7c9eb639hc2979cb452321418@mail.gmail.com> (raw)
In-Reply-To: <20070726104905.e7980368.wmoran@potentialtech.com>
References: <46A8AF1B.4090607@terra.com.br>
<20070726104905.e7980368.wmoran@potentialtech.com>
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!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: haraldarminmassa@gmail.com, wmoran@potentialtech.com, ranieri.oliveira@terra.com.br, pgsql-general@postgresql.org
Subject: Re: Tunning PostgreSQL performance for views on Windows
In-Reply-To: <7be3f35d0707260817h7c9eb639hc2979cb452321418@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox