Received: from maia.hub.org (maia-4.hub.org [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 6351E63257E for ; Tue, 27 Apr 2010 21:57:16 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 68876-04 for ; Wed, 28 Apr 2010 00:57:03 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-vw0-f46.google.com (mail-vw0-f46.google.com [209.85.212.46]) by mail.postgresql.org (Postfix) with ESMTP id 7BC71632527 for ; Tue, 27 Apr 2010 21:57:04 -0300 (ADT) Received: by vws14 with SMTP id 14so90898vws.19 for ; Tue, 27 Apr 2010 17:57:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:in-reply-to :references:date:message-id:subject:from:to:cc:content-type; bh=qdZlYO+6owCsXvBxX1i6ynyHvXnM/z8zp7gCjS84V6M=; b=R/M5MqUy8Z8Bv65sbNjK7jryQWEkayMTAwlT3CYlLcQmK+A4sFBBiABaOvcwkWi4Do t3+hpGbL7mlQMDfiylb27OX0D/EFJPIXzCW105EWE39ybOd3SxqWo7JC8S+lOhAJnjQZ WU0N9h2qB7ZGDkMVsbnr8qhfP2dOprlfXKAlY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=KafPN5gw5ndZ/wtyI2a2QZAYcmgoasigSKaaIbbaaRVpkV0DkSmTBCOtBL6a2Reyyz +slRxmP843bP/2Q+UTojlOjHwqLncma4XShhJ7cBUuC83gXNQkYqOPZYN+JYHkutcjQt TsKDFGZotS4J0w9cS7MELG4ID1cFdeHEfd0JA= MIME-Version: 1.0 Received: by 10.229.225.7 with SMTP id iq7mr8117067qcb.26.1272416217111; Tue, 27 Apr 2010 17:56:57 -0700 (PDT) Received: by 10.231.11.11 with HTTP; Tue, 27 Apr 2010 17:56:56 -0700 (PDT) In-Reply-To: References: Date: Tue, 27 Apr 2010 20:56:56 -0400 Message-ID: Subject: Re: tmpfs and postgres memory From: Robert Haas To: Anj Adu Cc: pgsql-performance@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001 X-Spam-Level: X-Archive-Number: 201004/324 X-Sequence-Number: 38574 On Mon, Apr 26, 2010 at 7:24 PM, Anj Adu wrote: > I have a 16G box and tmpfs is configured to use 8G for tmpfs . > > Is a lot of memory being wasted that can be used for Postgres ? (I am > not seeing any performance issues, but I am not clear how Linux uses > the tmpfs and how Postgres would be affected by the reduction in > memory) What does the output of "free -m" look like when the database is as heavily used as it typically gets? ...Robert