Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UDNFO-0001cJ-8z for pgsql-docs@arkaria.postgresql.org; Wed, 06 Mar 2013 22:55:42 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UDNFN-0004KN-Pl for pgsql-docs@arkaria.postgresql.org; Wed, 06 Mar 2013 22:55:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UDNFM-0004KH-TV for pgsql-docs@postgresql.org; Wed, 06 Mar 2013 22:55:41 +0000 Received: from mail-we0-x22c.google.com ([2a00:1450:400c:c03::22c]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UDNFJ-0005LL-7K for pgsql-docs@postgresql.org; Wed, 06 Mar 2013 22:55:40 +0000 Received: by mail-we0-f172.google.com with SMTP id d46so4671599wer.17 for ; Wed, 06 Mar 2013 14:55:36 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=x-received:mime-version:sender:from:date:x-google-sender-auth :message-id:subject:to:content-type:x-gm-message-state; bh=sRVI5P5gD116cwTQOEeMcE6/6rNall3vBrohzRJkfp0=; b=LkhfVeq5pl+Lk9u3oYOmhAF9E12ZjReMACdGYXD7TxWwcLomgDGK37wvwA+/Pmnr+e fjICviP4+fHn647AexJkPRNUidpCvn1BK/iBBHVK4Vf6d7u0zLMuHMjvlZZvk3VvfoVt T+/oVwHzFamN+T4wUrOFSbkbLJ8i4K0GvWyObnicNzXF3zOtq1+Jp2zMVq6g9McLTu/G g0X7e3Y9gUlakrkH0vxKraGtJIgWh4Vv9UG8lGWJmFM6A88OvIG+rG52UFP+zyndN+DJ OlpcpQJJ6fz+bTVemkDFbpClK6FhpJCaBBME1qSAks2Yd7eqADoP0V3Jpf9U5scf4TcO EB4w== X-Received: by 10.194.7.131 with SMTP id j3mr50166554wja.23.1362610536274; Wed, 06 Mar 2013 14:55:36 -0800 (PST) MIME-Version: 1.0 Received: by 10.194.104.7 with HTTP; Wed, 6 Mar 2013 14:55:21 -0800 (PST) From: Jaime Casanova Date: Wed, 6 Mar 2013 17:55:21 -0500 X-Google-Sender-Auth: cxJMqlPo8udtzDJ5vlIfUb9Uvhk Message-ID: Subject: pg_buffercache To: pgsql-docs Content-Type: multipart/mixed; boundary=047d7b5d9c6ffb78e204d7497c68 X-Gm-Message-State: ALoCoQkOtBoolNC+F4E6mWEIbMgsbYyhN+L3bS5zJcobNefN+nudewTTL5gU03o8t2Y2wdM5Ugh6 X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org --047d7b5d9c6ffb78e204d7497c68 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi, has anyone noted that the structure of the pg_buffercache view in the docs has relforknumber and relblocknumber swaped. also, should we add a little description of what values can we find in relforknumber? attached is an extremely simple patch to fix both --=20 Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitaci=F3n Phone: +593 4 5107566 Cell: +593 987171157 --047d7b5d9c6ffb78e204d7497c68 Content-Type: application/octet-stream; name="pgbuffercache_docfix.patch" Content-Disposition: attachment; filename="pgbuffercache_docfix.patch" Content-Transfer-Encoding: base64 X-Attachment-Id: f_hdz2xzu00 ZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9wZ2J1ZmZlcmNhY2hlLnNnbWwg Yi9kb2Mvc3JjL3NnbWwvcGdidWZmZXJjYWNoZS5zZ21sCm5ldyBmaWxlIG1v ZGUgMTAwNjQ0CmluZGV4IDFkN2Q5NWYuLjYwZTQ1ZTAKKioqIGEvZG9jL3Ny Yy9zZ21sL3BnYnVmZmVyY2FjaGUuc2dtbAotLS0gYi9kb2Mvc3JjL3NnbWwv cGdidWZmZXJjYWNoZS5zZ21sCioqKioqKioqKioqKioqKgoqKiogNzQsOTAg KioqKgogICAgICAgPC9yb3c+CiAgCiAgICAgICA8cm93PgohICAgICAgIDxl bnRyeT48c3RydWN0ZmllbGQ+cmVsYmxvY2tudW1iZXI8L3N0cnVjdGZpZWxk PjwvZW50cnk+CiEgICAgICAgPGVudHJ5Pjx0eXBlPmJpZ2ludDwvdHlwZT48 L2VudHJ5PgogICAgICAgIDxlbnRyeT48L2VudHJ5PgohICAgICAgIDxlbnRy eT5QYWdlIG51bWJlciB3aXRoaW4gdGhlIHJlbGF0aW9uPC9lbnRyeT4KICAg ICAgIDwvcm93PgogIAogICAgICAgPHJvdz4KISAgICAgICA8ZW50cnk+PHN0 cnVjdGZpZWxkPnJlbGZvcmtudW1iZXI8L3N0cnVjdGZpZWxkPjwvZW50cnk+ CiEgICAgICAgPGVudHJ5Pjx0eXBlPnNtYWxsaW50PC90eXBlPjwvZW50cnk+ CiAgICAgICAgPGVudHJ5PjwvZW50cnk+CiEgICAgICAgPGVudHJ5PkZvcmsg bnVtYmVyIHdpdGhpbiB0aGUgcmVsYXRpb248L2VudHJ5PgogICAgICAgPC9y b3c+CiAgCiAgICAgICA8cm93PgotLS0gNzQsOTAgLS0tLQogICAgICAgPC9y b3c+CiAgCiAgICAgICA8cm93PgohICAgICAgIDxlbnRyeT48c3RydWN0Zmll bGQ+cmVsZm9ya251bWJlcjwvc3RydWN0ZmllbGQ+PC9lbnRyeT4KISAgICAg ICA8ZW50cnk+PHR5cGU+c21hbGxpbnQ8L3R5cGU+PC9lbnRyeT4KICAgICAg ICA8ZW50cnk+PC9lbnRyeT4KISAgICAgICA8ZW50cnk+Rm9yayBudW1iZXIg d2l0aGluIHRoZSByZWxhdGlvbi4gTWFpbiB0YWJsZTogMDsgRnJlZSBTcGFj ZSBNYXA6IDE7IFZpc2liaWxpdHkgTWFwOiAyOyBJbml0IGZvcms6IDM8L2Vu dHJ5PgogICAgICAgPC9yb3c+CiAgCiAgICAgICA8cm93PgohICAgICAgIDxl bnRyeT48c3RydWN0ZmllbGQ+cmVsYmxvY2tudW1iZXI8L3N0cnVjdGZpZWxk PjwvZW50cnk+CiEgICAgICAgPGVudHJ5Pjx0eXBlPmJpZ2ludDwvdHlwZT48 L2VudHJ5PgogICAgICAgIDxlbnRyeT48L2VudHJ5PgohICAgICAgIDxlbnRy eT5QYWdlIG51bWJlciB3aXRoaW4gdGhlIHJlbGF0aW9uPC9lbnRyeT4KICAg ICAgIDwvcm93PgogIAogICAgICAgPHJvdz4K --047d7b5d9c6ffb78e204d7497c68 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs --047d7b5d9c6ffb78e204d7497c68--