From: | Michael Moore <michaeljmoore(at)gmail(dot)com> |
---|---|
To: | harish Reddy <harishr536(at)gmail(dot)com> |
Cc: | Jayadevan M <maymala(dot)jayadevan(at)gmail(dot)com>, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Fwd: Regarding change in the size of database |
Date: | 2016-10-27 23:40:38 |
Message-ID: | CACpWLjP8QN7oWZnqZ8LdfKKsdZTNdeqfCOCQTsWbKeEoexLTsg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Read this and I think you will understand what you need to do.
*http://blog.lerner.co.il/in-postgresql-as-in-life-dont-wait-too-long-to-commit/
<http://blog.lerner.co.il/in-postgresql-as-in-life-dont-wait-too-long-to-commit/>*
On Thu, Oct 27, 2016 at 4:23 AM, harish Reddy <harishr536(at)gmail(dot)com> wrote:
>
> Hi Sir,
>
> Thank you for you feedback my postgres is running on 9.1 version and when
> i checked that *autovacuum *in my production by command* ps -axww |
> grep autovacuum *it says the output as it has some process running with
> this id so how to solve my problem but in postgress config file it was
> commented.
>
> My application is an online ERP which is supported by *openbravo* has an
> users of about *150(arount 50 active users)* with it and could you
> suggest me the perfect variables to set us in postgres config file.
>
> The system has a RAM of 16 GB and the following variables
>
> Variable Setting value
> max_connections 200
> shared_buffers 4096MB
> work_mem 24MB
> maintenance_work_mem 512MB
> effective_cache_size 4096MB
>
>
> On Thu, Oct 27, 2016 at 9:04 AM, Jayadevan M <maymala(dot)jayadevan(at)gmail(dot)com>
> wrote:
>
>>
>> On Wed, Oct 26, 2016 at 9:51 PM, harish Reddy <harishr536(at)gmail(dot)com>
>> wrote:
>>
>>> Hi Jayadevan,
>>>
>>> Firstly Thank you so much for your valuable information provided, So
>>> what should i do for increasing my database performance? and could you
>>> suggest me how to continue to the vacuum process and will it decrease my
>>> database performance?
>>>
>>
>> Please read this article
>> https://wiki.postgresql.org/wiki/Guide_to_reporting_problems
>> i.e - "Mention your database version", "A description of what you are
>> trying to achieve and what results you expect" etc etc.
>> And this.
>> https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
>>
>> Do you have autovacuum working?
>> https://www.postgresql.org/docs/current/static/runtime-confi
>> g-autovacuum.html
>>
>>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Moore | 2016-10-31 19:06:43 | PL/pgSQL Audit Utility |
Previous Message | harish Reddy | 2016-10-27 11:23:07 | Re: Fwd: Regarding change in the size of database |