Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lUmVk-0002sb-4h for pgsql-admin@arkaria.postgresql.org; Fri, 09 Apr 2021 08:29:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lUmVi-0004uD-BO for pgsql-admin@arkaria.postgresql.org; Fri, 09 Apr 2021 08:29:02 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lUmVh-0004sO-Qg for pgsql-admin@lists.postgresql.org; Fri, 09 Apr 2021 08:29:01 +0000 Received: from mail-ej1-x633.google.com ([2a00:1450:4864:20::633]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lUmVe-00065j-Ig for pgsql-admin@lists.postgresql.org; Fri, 09 Apr 2021 08:29:00 +0000 Received: by mail-ej1-x633.google.com with SMTP id a7so7361396eju.1 for ; Fri, 09 Apr 2021 01:28:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20150623.gappssmtp.com; s=20150623; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version:content-transfer-encoding; bh=3AtXjoLTFu0Rt8kJkA/P7Dqsxjw9SLtiQVl491nQF0U=; b=VVpyZjvL5zGZr0frtfwPVUm6RkyaxsHGsE8SA/wbDUf7gbHS0A3NCqFcoTBxRFAoy9 aNCdP+pR/hmT03J9Ifg1LLj1QUnEHMyBKZhW67pbxjdiVsIFCTi98uDbcURH+rUcjpTj bk3+IE1QcpFTMRZj5XOs2mKDvWWqzmgF3iukTxm4m5PG6eTh2fhtRKdvd9Jpw764zyjN S/YuDe7KBU0WKr1y6J6cjohz2+4MSAdVsaj1vdVoUSaaluH4S7arclApUV2QwY6L9yKL VTHFvNDoo1BOXCpMdUWdVGCnFI43ZYemktZxBgG39XDwK4WKAROmhoJ/y22s8YmEgTEd pUtQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=3AtXjoLTFu0Rt8kJkA/P7Dqsxjw9SLtiQVl491nQF0U=; b=OiCQ8lj5NLuv1w5nXAL/HBwcIj2HWleph95RATD7ICb7I+tYj4AoggVu3NN4sZuSR4 uYRmbKQ5bN7VfBGP+GEhCK7gYNzKGLeFmWMt5c+xTlV97+cA85Kpzh0fe2NwvaZbnvkE ALsLbGnLN9YxrerANoWXRzVEaumRJ5iF5S6w4vpDBC/yMYr0q2B/Ah1iSxOgwrkbLnzp yYXdinF5qYfi6BCogTPQnNdrC5em7IgZomkzwGPpngkfTvG/DDdmnKwzpG0eYS+k5psa 3pecRthGQgs6EgoSmMFb15Z2GLtjGWrtOXexwbf3jv2IWuhOoQgipgSP6oV5+ji1ytqV gkfw== X-Gm-Message-State: AOAM533HPYCzYmzTaElNDAcQYhBsQlKs0psIYpN0XzjXxxHHY0MJtJme iPpCPtipxWa68Zt2iAF6r5+yJ9zS0GhUKA== X-Google-Smtp-Source: ABdhPJzdnD3hISIxctTDhonQdGYRoJPgh+rMiUEEvFt+RhWBy1NX0aPE8kE9lVwhV9zc1BNvFBSGWw== X-Received: by 2002:a17:906:d8a4:: with SMTP id qc4mr15234961ejb.529.1617956936522; Fri, 09 Apr 2021 01:28:56 -0700 (PDT) Received: from localhost.localdomain (217-149-171-143.nat.highway.telekom.at. [217.149.171.143]) by smtp.gmail.com with ESMTPSA id ck29sm997639edb.47.2021.04.09.01.28.56 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 09 Apr 2021 01:28:56 -0700 (PDT) Message-ID: <36863154fb50784105fc73e801e1a990d0aba7d9.camel@cybertec.at> Subject: Re: Swap being used on DB From: Laurenz Albe To: Yambu , Pgsql-admin Date: Fri, 09 Apr 2021 10:28:55 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.36.5 (3.36.5-2.fc32) MIME-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 2021-04-09 at 10:07 +0200, Yambu wrote: > May i know what causes swap space to be used on a DB server when RAM is 68G and not all of it is being used? Assuming this is Linux, perhaps "vm.swappiness" is high. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com