Tunning PostgreSQL performance for views on Windows

From: Ranieri Mazili <ranieri(dot)oliveira(at)terra(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Tunning PostgreSQL performance for views on Windows
Date: 2007-07-26 14:26:35
Message-ID: 46A8AF1B.4090607@terra.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2007-07-26 14:49:05 Re: Tunning PostgreSQL performance for views on Windows
Previous Message Richard Huxton 2007-07-26 14:04:35 Re: ssl connections to postgresql

Browse pgsql-sql by date

  From Date Subject
Next Message Bill Moran 2007-07-26 14:49:05 Re: Tunning PostgreSQL performance for views on Windows
Previous Message A. Kretschmer 2007-07-26 07:42:53 Re: How to cast, if type has spaces in the name