Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ifWz4-0001Zb-Dj for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Dec 2019 22:30:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ifWz1-0000Cy-1k for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Dec 2019 22:30:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ifWz0-00005i-IC for pgsql-hackers@lists.postgresql.org; Thu, 12 Dec 2019 22:30:54 +0000 Received: from mail-pl1-x633.google.com ([2607:f8b0:4864:20::633]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ifWyx-00025i-Iv for pgsql-hackers@postgresql.org; Thu, 12 Dec 2019 22:30:53 +0000 Received: by mail-pl1-x633.google.com with SMTP id a17so195212pls.5 for ; Thu, 12 Dec 2019 14:30:51 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:from:to:cc:references:message-id:date:user-agent :mime-version:in-reply-to:content-language:content-transfer-encoding; bh=2O+UPLkb3D0yXTvIRoWNPpAbKY2XaSIH61CsuM8IcrA=; b=ZCn0GMbKeK9Hbik2kMP7bEJdVv0m7b0Ik7K4WE5FfVuRAfdCM9wPlmaJ5Y4gp2J8g2 Klclcw1HiQZK0y7nFAM95V7Lof4Uj0OMZo6Qb2PfJDQw1uDp8FMO1HO+016Xl7ZnW34g E863cMoNoN2sNOm+30G1rdECO4nd5pJzDqiGll1j1A2LHdqcuCTRuQkyIbt8f66sk/8+ jvWqtdnGVgbqhKAyhwJN11M5H8WRhTEOv4knTXLH2ZsZ60n5Br3FO8eYSbyMaoKuWuNG k4IEvedWMAleABWChILyiuR+3GOjEcuzgVP22jvE205+Z5tcMB20X3Flsj/E3AoN95zS SAcQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:from:to:cc:references:message-id:date :user-agent:mime-version:in-reply-to:content-language :content-transfer-encoding; bh=2O+UPLkb3D0yXTvIRoWNPpAbKY2XaSIH61CsuM8IcrA=; b=BMj2qmLJYxpxWrGxRTLnZZ6ucdznsZbN55+j6J7bzGxW5ANHbvwnuzwkZioNS+oWEY jEFvB3ouw+LWr9iyfcE60JywpeHHytl0h/RloKPVomtoN5Ex/BTKBsraJTuK12ud+MI/ A7YKh7PG2J1uU9QfcDDDNnM2hpjG+0r5gWYRks1yT1uA3NZfaubfssfUhOZA94CAfU64 IYtluoKxKxpvfuoNQZROJlW29OoR/4nCWWR8D4/hBLtA5BeB5UTFm8yLtUCI3jt4W4SD lsZvGwMaVCPPG7CX+HqL8dLlhaw7J0cbck9JXWuTLF7VmZOh7JxYanWNOzz9uEdQXceU Ls9w== X-Gm-Message-State: APjAAAVAPrdOd5WH/g8awGlTxsGeXtBvQCPcvKqS+StOzmwxc7j7dBDL tyfEr6rDJtbfrGbPsk1WxAQ= X-Google-Smtp-Source: APXvYqyFfhBw/mfjGRlXxMb2iyC1SXYz9tHTE2rqJYf43r9LFKc83PDMv0uVRVAJuXYPFJ9XAo9S3A== X-Received: by 2002:a17:90a:250a:: with SMTP id j10mr12819066pje.134.1576189848911; Thu, 12 Dec 2019 14:30:48 -0800 (PST) Received: from [192.168.0.17] (24-113-193-150.wavecable.com. [24.113.193.150]) by smtp.gmail.com with ESMTPSA id j21sm8376013pfe.175.2019.12.12.14.30.48 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 12 Dec 2019 14:30:48 -0800 (PST) Subject: Re: Make autovacuum sort tables in descending order of xid_age From: Mark Dilger To: David Fetter Cc: PostgreSQL Development , Christophe Pettus References: <20191129180138.GD8731@fetter.org> <20191129222152.GE8731@fetter.org> <2488acea-328b-1328-d437-8c156bc8f7a4@gmail.com> <20191130222314.GF8731@fetter.org> <877ac074-e95d-bdee-09e7-c51f0ee0fde2@gmail.com> <20191212192631.GA29201@fetter.org> <2ad2a9fa-32eb-29aa-07ee-f0fe75ad4db5@gmail.com> Message-ID: <7f72ef60-b2a1-4a9f-b3f5-b6e1d4f85df1@gmail.com> Date: Thu, 12 Dec 2019 14:30:47 -0800 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.2.2 MIME-Version: 1.0 In-Reply-To: <2ad2a9fa-32eb-29aa-07ee-f0fe75ad4db5@gmail.com> Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 12/12/19 1:35 PM, Mark Dilger wrote: > Once the xid age reaches one > million, it will start to be the dominant factor. Actually, it doesn't change much from x = 1 to x = 1,000,000 but I was planning to add another factor to the formula and forgot before sending the email. I'll leave that as an exercise for the reader. -- Mark Dilger