Re: PostgreSQL performance on FreeBSD
Sean Chittenden <[email protected]> Thu, 23 Jun 2016 15:42:32 -0700
| Newsgroups | gmane.os.freebsd.performance |
|---|---|
| Message-ID | <C06B11C3-5D40-43AF-8975-880F272933C5__39315.8200000927$1466731580$gmane$org@chittenden.org> |
U21hbGwgbml0OgoKUG9zdGdyZVNRTCB1c2VkIFNZU1YgYmVjYXVzZSBpdCBhbGxvd2VkIGZvciB0 aGUgZGV0ZWN0aW9uIG9mIGRlYWQgcHJvY2Vzc2VzLiAgSWYgeW91IGBraWxsIC05YOKAmWVkIGEg cHJvY2VzcywgUG9zdGdyZVNRTCBjYW4gZGV0ZWN0IHRoYXQgYW5kIHRoZW4gc2h1dCBkb3duIGFu ZCBwZXJmb3JtIGFuIGF1dG9tYXRpYyByZWNvdmVyeS4gIEluIHRoaXMgcmVnYXJkLCBzeXN2IGlz IHByZXR0eSBjbGV2ZXIuICBUaGUgbW92ZSB0byBQT1NJWCBzaGFyZWQgbWVtIHdhcyBkb25lIGZv ciBhIGhvc3Qgb2YgcmVhc29ucywgYnV0IGl0IG1lYW5zIHRoYXQgeW91IGRvbuKAmXQgaGF2ZSB0 byBhZGp1c3QgeW91ciBTWVNWIGxpbWl0cy4gIE15IHVuZGVyc3RhbmRpbmcgZnJvbSBhIGZldyB5 ZWFycyBhZ28gaXMgdGhhdCB0aGVyZSBpcyBzdGlsbCBhIH42NEtCIFNZU1YgbWVtb3J5IHNlZ21l bnQgdGhhdCBpcyBzdGlsbCB1c2VkIHRvIGFjdCBhcyB0aGUgbGF0Y2ggdG8gc2lnbmFsIGlmIGEg cHJvY2VzcyB3YXMga2lsbGVkLCBidXQgYWxsIG9mIHRoZSBzaGFyZWQgYnVmZmVycyBhcmUgc3Rv cmVkIGluIHBvc2l4IG1tYXDigJllZCByZWdpb25zLgoKQXQgdGhpcyBwb2ludCBpbiB0aW1lIHRo aXMgY291bGQgYmUgcmVwbGFjZWQgd2l0aCBrcXVldWUoMikgRVZGSUxUX1BST0MsIGJ1dCBubyBv bmUgaGFzIGRvbmUgdGhhdCB5ZXQuCgotc2MKCgoKLS0KU2VhbiBDaGl0dGVuZGVuCnNlYW5AY2hp dHRlbmRlbi5vcmcKCj4gT24gSnVuIDIyLCAyMDE2LCBhdCAwNzoyNiAsIE1heGltIFNvYm9sZXYg PHNvYm9tYXhAZnJlZWJzZC5vcmc+IHdyb3RlOgo+IAo+IEtvbnN0YW50aW4sCj4gCj4gTm90IGlm IHlvdSBkbyBzZW1fdW5saW5rKCkgaW1tZWRpYXRlbHksIEFGQUlLLiBBbmQgdGhhdCdzIHdoYXQg UEcgZG9lcy4gU28KPiB0aGUgd2luZG93IG9mIG9wcG9ydHVuaXR5IGZvciB0aGUgbGVha2FnZSBp cyBxdWl0ZSBzbWFsbCwgbXVjaCBzbWFsbGVyIHRoYW4KPiBmb3IgU1lTViBwcmltaXRpdmVzLiBT b3JyeSBmb3IgbWlzc2luZyB5b3VyIHN0YXR1cyB1cGRhdGUgbWVzc2FnZSwgSSd2ZQo+IG1pc3Nl ZCBpdCBzb21laG93Lgo+IAo+IC0tLS0KPiAgICAgICAgICAgICAgICBteVNlbSA9IHNlbV9vcGVu KHNlbW5hbWUsIE9fQ1JFQVQgfCBPX0VYQ0wsCj4gICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgKG1vZGVfdCkgSVBDUHJvdGVjdGlvbiwKPiAodW5zaWduZWQp IDEpOwo+IAo+ICNpZmRlZiBTRU1fRkFJTEVECj4gICAgICAgICAgICAgICAgaWYgKG15U2VtICE9 IChzZW1fdCAqKSBTRU1fRkFJTEVEKQo+ICAgICAgICAgICAgICAgICAgICAgICAgYnJlYWs7Cj4g I2Vsc2UKPiAgICAgICAgICAgICAgICBpZiAobXlTZW0gIT0gKHNlbV90ICopICgtMSkpCj4gICAg ICAgICAgICAgICAgICAgICAgICBicmVhazsKPiAjZW5kaWYKPiAKPiAgICAgICAgICAgICAgICAv KiBMb29wIGlmIGVycm9yIGluZGljYXRlcyBhIGNvbGxpc2lvbiAqLwo+ICAgICAgICAgICAgICAg IGlmIChlcnJubyA9PSBFRVhJU1QgfHwgZXJybm8gPT0gRUFDQ0VTIHx8IGVycm5vID09IEVJTlRS KQo+ICAgICAgICAgICAgICAgICAgICAgICAgY29udGludWU7Cj4gCj4gICAgICAgICAgICAgICAg LyoKPiAgICAgICAgICAgICAgICAgKiBFbHNlIGNvbXBsYWluIGFuZCBhYm9ydAo+ICAgICAgICAg ICAgICAgICAqLwo+ICAgICAgICAgICAgICAgIGVsb2coRkFUQUwsICJzZW1fb3BlbihcIiVzXCIp IGZhaWxlZDogJW0iLCBzZW1uYW1lKTsKPiAgICAgICAgfQo+IAo+ICAgICAgICAvKgo+ICAgICAg ICAgKiBVbmxpbmsgdGhlIHNlbWFwaG9yZSBpbW1lZGlhdGVseSwgc28gaXQgY2FuJ3QgYmUgYWNj ZXNzZWQKPiBleHRlcm5hbGx5Lgo+ICAgICAgICAgKiBUaGlzIGFsc28gZW5zdXJlcyB0aGF0IGl0 IHdpbGwgZ28gYXdheSBpZiB3ZSBjcmFzaC4KPiAgICAgICAgICovCj4gICAgICAgIHNlbV91bmxp bmsoc2VtbmFtZSk7Cj4gCj4gICAgICAgIHJldHVybiBteVNlbTsKPiAtLS0tCj4gCj4gLU1heAo+ IAo+IE9uIFdlZCwgSnVuIDIyLCAyMDE2IGF0IDM6MDIgQU0sIEtvbnN0YW50aW4gQmVsb3Vzb3Yg PGtvc3Rpa2JlbEBnbWFpbC5jb20+Cj4gd3JvdGU6Cj4gCj4+IE9uIFR1ZSwgSnVuIDIxLCAyMDE2 IGF0IDEyOjQ4OjAwUE0gLTA3MDAsIE1heGltIFNvYm9sZXYgd3JvdGU6Cj4+PiBUaGFua3MsIEtv bnN0YW50aW4gZm9yIHRoZSBncmVhdCB3b3JrLCB3ZSBhcmUgZGVmaW5pdGVseSBsb29raW5nIGZv cndhcmQKPj4gdG8KPj4+IGdldCBhbGwgdGhvc2UgaW1wcm92ZW1lbnRzIHRvIGJlIHBhcnQgb2Yg dGhlIGRlZmF1bHQgRnJlZUJTRCBrZXJuZWwvcG9ydC4KPj4+IFdvdWxkIGJlIG5pY2UgaWYgeW91 IGNhbiBwb3N0IGFuIHVwZGF0ZSBzb21lIGRheSBsYXRlciBhcyB0byB3aGF0J3MKPj4+IGludGVn cmF0ZWQgYW5kIHdoYXQncyBub3QuCj4+IEkgZGlkIHBvc3RlZCB0aGUgdXBkYXRlIHNldmVyYWwg ZGF5cyBlYXJsaWVyLiAgU2luY2UgeW91IHJlcGx5aW5nIHRvIHRoaXMKPj4gdGhyZWFkLCBpdCB3 b3VsZCBiZSBub3QgdW5yZWFzb25hYmxlIHRvIHJlYWQgcmVjZW50IG1lc3NhZ2VzIHRoYXQgd2Vy ZQo+PiBzZW50Lgo+PiAKPj4+IAo+Pj4gSnVzdCBpbiBjYXNlLCBJJ3ZlIG9wZW5lZCAjMTQyMDYg d2l0aCBQRyB0byBzd2l0Y2ggdXMgdG8gdXNpbmcgUE9TSVgKPj4+IHNlbWFwaG9yZXMgYnkgZGVm YXVsdC4gQXBhcnQgZnJvbSB0aGUgbWVudGlvbmVkIHBlcmZvcm1hbmNlIGJlbmVmaXRzLAo+PiBT WVNWCj4+PiBzZW1hcGhvcmVzIGFyZSBQSVRBIHRvIGRlYWwgd2l0aCBhcyB0aGV5IGNvbWUgaW4g dmVyeSBsaW1pdGVkIHF1YW50aXRpZXMKPj4gYnkKPj4+IGRlZmF1bHQuIEFsc28gdGhleSBtaWdo dCBzdGF5IGFyb3VuZCBpZiBQRyBkaWVzL2dldHMgbnVrZWQgYW5kIHByZXZlbnQgaXQKPj4+IGZy b20gc3RhcnRpbmcgYWdhaW4gZHVlIHRvIG92ZXJmbG93LiBXZSd2ZSBnb3Qgc29tZSBxdWl0ZSB1 Z2x5IGNvZGUgdG8KPj4+IGNsZWFuIHVwIHRob3NlIHVzaW5nIGlwY3JtKDEpIGluIG91ciBidWls ZCBzY3JpcHRzIHRvIGRlYWwgd2l0aCBqdXN0Cj4+IHRoYXQuCj4+PiBJIGFtIGhhcHB5IHRoYXQg Y29kZSBjb3VsZCBiZSByZXRpcmVkIG5vdy4KPj4gCj4+IE5hbWVkIHNlbWFwaG9yZXMgYWxzbyBz dHVjayBhcm91bmQgaWYgcHJvY2Vzc2VzIGFyZSBraWxsZWQgd2l0aG91dCBjbGVhbnVwLgo+PiAK Pj4gCj4gX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KPiBm cmVlYnNkLXBlcmZvcm1hbmNlQGZyZWVic2Qub3JnIG1haWxpbmcgbGlzdAo+IGh0dHBzOi8vbGlz dHMuZnJlZWJzZC5vcmcvbWFpbG1hbi9saXN0aW5mby9mcmVlYnNkLXBlcmZvcm1hbmNlCj4gVG8g dW5zdWJzY3JpYmUsIHNlbmQgYW55IG1haWwgdG8gImZyZWVic2QtcGVyZm9ybWFuY2UtdW5zdWJz Y3JpYmVAZnJlZWJzZC5vcmciCgpfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fXwpmcmVlYnNkLXBlcmZvcm1hbmNlQGZyZWVic2Qub3JnIG1haWxpbmcgbGlzdApo dHRwczovL2xpc3RzLmZyZWVic2Qub3JnL21haWxtYW4vbGlzdGluZm8vZnJlZWJzZC1wZXJmb3Jt YW5jZQpUbyB1bnN1YnNjcmliZSwgc2VuZCBhbnkgbWFpbCB0byAiZnJlZWJzZC1wZXJmb3JtYW5j ZS11bnN1YnNjcmliZUBmcmVlYnNkLm9yZyI=