Asif:
1. 6GB is pretty small once you work through the issues, adding RAM
will probably be a good investment, depending on your time-working set
curve.
A quick rule of thumb is this:
- if your cache hit ratio is significantly larger than (cache size / db
size) then there is locality of refe
On Tue, Nov 27, 2012 at 12:47 AM, Syed Asif Tanveer
wrote:
> Hi,
>
>
>
> I am using PostgreSQL 9.1.5 for Data warehousing and OLAP puposes. Data size
> is around 100 GB and I have tuned my PostgreSQL accordingly still I am
> facing performance issues. The query performance is too low despite table
On 11/27/2012 02:47 AM, Syed Asif Tanveer wrote:
Hi,
I am using PostgreSQL 9.1.5 for Data warehousing and OLAP puposes.
Data size is around 100 GB and I have tuned my PostgreSQL accordingly
still I am facing performance issues. The query performance is too low
despite tables being properly
On 27.11.2012 09:47, Syed Asif Tanveer wrote:
I am using PostgreSQL 9.1.5 for Data warehousing and OLAP puposes. Data size
is around 100 GB and I have tuned my PostgreSQL accordingly still I am
facing performance issues. The query performance is too low despite tables
being properly indexed and a
