Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f3Kw4-0005ga-V7 for pgsql-admin@arkaria.postgresql.org; Tue, 03 Apr 2018 12:21:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1f3Kw3-0006ko-L7 for pgsql-admin@arkaria.postgresql.org; Tue, 03 Apr 2018 12:21:11 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f3Kw3-0006kf-81 for pgsql-admin@lists.postgresql.org; Tue, 03 Apr 2018 12:21:11 +0000 Received: from mail-ot0-x242.google.com ([2607:f8b0:4003:c0f::242]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1f3Kw0-0006Se-LX for pgsql-admin@lists.postgresql.org; Tue, 03 Apr 2018 12:21:09 +0000 Received: by mail-ot0-x242.google.com with SMTP id h26-v6so19084008otj.12 for ; Tue, 03 Apr 2018 05:21:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-transfer-encoding:content-language; bh=R8QV79asIkxbedmvy0daFOFlKq+PNw1cirz9Yr4FXEA=; b=f5NY+LD7PDuEjAICfJ6dUSoh9PPRSkBzS0Fe78uGMqOakns6hqxkqOL46Tp/1dA0EY DcxAfUcsFck8WwaEUZX7s9v1Wxrb+OpUiYSnFZ5zn2ubeYSOaiMnOtc8H2lzFidTrqnQ bhEuiYZTcjNt3SwLnw4k1zRRkDf4Qrc7DorPhSu5CpoB++cCZ8zKXkPnUttwMhlxHgX4 EFC6+f7otYejMVtfMNLYMp6q8eMLSwqiXlhKoDlDTY6yuHujfJkKOXiONnVA0LpLUTFX MKWumzfuu5xEirnXW83o7u6PVlv05lLoYnlvuXouFUlQqgaI+A0eKGKQI5kYkMUJs0pA S0pg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=R8QV79asIkxbedmvy0daFOFlKq+PNw1cirz9Yr4FXEA=; b=EpcTwIL4qLqf4SStOlQqa8ptBInn4KIUSKPtkKM6MTf5r3/3Hr0ZPzIkVFFtk8LQmz 8Wqdw9EqF5K05/1zqwsbvzHqx//MNyux+WN3yUxlQQtdeXgwgNexKyN+6vE7t40QicYH /qd43mT691br3hlToAjBidOf4Ri8M8MpSdMfeP5gl12fGmGDZox3yZbGV7HaRW/ljY25 FTruBQCptWrrdJFpK7Lc2q8ZbojlTWi4dGC8QZ5Tj7J0rXNlF4Ywk2BOc4YkMcbV6PnU D8pnNde2hgEp0BaK8RStcydaEfdBetSr9aNYVyUFEaQIXelUV5Em4/Kv+pvdUD51Kxjb GdOg== X-Gm-Message-State: ALQs6tBr84qmfjwNE+HVtDXnYwLTLv/I6nFcTUbyU3sgtHSmmuB9iyuo kndqUDmAqcyorrKMmqSXcvPRig== X-Google-Smtp-Source: AIpwx4/8cs+wQwC7wV62gGbUZBBqQ9aSZzZAABu//0bwVZBb5NvyUGnxbtbgsior4qIYp0pN0xFk8g== X-Received: by 2002:a9d:26d4:: with SMTP id i20-v6mr7343750otd.214.1522758067312; Tue, 03 Apr 2018 05:21:07 -0700 (PDT) Received: from [192.168.1.10] (ip70-171-116-89.no.no.cox.net. [70.171.116.89]) by smtp.googlemail.com with ESMTPSA id b65-v6sm1357878oia.48.2018.04.03.05.21.06 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 03 Apr 2018 05:21:06 -0700 (PDT) Subject: Re: autovacuum on system catalog To: pgsql-admin@lists.postgresql.org References: From: Ron Message-ID: <91729b69-31bf-24e3-6103-255b92f79333@gmail.com> Date: Tue, 3 Apr 2018 07:21:05 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.6.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 04/03/2018 07:16 AM, Artem Tomyuk wrote: > Hi. > > Why its not possible to set autovacuum settings on pg_attribute? > > alter table pg_attribute set (autovacuum_vacuum_scale_factor = 0.0); > alter table pg_attribute set (autovacuum_vacuum_threshold = 500); > > ERROR:  permission denied: "pg_attribute" is a system catalog > ********** Ошибка ********** > > ERROR: permission denied: "pg_attribute" is a system catalog > SQL-состояние: 42501 I think you can only do that as superuser. -- Angular momentum makes the world go 'round.