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
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 |
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 |