Re: Fwd: Regarding change in the size of database

Harish,
I am only 8 months into Postgres. I still have much to learn. Hopefully
somebody with more experience can answer your question.
Regards,
Mike

On Wed, Nov 2, 2016 at 10:26 AM, harish Reddy <harishr536(at)gmail(dot)com> wrote:

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