Want a routine vacuum for postgres

From: Richa Rathore <richayuvasoft161(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Want a routine vacuum for postgres
Date: 2016-09-08 07:35:09
Message-ID: CADu_f8rg8MSXSuGvoA58RbcQAvAGqWAwiQ_tDTdNSqxrcCnhww@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

hello,

As i can see when i am running some process so it is creating the file in
/usr/local/pgsql/data/base/16385/22596 which are more then 50mb . it was
doing my memory and cpu full. so can you please suggest me what will be the
better option for creating the space in memory. it is in digital ocean and
when i run VACUUM FULL command it deleted whole my data so can you help me
for routine maintain of pg data without disturbing my important data.
Thanks in advance

*Thanks & Regards,*
*Richa*
* RathoreYuvaSoft Solutions Pvt. Ltd.*

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message abcz2.uprola 2016-09-08 08:19:53 BUG #14315: pg_dump --no-tablespaces doesn't do it's job when --create specified
Previous Message 阎兆珣 2016-09-08 01:04:18 Re:Re: [BUGS] language code incompatibility in Windows