Thread: manual and autovacuum
Hi all,
I am working on a postgresql performance tuning tool for my project. Having done a lot of research and googling for manual and autovacuum parameters ,I have met a dead end. Could you tell me what are the recommended value for all the manual and autovacuum parameters.
I am looking for actual value. And please if you mention the database condition along with the recommendation ,it will be helpfull.
Thankyou and Regards.
On Sat, Feb 1, 2014 at 9:20 AM, prashant Pandey <prashantpandeyfun10@gmail.com> wrote: > I am looking for actual value. And please if you mention the database > condition along with the recommendation ,it will be helpfull. Maybe the question has to be reversed: what is the condition you are aiming at optimizing? Luca
Thankyou for your reply. I just want to know that what are the strting recommended value for the vacuum parameters. As in what values are unacceptable and cause problems to our database and which values will work for a normal database
Regards.
On 1 Feb 2014 15:15, "Luca Ferrari" <fluca1978@infinito.it> wrote:
On Sat, Feb 1, 2014 at 9:20 AM, prashant Pandey
<prashantpandeyfun10@gmail.com> wrote:
> I am looking for actual value. And please if you mention the database
> condition along with the recommendation ,it will be helpfull.
Maybe the question has to be reversed: what is the condition you are
aiming at optimizing?
Luca
On Sat, Feb 1, 2014 at 2:16 PM, prashant Pandey <prashantpandeyfun10@gmail.com> wrote: > Thankyou for your reply. I just want to know that what are the strting > recommended value for the vacuum parameters. The defaults values. Or at least, I will trust such values as good starting values. > As in what values are > unacceptable and cause problems to our database and which values will work > for a normal database Optimizing vacuum and autovacuum sounds to me like a very complex job, in particular because there are no "normal" databases. Each database/cluster has different needs and behavior, so I guess the only chance is to focus on the main needs you want to achieve (throughput, cpu utilization, disk spped, etc.) and work on that adjusting related autovaccum parameters (that is parameters can work against your aim). In short: I believe there no one answer to you question. Luca