Received-SPF: pass (disraeli.terra.com.br: domain of terra.com.br designates
	200.176.10.19 as permitted sender) client-ip=200.176.10.19;
	envelope-from=ranieri.oliveira@terra.com.br; helo=[172.16.2.72];
Message-ID: <46A8AF1B.4090607@terra.com.br>
Date: Thu, 26 Jul 2007 11:26:35 -0300
From: Ranieri Mazili <ranieri.oliveira@terra.com.br>
User-Agent: Thunderbird 2.0.0.5 (Windows/20070716)
MIME-Version: 1.0
To: pgsql-general@postgresql.org,  pgsql-sql@postgresql.org
Subject: Tunning PostgreSQL performance for views on Windows
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hello,

I'm developing a BI and as database it's using postgresql 8.2, how data
are very detailed, I'm creating a view to consolidate the most important
data, but the performance of view is very poor, 1 minute to perform more
or less without where clause.
I need to know how I can increase the performance, if exist some option
to do cache, because the view will change only one time per day.
My configuration is default, without modifications after install.
I'm using windows 2003 server with a dell server with 4GB of memory.

To create the view, I created some functions, and then perform they on
one select like:
select A.field1, B.field2, ... from function_A() A, function_B() B...
Is this the best way to do it?

I appreciate any help.

Thanks