From: | Szymon Guz <mabewlun(at)gmail(dot)com> |
---|---|
To: | Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Cannot Achieve Performance |
Date: | 2010-12-10 11:28:45 |
Message-ID: | AANLkTinapjUcEKmE7uynCFs6zbNZxchtvxbRW1t8D9Zr@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 10 December 2010 12:28, Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com> wrote:
> Dear all,
>
> Performance tuning is what, which all i sured to achieve in pgsql. I am
> currently testing on 5 GB table with select operation that takes about
> 229477 ms ( 3.82 minutes ) with simple configuration.
>
> I have 4 GB RAM. So I change some parameters such as shared_buffers to
> 512 MB , effective cache size to 1024 MB and my separate log directory.
>
> Would this is sufficient or I need something else to be changed.
>
> But my output after changing these parameters is not what I am expecting of
> , it is 229971 ms ( 3.81 minutes ). Please help.
>
> Waiting for some pointers until I am googling.
>
> Thanks & Regards
>
> Adarsh Sharma
>
>
>
>
show us explain and explain analyze of this query, maybe the problem is not
in the memory settings
regards
Szymon
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Kellerer | 2010-12-10 11:33:53 | Re: A cronjob for copying a table from Oracle |
Previous Message | Adarsh Sharma | 2010-12-10 11:28:44 | Cannot Achieve Performance |