Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 705E01337B5E for ; Thu, 3 Feb 2011 15:21:54 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 84084-07 for ; Thu, 3 Feb 2011 19:21:47 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp02.lnh.mail.rcn.net (smtp02.lnh.mail.rcn.net [207.172.157.102]) by mail.postgresql.org (Postfix) with ESMTP id 67EB81337B5D for ; Thu, 3 Feb 2011 15:21:46 -0400 (AST) Received: from ms14.lnh.mail.rcn.net ([208.58.56.82]) by smtp02.lnh.mail.rcn.net with ESMTP; 03 Feb 2011 14:21:46 -0500 Received: (from ms14.lnh.mail.rcn.net [69.183.59.115]) by ms14.lnh.mail.rcn.net (MOS 4.1.9-GA) with HTTP/1.1 id BAY71855 (AUTH gnuoytr@rcn.com); Thu, 3 Feb 2011 14:21:45 -0500 (EST) From: Subject: Re: getting the most of out multi-core systems for repeated complex SELECT statements To: pgsql-performance@postgresql.org X-Mailer: Mirapoint Webmail Direct 4.1.9-GA MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 Message-Id: <20110203142145.BAY71855@ms14.lnh.mail.rcn.net> Date: Thu, 3 Feb 2011 14:21:45 -0500 (EST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201102/102 X-Sequence-Number: 42240 DQoNCi0tLS0gT3JpZ2luYWwgbWVzc2FnZSAtLS0tDQo+RGF0ZTogVGh1LCAzIEZlYiAyMDEx IDE4OjU2OjM0ICswMTAwDQo+RnJvbTogcGdzcWwtcGVyZm9ybWFuY2Utb3duZXJAcG9zdGdy ZXNxbC5vcmcgKG9uIGJlaGFsZiBvZiBBbGpvxaFhIE1vaG9yb3ZpxIcgPGFsam9zYS5tb2hv cm92aWNAZ21haWwuY29tPikNCj5TdWJqZWN0OiBSZTogW1BFUkZPUk1dIGdldHRpbmcgdGhl IG1vc3Qgb2Ygb3V0IG11bHRpLWNvcmUgc3lzdGVtcyBmb3IgcmVwZWF0ZWQgY29tcGxleCBT RUxFQ1Qgc3RhdGVtZW50cyAgDQo+VG86IGdudW95dHJAcmNuLmNvbQ0KPkNjOiBwZ3NxbC1w ZXJmb3JtYW5jZUBwb3N0Z3Jlc3FsLm9yZw0KPg0KPk9uIFRodSwgRmViIDMsIDIwMTEgYXQg NDo1NyBQTSwgIDxnbnVveXRyQHJjbi5jb20+IHdyb3RlOg0KPj4gVGltZSBmb3IgbXkgcGV0 IG1lbWUgdG8gd2lnZ2xlIG91dCBvZiBpdHMgaG9sZSAobmV4dCB0byBQaGlsJ3MsIGFuZCBh IGRheSBsYXRlcikuIMKgRm9yIFBHIHRvIHByb3NwZXIgaW4gdGhlIGZ1dHVyZSwgaXQgaGFz IHRvIGVtYnJhY2UgdGhlIG11bHRpLWNvcmUvcHJvY2Vzc29yL1NTRCBtYWNoaW5lIGF0IHRo ZSBxdWVyeSBsZXZlbC4gwqBJdCBoYXMgdG8uIMKgQW5kIGl0IGhhcyB0byBiZWNhdXNlIHRo ZSBCaWcgQm95cyBhbHJlYWR5IGRvIHNvLCB0byBzb21lIGV4dGVudCwgYW5kIHRoZXkndmUg cmVhbGl6ZWQgdGhhdCB0aGUgQkNORiBzY2hlbWEgb24gc3VjaCBtYWNoaW5lcyBpcyBzdXBy ZW1lbHkgZWZmaWNpZW50LiDCoFBHL015U3FsL09TRW5naW5lT2ZDaG9pY2Ugd2lsbCBnZXQg bGVmdCBiZWhpbmQgc2ltcGx5IGJlY2F1c2UgdGhlIGVmZmljaWVuY3kgb2ZmZXJlZCB3aWxs IGJlIHdvcnRoIHRoZSBwcmljZS4NCj4NCj50aGlzIGtpbmQgb2YgdmlldyBvbiB3aGF0IHBv c3RncmVzIGNvbW11bml0eSBoYXMgdG8gZG8gY2FuIG9ubHkgYmUNCj50cnVlIGlmIHBvc3Rn cmVzIGhhcyBubyBpbnRlbnRpb24gdG8gc3VwcG9ydCAiY2xvdWQgZW52aXJvbm1lbnRzIiBv cg0KPmFueSBraW5kIG9mIGhhcmR3YXJlIHZpcnR1YWxpemF0aW9uLg0KPndoaWxlIGknbSBz dXJlIHRhcmdldGluZyBzcGVjaWZpYyBoYXJkd2FyZSBmZWF0dXJlcyBjYW4gZ3JlYXRseQ0K PmltcHJvdmUgcG9zdGdyZXMgcGVyZm9ybWFuY2UgaXQgc2hvdWxkIGJlIGFuIG9wdGlvbiBu b3QgYSByZXF1aXJlbWVudC4NCg0KQmVpbmcgYW4gb3B0aW9uIGlzIGp1c3QgZmluZS4gIEl0 J3Mgbm90IHRoZXJlIG5vdy4gIEFzc2VydGluZyB0aGF0IHRoZSBjbG91ZCBtZW1lLCBiYXNl ZCBvbiBsb3dlc3QgY29zdCBtYXJnaW5hbCBoYXJkd2FyZSwgc2hvdWxkIGRpY3RhdGUgYSBk YXRhYmFzZSBlbmdpbmUgaXMgcHV0dGluZyB0aGUgY2FydCBiZWZvcmUgdGhlIGhvcnNlLg0K DQoNCj5mb3JjaW5nIHVzZXJzIHRvIGhhdmUgc3BlY2lmaWMgaGFyZHdhcmUgaXMgYmFzaWNh bGx5IHRlbGxpbmcgdXNlcnMNCj50aGF0IHlvdSBjYW4gZm9yZ2V0IGFib3V0IHVzaW5nIHBv c3RncmVzIGluIGFtYXpvbi9yYWNrc3BhY2UgY2xvdWQNCj5lbnZpcm9ubWVudHMgKG9yIGFu eSBzaW1pbGFyIGVudmlyb25tZW50KS4NCg0KSnVzdCBub3Qgb24gY2hlYXAgY2xvdWRzLCBp ZiB0aGV5IHdhbnQgbWF4aW1hbCBwZXJmb3JtYW5jZSBmcm9tIHRoZSBlbmdpbmUgdXNpbmcg QkNORiBzY2hlbWFzLiAgUmVwbGljYXRpbmcgQ09CT0wvVlNBTS9mbGF0ZmlsZSBhcHBsaWNh dGlvbnMgaW4gYW55IHJlbGF0aW9uYWwgZGF0YWJhc2UgZW5naW5lIGlzIG1lcmVseSBkZWx1 ZGluZyBvbmVzZWxmLiAgDQoNCg0KPmknbSBzdXJlIHRoYXQgYSBsYXJnZSBwYXJ0IG9mIHBv c3RncmVzIGNvbW11bml0eSBkb2Vzbid0IGNhcmUgYWJvdXQNCj4iY2xvdWQgZW52aXJvbm1l bnRzIiAoYWx0aG91Z2ggdGhpcyBpcyBvbmx5IG15IHBlcnNvbmFsIGltcHJlc3Npb24pDQo+ YnV0IGlmIHBsYW4gaXMgdG8gZGlzYWJsZSBwb3N0Z3JlcyB1c2FnZSBpbiBzdWNoIGVudmly b25tZW50cyB5b3UgYXJlDQo+YmFzaWNhbGx5IGxvb3NpbmcgYSBsYXJnZSBwYXJ0IG9mIGRl dmVsb3BlcnMvY29tcGFuaWVzIHRhcmdldGluZw0KPmdsb2JhbCBpbnRlcm5ldCBjb25zdW1l cnMgd2l0aCB0aGVpciBvbmxpbmUgcHJvZHVjdHMuDQo+Y2xvdWQgZW52aXJvbm1lbnRzIGFy ZSBjdXJyZW50bHkgdGhlIGJlc3QgcGxhdGZvcm0gZm9yIGludGVybmV0DQo+b3JpZW50ZWQg ZGV2ZWxvcGVycy9jb21wYW5pZXMgdG8gc3RhcnQgYSBuZXcgcHJvamVjdCBvciBldmVuIHRv DQo+bWlncmF0ZSBmcm9tIGN1c3RvbSBoYXJkd2FyZS9kZWRpY2F0ZWQgZGF0YSBjZW50ZXIu DQo+DQo+PiBNdWNoIGFzIGl0IHBhaW5zIG1lIHRvIHNheSBpdCwgYnV0IHRoZSBNaWNyb1Nv ZnQgYXBwcm9hY2ggdG8gc29mdHdhcmU6IHdyaXRlIHRvIHRoZSBuZXh0IGdlbmVyYXRpb24g cHJvY2Vzc29yIGFuZCBmb3JjZSB1c2VycyB0byB1cGdyYWRlLCB3aWxsIGJlIHRoZSB3aW5u aW5nIHN0cmF0ZWd5IGZvciBkYXRhYmFzZSBlbmdpbmVzLiDCoFRoZXJlJ3MganVzdCB3YXkg dG9vIG11Y2ggdG8gZ2Fpbi4NCj4NCj5pdCBjYW4gYXJndWFibHkgYmUgc2FpZCB0aGF0IGJl Y2F1c2Ugb2YgdGhpcyBhcHByb2FjaCBtaWNyb3NvZnQgaXMNCj5sb3NpbmcgZ3JvdW5kIGlu IG1vc3Qgb2YgdGhlaXIgYnVzaW5lc3Nlcy9zdHJhdGVnaWVzLg0KDQpOb3QgcmVhbGx5LiAg TWljcm9Tb2Z0IGlzIGxvc2luZyBncm91bmQgZm9yIHRoZSBzYW1lIHJlYXNvbiBhbGwgb3Ro ZXIgY2xpZW50L3N0YW5kYWxvbmUgYXBwbGljYXRpb25zIGFyZTogIHN1Y2ggYXBwbGljYXRp b25zIGRvbid0IHJ1biBhbnkgYmV0dGVyIG9uIG11bHRpLWNvcmUvcHJvY2Vzc29yIG1hY2hp bmVzLiAgQWRkIGluIHRoZSBuZXRib29rL3Bob25lIGRldmljZXMsIGFuZCB0aGF0IHRoZXkg Y2FuJ3Qgc2VlbSB0byBtYWtlIGEgdmVyc2lvbiBvZiB3aW5kb3dzIHRoYXQncyBtYXJrZWRs eSBiZXR0ZXIgdGhhbiBYUC4gIEFyZ3VhYmx5IE1pY3JvU29mdCBpcyBmYWlsaW5nICpiZWNh dXNlIE9mZmljZSBubyBsb25nZXIgcmVxdWlyZXMqIHRoZSBuZXh0IGdlbmVyYXRpb24gaGFy ZHdhcmUgdG8gcnVuIHJpZ2h0LiAgSG1tPyAgTGludXggcHJvc3BlcnMgYmVjYXVzZSBpdCdz IGEgc2VydmVyIE9TLCBsYXJnZWx5LiAgRGVza3RvcCBtYXksIG9yIG1heSBub3QsIHJlbWFp biByZWxldmFudC4gIExpbnV4IGRvZXMgbWFrZSBnb29kIHVzZSBvZiBzdWNoIG1hY2hpbmVz LiAgTWljcm9Tb2Z0IGFwcGxpY2F0aW9ucz8gIE5vdCBzbyBtdWNoLiANCj4NCj5BbGpvc2Eg TW9ob3JvdmljDQo+DQo+LS0gDQo+U2VudCB2aWEgcGdzcWwtcGVyZm9ybWFuY2UgbWFpbGlu ZyBsaXN0IChwZ3NxbC1wZXJmb3JtYW5jZUBwb3N0Z3Jlc3FsLm9yZykNCj5UbyBtYWtlIGNo YW5nZXMgdG8geW91ciBzdWJzY3JpcHRpb246DQo+aHR0cDovL3d3dy5wb3N0Z3Jlc3FsLm9y Zy9tYWlscHJlZi9wZ3NxbC1wZXJmb3JtYW5jZQ0K