Re: [HACKERS] Disable autovacuum guc?

2016-10-20 Thread Joshua D. Drake
On 10/20/2016 08:54 AM, Josh Berkus wrote: On 10/20/2016 06:34 AM, Joshua D. Drake wrote: On 10/19/2016 07:22 PM, Josh Berkus wrote: On 10/19/2016 06:27 PM, Joshua D. Drake wrote: Hrm, true although that is by far a minority of our users. What if we made it so we disabled the autovacuum guc

Re: [HACKERS] Disable autovacuum guc?

2016-10-20 Thread Josh Berkus
On 10/20/2016 06:34 AM, Joshua D. Drake wrote: > On 10/19/2016 07:22 PM, Josh Berkus wrote: >> On 10/19/2016 06:27 PM, Joshua D. Drake wrote: >>> Hello, >>> >>> After all these years, we are still regularly running into people who >>> say, "performance was bad so we disabled autovacuum". I am not t

Re: [HACKERS] Disable autovacuum guc?

2016-10-20 Thread Joshua D. Drake
On 10/19/2016 07:22 PM, Josh Berkus wrote: On 10/19/2016 06:27 PM, Joshua D. Drake wrote: Hello, After all these years, we are still regularly running into people who say, "performance was bad so we disabled autovacuum". I am not talking about once in a while, it is often. I would like us to co

Re: [HACKERS] Disable autovacuum guc?

2016-10-19 Thread Michael Paquier
On Thu, Oct 20, 2016 at 11:55 AM, Craig Ringer wrote: > On 20 October 2016 at 09:27, Joshua D. Drake wrote: >> 1. It does not hurt anyone > > I disagree. > > It's important for a number of tests, and can be very useful when > doing diagnostic work. It's also important for some kinds of data > rec

Re: [HACKERS] Disable autovacuum guc?

2016-10-19 Thread Craig Ringer
On 20 October 2016 at 09:27, Joshua D. Drake wrote: > Hello, > > After all these years, we are still regularly running into people who say, > "performance was bad so we disabled autovacuum". I am not talking about once > in a while, it is often. I would like us to consider removing the autovacuum

Re: [HACKERS] Disable autovacuum guc?

2016-10-19 Thread Josh Berkus
On 10/19/2016 06:27 PM, Joshua D. Drake wrote: > Hello, > > After all these years, we are still regularly running into people who > say, "performance was bad so we disabled autovacuum". I am not talking > about once in a while, it is often. I would like us to consider removing > the autovacuum opt

[HACKERS] Disable autovacuum guc?

2016-10-19 Thread Joshua D. Drake
Hello, After all these years, we are still regularly running into people who say, "performance was bad so we disabled autovacuum". I am not talking about once in a while, it is often. I would like us to consider removing the autovacuum option. Here are a few reasons: 1. It does not hurt anyo