Re: Fwd: Regarding change in the size of database

Hi Michael sir,

Firstly Thank you so much for your explanation, Sir my request is that
could you suggest us the best postgres config parameters to set for my
instance which will work around 60 concurrent users and my above problem as
solved by upgrading my postgres from 9.1 to 9.3 and restored our backup so
my db size had its original now.
So sir as am one of a new developer could u suggest what would be the best
parameters to set and how to tune my postgres database performance?
Is there any tool to record my stastics? And any tool for optimizing the
queries ?
Thanks and Regards
Harish Reddy

On Oct 28, 2016 5:10 AM, "Michael Moore" <michaeljmoore(at)gmail(dot)com> wrote:

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