Re: PostgreSQL performance on FreeBSD
Maxim Sobolev <[email protected]> Sat, 25 Jun 2016 09:16:01 -0700
| Newsgroups | gmane.os.freebsd.performance |
|---|---|
| Message-ID | <CAH7qZfuHa-ZcZzspvsjhFASTQ841rfUu1gFV7KESBustMQD70Q__8459.43201934478$1466876340$gmane$org@mail.gmail.com> |
U2VhbiwgdG8gdGhlIGlzc3VlIHRoYXQgeW91IGFyZSBkZXNjcmliaW5nIGl0IGlzIGFsc28gbWln aHQgYmUgcG9zc2libGUgdG8KZG8gaXQgc29tZSBvdGhlciB3YXkgYXJvdW5kLiBPbmUsIHBlcmhh cHMgbW9yZSBwb3J0YWJsZSwgaXMgdG8gc2hhcmUgYQpjb25uZWN0ZWQgc29ja2V0cGFpciBiZXR3 ZWVuIHR3byBjb21tdW5pY2F0aW5nIHByb2Nlc3Nlcywgc28gdGhhdCB5b3UgY2FuCmRvIG5vbi1i bG9ja2luZyByZWFkIG9uIG9uZSBvZiBpdHMgZW5kcyBmcm9tIHRpbWUgdG8gdGltZSBhbmQgY2hl Y2sgaWYgaXQKcmV0dXJucyBFT0YuIFdoaWNoIHdvdWxkIGJlIHRoZSBjYXNlIGlmIHdoYXRldmVy IHByb2Nlc3MgaG9sZHMgdGhlIG90aGVyCmVuZCBvZiBpdCBpcyBubyBsb25nZXIgdGhlcmUuIFNv IGluc3RlYWQgb2Ygc2hhcmVkIG1lbW9yeSBzZWdtZW50LCB5b3UgY2FuCmhhdmUgcG9vbCBvZiBk ZXNjcmlwdG9ycywgb25lIGZvciBlYWNoIHdvcmtlciB0aGF0IHlvdSBjYXJlIGFib3V0LiBQb2xs aW5nCm9uIHRob3NlIHdvdWxkIGJlIHRyaXZpYWwgd2l0aCBqdXN0IHJlZ3VsYXIgcG9sbCgyKS4g VGhlIG9ubHkgaXNzdWUgbWlnaHQKYmUgdGhhdCBwb3N0Z3JlcyBmb3JrcyBhIGxvdCwgc28gd2Ug d291bGQgcHJvYmFibHkgbmVlZCB0byBpbXBsZW1lbnQKRkRfQ0xPRk9SSyB0byBhdm9pZCBjb3B5 aW5nIHRob3NlIGV4dHJhIGZkcyBpbnRvIGV2ZXJ5IGNoaWxkLgoKU29tZXRoaW5nIGFraW4gdG8g YSBzb2x1dGlvbiB0aGF0IEkgcmVjZW50bHkgcG9zdGVkIHRvIHdvcmsgYXJvdW5kIHByb2JsZW0K dGhhdCB5b3UgY2Fubm90IHJlYWxseSB3YWl0cGlkKCkgb24gYSBncmFuZC1jaGlsZCBzZWUgUEcg QlVHICMxNDE5OSBmb3IKZGV0YWlscyAmIHBhdGNoLgoKQnV0IHllcywgaXQgd291bGQgYmUgcmVh bGx5IG5pY2UgdG8gZ2V0IHJpZCBvZiBTWVNWIHNoYXJlZCBtZW1vcnkgdXNlIGluIFBHCmNvbXBs ZXRlbHkgYXMgc29tZSBwb2ludCBvbmUgd2F5IG9yIGFub3RoZXIuCgotTWF4CgpPbiBUaHUsIEp1 biAyMywgMjAxNiBhdCAzOjQyIFBNLCBTZWFuIENoaXR0ZW5kZW4gPHNlYW5AY2hpdHRlbmRlbi5v cmc+Cndyb3RlOgoKPiBTbWFsbCBuaXQ6Cj4KPiBQb3N0Z3JlU1FMIHVzZWQgU1lTViBiZWNhdXNl IGl0IGFsbG93ZWQgZm9yIHRoZSBkZXRlY3Rpb24gb2YgZGVhZAo+IHByb2Nlc3Nlcy4gIElmIHlv dSBga2lsbCAtOWDigJllZCBhIHByb2Nlc3MsIFBvc3RncmVTUUwgY2FuIGRldGVjdCB0aGF0IGFu ZAo+IHRoZW4gc2h1dCBkb3duIGFuZCBwZXJmb3JtIGFuIGF1dG9tYXRpYyByZWNvdmVyeS4gIElu IHRoaXMgcmVnYXJkLCBzeXN2IGlzCj4gcHJldHR5IGNsZXZlci4gIFRoZSBtb3ZlIHRvIFBPU0lY IHNoYXJlZCBtZW0gd2FzIGRvbmUgZm9yIGEgaG9zdCBvZgo+IHJlYXNvbnMsIGJ1dCBpdCBtZWFu cyB0aGF0IHlvdSBkb27igJl0IGhhdmUgdG8gYWRqdXN0IHlvdXIgU1lTViBsaW1pdHMuICBNeQo+ IHVuZGVyc3RhbmRpbmcgZnJvbSBhIGZldyB5ZWFycyBhZ28gaXMgdGhhdCB0aGVyZSBpcyBzdGls bCBhIH42NEtCIFNZU1YKPiBtZW1vcnkgc2VnbWVudCB0aGF0IGlzIHN0aWxsIHVzZWQgdG8gYWN0 IGFzIHRoZSBsYXRjaCB0byBzaWduYWwgaWYgYQo+IHByb2Nlc3Mgd2FzIGtpbGxlZCwgYnV0IGFs bCBvZiB0aGUgc2hhcmVkIGJ1ZmZlcnMgYXJlIHN0b3JlZCBpbiBwb3NpeAo+IG1tYXDigJllZCBy ZWdpb25zLgo+Cj4gQXQgdGhpcyBwb2ludCBpbiB0aW1lIHRoaXMgY291bGQgYmUgcmVwbGFjZWQg d2l0aCBrcXVldWUoMikgRVZGSUxUX1BST0MsCj4gYnV0IG5vIG9uZSBoYXMgZG9uZSB0aGF0IHll dC4KPgo+IC1zYwo+Cj4KPgo+IC0tCj4gU2VhbiBDaGl0dGVuZGVuCj4gc2VhbkBjaGl0dGVuZGVu Lm9yZwo+Cj4gPiBPbiBKdW4gMjIsIDIwMTYsIGF0IDA3OjI2ICwgTWF4aW0gU29ib2xldiA8c29i b21heEBmcmVlYnNkLm9yZz4gd3JvdGU6Cj4gPgo+ID4gS29uc3RhbnRpbiwKPiA+Cj4gPiBOb3Qg aWYgeW91IGRvIHNlbV91bmxpbmsoKSBpbW1lZGlhdGVseSwgQUZBSUsuIEFuZCB0aGF0J3Mgd2hh dCBQRyBkb2VzLgo+IFNvCj4gPiB0aGUgd2luZG93IG9mIG9wcG9ydHVuaXR5IGZvciB0aGUgbGVh a2FnZSBpcyBxdWl0ZSBzbWFsbCwgbXVjaCBzbWFsbGVyCj4gdGhhbgo+ID4gZm9yIFNZU1YgcHJp bWl0aXZlcy4gU29ycnkgZm9yIG1pc3NpbmcgeW91ciBzdGF0dXMgdXBkYXRlIG1lc3NhZ2UsIEkn dmUKPiA+IG1pc3NlZCBpdCBzb21laG93Lgo+ID4KPiA+IC0tLS0KPiA+ICAgICAgICAgICAgICAg IG15U2VtID0gc2VtX29wZW4oc2VtbmFtZSwgT19DUkVBVCB8IE9fRVhDTCwKPiA+ICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIChtb2RlX3QpIElQQ1Byb3Rl Y3Rpb24sCj4gPiAodW5zaWduZWQpIDEpOwo+ID4KPiA+ICNpZmRlZiBTRU1fRkFJTEVECj4gPiAg ICAgICAgICAgICAgICBpZiAobXlTZW0gIT0gKHNlbV90ICopIFNFTV9GQUlMRUQpCj4gPiAgICAg ICAgICAgICAgICAgICAgICAgIGJyZWFrOwo+ID4gI2Vsc2UKPiA+ICAgICAgICAgICAgICAgIGlm IChteVNlbSAhPSAoc2VtX3QgKikgKC0xKSkKPiA+ICAgICAgICAgICAgICAgICAgICAgICAgYnJl YWs7Cj4gPiAjZW5kaWYKPiA+Cj4gPiAgICAgICAgICAgICAgICAvKiBMb29wIGlmIGVycm9yIGlu ZGljYXRlcyBhIGNvbGxpc2lvbiAqLwo+ID4gICAgICAgICAgICAgICAgaWYgKGVycm5vID09IEVF WElTVCB8fCBlcnJubyA9PSBFQUNDRVMgfHwgZXJybm8gPT0gRUlOVFIpCj4gPiAgICAgICAgICAg ICAgICAgICAgICAgIGNvbnRpbnVlOwo+ID4KPiA+ICAgICAgICAgICAgICAgIC8qCj4gPiAgICAg ICAgICAgICAgICAgKiBFbHNlIGNvbXBsYWluIGFuZCBhYm9ydAo+ID4gICAgICAgICAgICAgICAg ICovCj4gPiAgICAgICAgICAgICAgICBlbG9nKEZBVEFMLCAic2VtX29wZW4oXCIlc1wiKSBmYWls ZWQ6ICVtIiwgc2VtbmFtZSk7Cj4gPiAgICAgICAgfQo+ID4KPiA+ICAgICAgICAvKgo+ID4gICAg ICAgICAqIFVubGluayB0aGUgc2VtYXBob3JlIGltbWVkaWF0ZWx5LCBzbyBpdCBjYW4ndCBiZSBh Y2Nlc3NlZAo+ID4gZXh0ZXJuYWxseS4KPiA+ICAgICAgICAgKiBUaGlzIGFsc28gZW5zdXJlcyB0 aGF0IGl0IHdpbGwgZ28gYXdheSBpZiB3ZSBjcmFzaC4KPiA+ICAgICAgICAgKi8KPiA+ICAgICAg ICBzZW1fdW5saW5rKHNlbW5hbWUpOwo+ID4KPiA+ICAgICAgICByZXR1cm4gbXlTZW07Cj4gPiAt LS0tCj4gPgo+ID4gLU1heAo+ID4KPiA+IE9uIFdlZCwgSnVuIDIyLCAyMDE2IGF0IDM6MDIgQU0s IEtvbnN0YW50aW4gQmVsb3Vzb3YgPAo+IGtvc3Rpa2JlbEBnbWFpbC5jb20+Cj4gPiB3cm90ZToK PiA+Cj4gPj4gT24gVHVlLCBKdW4gMjEsIDIwMTYgYXQgMTI6NDg6MDBQTSAtMDcwMCwgTWF4aW0g U29ib2xldiB3cm90ZToKPiA+Pj4gVGhhbmtzLCBLb25zdGFudGluIGZvciB0aGUgZ3JlYXQgd29y aywgd2UgYXJlIGRlZmluaXRlbHkgbG9va2luZwo+IGZvcndhcmQKPiA+PiB0bwo+ID4+PiBnZXQg YWxsIHRob3NlIGltcHJvdmVtZW50cyB0byBiZSBwYXJ0IG9mIHRoZSBkZWZhdWx0IEZyZWVCU0QK PiBrZXJuZWwvcG9ydC4KPiA+Pj4gV291bGQgYmUgbmljZSBpZiB5b3UgY2FuIHBvc3QgYW4gdXBk YXRlIHNvbWUgZGF5IGxhdGVyIGFzIHRvIHdoYXQncwo+ID4+PiBpbnRlZ3JhdGVkIGFuZCB3aGF0 J3Mgbm90Lgo+ID4+IEkgZGlkIHBvc3RlZCB0aGUgdXBkYXRlIHNldmVyYWwgZGF5cyBlYXJsaWVy LiAgU2luY2UgeW91IHJlcGx5aW5nIHRvCj4gdGhpcwo+ID4+IHRocmVhZCwgaXQgd291bGQgYmUg bm90IHVucmVhc29uYWJsZSB0byByZWFkIHJlY2VudCBtZXNzYWdlcyB0aGF0IHdlcmUKPiA+PiBz ZW50Lgo+ID4+Cj4gPj4+Cj4gPj4+IEp1c3QgaW4gY2FzZSwgSSd2ZSBvcGVuZWQgIzE0MjA2IHdp dGggUEcgdG8gc3dpdGNoIHVzIHRvIHVzaW5nIFBPU0lYCj4gPj4+IHNlbWFwaG9yZXMgYnkgZGVm YXVsdC4gQXBhcnQgZnJvbSB0aGUgbWVudGlvbmVkIHBlcmZvcm1hbmNlIGJlbmVmaXRzLAo+ID4+ IFNZU1YKPiA+Pj4gc2VtYXBob3JlcyBhcmUgUElUQSB0byBkZWFsIHdpdGggYXMgdGhleSBjb21l IGluIHZlcnkgbGltaXRlZAo+IHF1YW50aXRpZXMKPiA+PiBieQo+ID4+PiBkZWZhdWx0LiBBbHNv IHRoZXkgbWlnaHQgc3RheSBhcm91bmQgaWYgUEcgZGllcy9nZXRzIG51a2VkIGFuZCBwcmV2ZW50 Cj4gaXQKPiA+Pj4gZnJvbSBzdGFydGluZyBhZ2FpbiBkdWUgdG8gb3ZlcmZsb3cuIFdlJ3ZlIGdv dCBzb21lIHF1aXRlIHVnbHkgY29kZSB0bwo+ID4+PiBjbGVhbiB1cCB0aG9zZSB1c2luZyBpcGNy bSgxKSBpbiBvdXIgYnVpbGQgc2NyaXB0cyB0byBkZWFsIHdpdGgganVzdAo+ID4+IHRoYXQuCj4g Pj4+IEkgYW0gaGFwcHkgdGhhdCBjb2RlIGNvdWxkIGJlIHJldGlyZWQgbm93Lgo+ID4+Cj4gPj4g TmFtZWQgc2VtYXBob3JlcyBhbHNvIHN0dWNrIGFyb3VuZCBpZiBwcm9jZXNzZXMgYXJlIGtpbGxl ZCB3aXRob3V0Cj4gY2xlYW51cC4KPiA+Pgo+ID4+Cj4gPiBfX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fXwo+ID4gZnJlZWJzZC1wZXJmb3JtYW5jZUBmcmVlYnNk Lm9yZyBtYWlsaW5nIGxpc3QKPiA+IGh0dHBzOi8vbGlzdHMuZnJlZWJzZC5vcmcvbWFpbG1hbi9s aXN0aW5mby9mcmVlYnNkLXBlcmZvcm1hbmNlCj4gPiBUbyB1bnN1YnNjcmliZSwgc2VuZCBhbnkg bWFpbCB0byAiCj4gZnJlZWJzZC1wZXJmb3JtYW5jZS11bnN1YnNjcmliZUBmcmVlYnNkLm9yZyIK Pgo+Cl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fCmZyZWVi c2QtcGVyZm9ybWFuY2VAZnJlZWJzZC5vcmcgbWFpbGluZyBsaXN0Cmh0dHBzOi8vbGlzdHMuZnJl ZWJzZC5vcmcvbWFpbG1hbi9saXN0aW5mby9mcmVlYnNkLXBlcmZvcm1hbmNlClRvIHVuc3Vic2Ny aWJlLCBzZW5kIGFueSBtYWlsIHRvICJmcmVlYnNkLXBlcmZvcm1hbmNlLXVuc3Vic2NyaWJlQGZy ZWVic2Qub3JnIg==