Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 2A515633E02 for ; Wed, 31 Mar 2010 08:45:41 -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 29279-08 for ; Wed, 31 Mar 2010 11:45:30 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gy0-f174.google.com (mail-gy0-f174.google.com [209.85.160.174]) by mail.postgresql.org (Postfix) with ESMTP id 739D5632FB4 for ; Wed, 31 Mar 2010 08:45:29 -0300 (ADT) Received: by gyg13 with SMTP id 13so2748997gyg.19 for ; Wed, 31 Mar 2010 04:45:28 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:received:message-id :subject:from:to:content-type; bh=PgFmKucMg8guZDQp+HeRRUm8MvyOt9OdhHT0Ta+QxJY=; b=mNerDV2Thh2LAOyKQFWdRKSEKKYfaH/OrMr4Uw5JWtL8WsvQxAiD0PehExhhYF6YoB lD3PVkFRWmqGdj2+0u+QijOX2QQ2apVEkjc/+FcYxLuXhk9V3tdReyzt8GcvYMjyIriG ueuK/2XqABTiWwZAUtAUP6Xf4RvIR+yrfxxlo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=nhDGUNsVnCokXlJGMyIWkeUTIieABSGh/2cjP9jDjRCUiHAJRwziw+ySfdqqGZG3wW Oy18OEnPBYVYV63jdapOqkp+fWCbz8dnXFSeJmjvzvyDOmHpe8UrX50DrwvMA9RAXDPa 29vcL71mC+xIpoOYQlsaHcD8d+3BFIO8WjB9M= MIME-Version: 1.0 Received: by 10.100.253.9 with HTTP; Wed, 31 Mar 2010 04:45:27 -0700 (PDT) Date: Wed, 31 Mar 2010 20:45:27 +0900 Received: by 10.100.238.12 with SMTP id l12mr2276112anh.239.1270035928042; Wed, 31 Mar 2010 04:45:28 -0700 (PDT) Message-ID: Subject: Streaming replication and document about avoiding WAL-logging From: Fujii Masao To: pgsql-docs@postgresql.org Content-Type: multipart/mixed; boundary=0016368e20f057d2c0048317489c X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.838 tagged_above=-10 required=5 tests=BAYES_00=-2.599, FS_REPLICA=1.041, SARE_SPEC_REPLICA=0.72 X-Spam-Level: X-Archive-Number: 201003/22 X-Sequence-Number: 5387 --0016368e20f057d2c0048317489c Content-Type: text/plain; charset=ISO-8859-1 Hi, In 9.0, some SQL commands can avoid WAL-logging only when not only archive_mode is off but also max_wal_senders is zero (new condition since 9.0). But I forgot modifying the documents about this behavior enough :( The attached patch adds the description about that new condition for WAL-logging. Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center --0016368e20f057d2c0048317489c Content-Type: application/octet-stream; name="doc_skip_logging_v1.patch" Content-Disposition: attachment; filename="doc_skip_logging_v1.patch" Content-Transfer-Encoding: base64 X-Attachment-Id: f_g7g1ouo80 KioqIGEvZG9jL3NyYy9zZ21sL2JhY2t1cC5zZ21sCi0tLSBiL2RvYy9zcmMvc2dtbC9iYWNrdXAu c2dtbAoqKioqKioqKioqKioqKioKKioqIDY4OCw2OTYgKioqKiBhcmNoaXZlX2NvbW1hbmQgPSAn dGVzdCAhIC1mIC4uLi8lZiAmYW1wOyZhbXA7IGNwICVwIC4uLi8lZicKICAgICA8L3BhcmE+CiAg CiAgICAgPHBhcmE+CiEgICAgIFdoZW4gPHZhcm5hbWU+YXJjaGl2ZV9tb2RlPC8+IGlzIDxsaXRl cmFsPm9mZjwvPiBzb21lIFNRTCBjb21tYW5kcwogICAgICBhcmUgb3B0aW1pemVkIHRvIGF2b2lk IFdBTCBsb2dnaW5nLCBhcyBkZXNjcmliZWQgaW4gPHhyZWYKISAgICAgbGlua2VuZD0icG9wdWxh dGUtcGl0ciI+LiBJZiBhcmNoaXZpbmcgd2VyZSB0dXJuZWQgb24gZHVyaW5nIGV4ZWN1dGlvbgog ICAgICBvZiBvbmUgb2YgdGhlc2Ugc3RhdGVtZW50cywgV0FMIHdvdWxkIG5vdCBjb250YWluIGVu b3VnaCBpbmZvcm1hdGlvbgogICAgICBmb3IgYXJjaGl2ZSByZWNvdmVyeS4gIChDcmFzaCByZWNv dmVyeSBpcyB1bmFmZmVjdGVkLikgIEZvcgogICAgICB0aGlzIHJlYXNvbiwgPHZhcm5hbWU+YXJj aGl2ZV9tb2RlPC8+IGNhbiBvbmx5IGJlIGNoYW5nZWQgYXQgc2VydmVyCi0tLSA2ODgsNjk4IC0t LS0KICAgICA8L3BhcmE+CiAgCiAgICAgPHBhcmE+CiEgICAgIFdoZW4gPHZhcm5hbWU+YXJjaGl2 ZV9tb2RlPC8+IGlzIDxsaXRlcmFsPm9mZjwvPiBhbmQgPHhyZWYKISAgICAgbGlua2VuZD0iZ3Vj LW1heC13YWwtc2VuZGVycyI+IGlzIHplcm8gc29tZSBTUUwgY29tbWFuZHMKICAgICAgYXJlIG9w dGltaXplZCB0byBhdm9pZCBXQUwgbG9nZ2luZywgYXMgZGVzY3JpYmVkIGluIDx4cmVmCiEgICAg IGxpbmtlbmQ9InBvcHVsYXRlLXBpdHIiPi4gV2hlbiBzdHJlYW1pbmcgcmVwbGljYXRpb24gaXMg ZGlzYWJsZWQsCiEgICAgIGlmIGFyY2hpdmluZyB3ZXJlIHR1cm5lZCBvbiBkdXJpbmcgZXhlY3V0 aW9uCiAgICAgIG9mIG9uZSBvZiB0aGVzZSBzdGF0ZW1lbnRzLCBXQUwgd291bGQgbm90IGNvbnRh aW4gZW5vdWdoIGluZm9ybWF0aW9uCiAgICAgIGZvciBhcmNoaXZlIHJlY292ZXJ5LiAgKENyYXNo IHJlY292ZXJ5IGlzIHVuYWZmZWN0ZWQuKSAgRm9yCiAgICAgIHRoaXMgcmVhc29uLCA8dmFybmFt ZT5hcmNoaXZlX21vZGU8Lz4gY2FuIG9ubHkgYmUgY2hhbmdlZCBhdCBzZXJ2ZXIKKioqIGEvZG9j L3NyYy9zZ21sL3BlcmZvcm0uc2dtbAotLS0gYi9kb2Mvc3JjL3NnbWwvcGVyZm9ybS5zZ21sCioq KioqKioqKioqKioqKgoqKiogOTEwLDkzMyAqKioqIFNFTEVDVCAqIEZST00geCwgeSwgYSwgYiwg YyBXSEVSRSBzb21ldGhpbmcgQU5EIHNvbWV0aGluZ2Vsc2U7CiAgICA8L3NlY3QyPgogIAogICAg PHNlY3QyIGlkPSJwb3B1bGF0ZS1waXRyIj4KISAgICA8dGl0bGU+VHVybiBvZmYgPHZhcm5hbWU+ YXJjaGl2ZV9tb2RlPC92YXJuYW1lPjwvdGl0bGU+CiAgCiAgICAgPHBhcmE+CiAgICAgIFdoZW4g bG9hZGluZyBsYXJnZSBhbW91bnRzIG9mIGRhdGEgaW50byBhbiBpbnN0YWxsYXRpb24gdGhhdCB1 c2VzCiEgICAgIFdBTCBhcmNoaXZpbmcsIHlvdSBtaWdodCB3YW50IHRvIGRpc2FibGUgYXJjaGl2 aW5nICh0dXJuIG9mZiB0aGUKISAgICAgPHhyZWYgbGlua2VuZD0iZ3VjLWFyY2hpdmUtbW9kZSI+ IGNvbmZpZ3VyYXRpb24gdmFyaWFibGUpCiAgICAgIHdoaWxlIGxvYWRpbmcuICBJdCBtaWdodCBi ZQogICAgICBmYXN0ZXIgdG8gdGFrZSBhIG5ldyBiYXNlIGJhY2t1cCBhZnRlciB0aGUgbG9hZCBo YXMgY29tcGxldGVkCiAgICAgIHRoYW4gdG8gcHJvY2VzcyBhIGxhcmdlIGFtb3VudCBvZiBpbmNy ZW1lbnRhbCBXQUwgZGF0YS4KISAgICAgQnV0IG5vdGUgdGhhdCB0dXJuaW5nIDx2YXJuYW1lPmFy Y2hpdmVfbW9kZTwvdmFybmFtZT4gb24gb3Igb2ZmCiEgICAgIHJlcXVpcmVzIGEgc2VydmVyIHJl c3RhcnQuCiAgICAgPC9wYXJhPgogIAogICAgIDxwYXJhPgohICAgICBBc2lkZSBmcm9tIGF2b2lk aW5nIHRoZSB0aW1lIGZvciB0aGUgYXJjaGl2ZXIgdG8gcHJvY2VzcyB0aGUgV0FMIGRhdGEsCiAg ICAgIGRvaW5nIHRoaXMgd2lsbCBhY3R1YWxseSBtYWtlIGNlcnRhaW4gY29tbWFuZHMgZmFzdGVy LCBiZWNhdXNlIHRoZXkKICAgICAgYXJlIGRlc2lnbmVkIG5vdCB0byB3cml0ZSBXQUwgYXQgYWxs IGlmIDx2YXJuYW1lPmFyY2hpdmVfbW9kZTwvdmFybmFtZT4KISAgICAgaXMgb2ZmLiAgKFRoZXkg Y2FuIGd1YXJhbnRlZSBjcmFzaCBzYWZldHkgbW9yZSBjaGVhcGx5IGJ5IGRvaW5nIGFuCiAgICAg IDxmdW5jdGlvbj5mc3luYzwvPiBhdCB0aGUgZW5kIHRoYW4gYnkgd3JpdGluZyBXQUwuKQogICAg ICBUaGlzIGFwcGxpZXMgdG8gdGhlIGZvbGxvd2luZyBjb21tYW5kczoKICAgICAgPGl0ZW1pemVk bGlzdD4KLS0tIDkxMCw5MzggLS0tLQogICAgPC9zZWN0Mj4KICAKICAgIDxzZWN0MiBpZD0icG9w dWxhdGUtcGl0ciI+CiEgICAgPHRpdGxlPlR1cm4gb2ZmIDx2YXJuYW1lPmFyY2hpdmVfbW9kZTwv dmFybmFtZT4gYW5kIHN0cmVhbWluZyByZXBsaWNhdGlvbjwvdGl0bGU+CiAgCiAgICAgPHBhcmE+ CiAgICAgIFdoZW4gbG9hZGluZyBsYXJnZSBhbW91bnRzIG9mIGRhdGEgaW50byBhbiBpbnN0YWxs YXRpb24gdGhhdCB1c2VzCiEgICAgIFdBTCBhcmNoaXZpbmcgb3Igc3RyZWFtaW5nIHJlcGxpY2F0 aW9uLCB5b3UgbWlnaHQgd2FudCB0byBkaXNhYmxlCiEgICAgIGFyY2hpdmluZyAodHVybiBvZmYg dGhlIDx4cmVmIGxpbmtlbmQ9Imd1Yy1hcmNoaXZlLW1vZGUiPgohICAgICBjb25maWd1cmF0aW9u IHZhcmlhYmxlKSBvciByZXBsaWNhdGlvbiAoemVybyB0aGUKISAgICAgPHhyZWYgbGlua2VuZD0i Z3VjLW1heC13YWwtc2VuZGVycyI+IGNvbmZpZ3VyYXRpb24gdmFyaWFibGUpCiAgICAgIHdoaWxl IGxvYWRpbmcuICBJdCBtaWdodCBiZQogICAgICBmYXN0ZXIgdG8gdGFrZSBhIG5ldyBiYXNlIGJh Y2t1cCBhZnRlciB0aGUgbG9hZCBoYXMgY29tcGxldGVkCiAgICAgIHRoYW4gdG8gcHJvY2VzcyBh IGxhcmdlIGFtb3VudCBvZiBpbmNyZW1lbnRhbCBXQUwgZGF0YS4KISAgICAgQnV0IG5vdGUgdGhh dCB0dXJuaW5nIDx2YXJuYW1lPmFyY2hpdmVfbW9kZTwvdmFybmFtZT4gb24gb3Igb2ZmLAohICAg ICBhbmQgY2hhbmdpbmcgPHZhcm5hbWU+bWF4X3dhbF9zZW5kZXJzPC92YXJuYW1lPiByZXF1aXJl CiEgICAgIGEgc2VydmVyIHJlc3RhcnQuCiAgICAgPC9wYXJhPgogIAogICAgIDxwYXJhPgohICAg ICBBc2lkZSBmcm9tIGF2b2lkaW5nIHRoZSB0aW1lIGZvciB0aGUgYXJjaGl2ZXIgb3IgdGhlIFdB TCBzZW5kZXIgdG8KISAgICAgcHJvY2VzcyB0aGUgV0FMIGRhdGEsCiAgICAgIGRvaW5nIHRoaXMg d2lsbCBhY3R1YWxseSBtYWtlIGNlcnRhaW4gY29tbWFuZHMgZmFzdGVyLCBiZWNhdXNlIHRoZXkK ICAgICAgYXJlIGRlc2lnbmVkIG5vdCB0byB3cml0ZSBXQUwgYXQgYWxsIGlmIDx2YXJuYW1lPmFy Y2hpdmVfbW9kZTwvdmFybmFtZT4KISAgICAgaXMgb2ZmIGFuZCA8dmFybmFtZT5tYXhfd2FsX3Nl bmRlcnM8L3Zhcm5hbWU+IGlzIHplcm8uICAoVGhleSBjYW4KISAgICAgZ3VhcmFudGVlIGNyYXNo IHNhZmV0eSBtb3JlIGNoZWFwbHkgYnkgZG9pbmcgYW4KICAgICAgPGZ1bmN0aW9uPmZzeW5jPC8+ IGF0IHRoZSBlbmQgdGhhbiBieSB3cml0aW5nIFdBTC4pCiAgICAgIFRoaXMgYXBwbGllcyB0byB0 aGUgZm9sbG93aW5nIGNvbW1hbmRzOgogICAgICA8aXRlbWl6ZWRsaXN0Pgo= --0016368e20f057d2c0048317489c--