Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TxmJA-0002TC-EM for pgsql-admin@arkaria.postgresql.org; Tue, 22 Jan 2013 22:27:08 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1TxmJ9-0007l2-GH for pgsql-admin@arkaria.postgresql.org; Tue, 22 Jan 2013 22:27:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TxmJ8-0007kr-IV for pgsql-admin@postgresql.org; Tue, 22 Jan 2013 22:27:06 +0000 Received: from [64.207.29.137] (helo=mail.illumen.com) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TxmJ7-0008Ao-3h for pgsql-admin@postgresql.org; Tue, 22 Jan 2013 22:27:05 +0000 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 Subject: Re: Schema design question as it pertains to performance Date: Tue, 22 Jan 2013 15:27:03 -0700 Message-ID: In-Reply-To: <20130122215601.120610@gmx.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] Schema design question as it pertains to performance Thread-Index: Ac3460ctKQBvo2sPTomWDos0ABst5QAAsFdw References: <20130122215601.120610@gmx.com> From: "Benjamin Krajmalnik" To: "Kevin Grittner" , X-Host-Lookup-Failed: Reverse DNS lookup failed for 64.207.29.137 (failed) X-Pg-Spam-Score: -1.1 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org VGhhbmtzLCBLZXZpbi4NClRoYXQgd2FzIG15IGludGVudCAtIGlmIG5vIGNv bHVtbiBvZiBhbiBpbmRleCBjaGFuZ2VzIGluIGFuIHVwZGF0ZSB0aGVuIG5v IGNoYW5nZXMgYXJlIGRvbmUgb24gdGhlIGluZGV4Lg0KVGhhdCBoZWxwcyBx dWl0ZSBhIGJpdCAtIEkgd2lsbCB0cnkgbW92aW5nIHRoZSBjb2x1bW5zIHdo aWNoIGNoYW5nZSBjb250aW51b3VzbHkgdG8gdGhlaXIgb3duIGluZGV4IC0g aG9wZWZ1bGx5IHRoaXMgd2lsbCB0YW1lIHRoZSBvdmVyd2hlbG1pbmcgSU8s IHNpbmNlIHRoZSBpbmRleCB3aWxsIG5vdyBoYXZlIGEgc2luZ2xlIGNvbHVt bi4gIEkgYW0gc2VlaW5nIHRvbyBtYW55IHNlbXdhaXRzIG9yIHVmcyBzdGF0 ZXMgd2hlbiBydW5uaW5nIHRvcCwgd2hpY2ggbWVhbnMgd2UgYXJlIG5vdCBx dWl0ZSBrZWVwaW5nIHVwLg0KQSBsb3Qgb2YgdGhlIGxvYWQgaGFzIGJlZW4g b2ZmbG9hZGVkIHRvIHRoZSByZWFkIG9ubHkgaG90IHN0YW5kYnkgLSB0aGFu a3MgZm9yIHRoZSBwb2ludGVycyBvbiB0aGUgZGVsYXlzLiAgSSBvbmx5IGhh ZCBvbmUgcXVlcnkgY2FuY2VsbGVkIHRvZGF5IChhcyBvcHBvc2VkIHRvIG1h bnkgcHJldmlvdXNseSksIHNvIGl0IGlzIGp1c3QgYSBtYXR0ZXIgb2YgZmlu ZSB0dW5pbmcgcmlnaHQgbm93Lg0KDQoNCi0tLS0tT3JpZ2luYWwgTWVzc2Fn ZS0tLS0tDQpGcm9tOiBLZXZpbiBHcml0dG5lciBbbWFpbHRvOmtncml0dG5A bWFpbC5jb21dIA0KU2VudDogVHVlc2RheSwgSmFudWFyeSAyMiwgMjAxMyAy OjU2IFBNDQpUbzogQmVuamFtaW4gS3Jham1hbG5pazsgcGdzcWwtYWRtaW5A cG9zdGdyZXNxbC5vcmcNClN1YmplY3Q6IFJlOiBbQURNSU5dIFNjaGVtYSBk ZXNpZ24gcXVlc3Rpb24gYXMgaXQgcGVydGFpbnMgdG8gcGVyZm9ybWFuY2UN Cg0KQmVuamFtaW4gS3Jham1hbG5payB3cm90ZToNCg0KPiBGcm9tIGEgcGVy Zm9ybWFuY2Ugc3RhbmRwb2ludCwgaXMgdGhlcmUgYSBiaWcgaGl0IG9uIHNl bGVjdCANCj4gcGVyZm9ybWFuY2UgaWYgYSBxdWVyeSBlbmRzIHVwIHV0aWxp emluZyBtb3JlIHRoYW4gb25lIGluZGV4LCB0YWtpbmcgDQo+IGludG8gYWNj b3VudCB0aGF0IGFuIGluZGV4IGhhcyBiZWVuIHVzZWQgYWxyZWFkeSB0byBy ZWR1Y2UgdGhlIGRhdGEgDQo+IHNldCBvZiBwb3RlbnRpYWwgcmVjb3Jkcywg YW5kIHRoZSBzZWNvbmRhcnkgaW5kZXggd291bGQgbW9zdGx5IGJlIHVzZWQg DQo+IGluIHRoZSBvcmRlcmluZyBvZiB0aGUgcmVzdWx0IHNldCAoc3VjaCBh cyBhIGxhc3QgdXBkYXRlZCB0aW1lKT8NCg0KVGhhdCBkZXBlbmRzIG9uIHNv IG1hbnkgdmFyaWFibGVzIGl0IGlzIGhhcmQgdG8gZ2l2ZSBhIHNpbXBsZSBh bnN3ZXIuDQoNCj4gSSBhbHNvIGFzc3VtZSB0aGF0IGlmIG5vIGRhdGEgaGFz IGNoYW5nZWQgaW4gYW4gaW5kZXgsIG5vdGhpbmcgaXMgZG9uZSANCj4gd2hl biB0aGUgcmVjb3JkIGlzIHVwZGF0ZWQgYXMgcGVydGFpbnMgdG8gdGhlIHBh cnRpY3VsYXIgaW5kZXggLSBhbSBJIA0KPiBjb3JyZWN0IGluIHRoaXMgYXNz dW1wdGlvbj8NCg0KTm8uIElmIHRoZSB1cGRhdGUgZG9lc24ndCBhZmZlY3Qg KmFueSogaW5kZXhlZCBjb2x1bW4sIGFuZCB0aGVyZSBpcyByb29tIGluIHRo ZSBwYWdlLCBpdCB3aWxsIGRvIGEgSE9UIHVwZGF0ZSBhbmQgY2FuIHNraXAg YWxsIGluZGV4IHVwZGF0ZXMuIElmIGFueSBpbmRleGVkIGNvbHVtbiBpcyB1 cGRhdGVkLCBpdCBtdXN0IGV4cGlyZSB0aGUgb2xkIHR1cGxlIGFuZCBjcmVh dGUgYSBuZXcgdHVwbGUgdG8gcmVwcmVzZW50IHRoZSB1cGRhdGVkIHZlcnNp b24gb2YgdGhlIHJvdywgYW5kIHRoaXMgbmV3IHR1cGxlIGlzIG5vdCBsaWtl bHkgdG8gbGFuZCBpbiB0aGUgc2FtZSBwYWdlIGFzIHRoZSBvbGQgdHVwbGU7 IHNvIGl0IG5lZWRzIG5ldyBlbnRyaWVzIGluIGFsbCB0aGUgaW5kZXhlcy4g VGhlIG9sZCBpbmRleCBlbnRyaWVzIG11c3QgcmVtYWluIHVudGlsIHRoZXkg Y2FuIG5vIGxvbmdlciBiZSB0aGUgdmlzaWJsZSB2ZXJzaW9uIG9mIHRoZSBy b3cgZm9yIGFueSBkYXRhYmFzZSB0cmFuc2FjdGlvbiwgc28gYm90aCB2ZXJz aW9ucyBvZiB0aGUgcm93IHdpbGwgYmUgb24gdGhlIGluZGV4IGZvciBhIHdo aWxlLg0KDQotS2V2aW4NCgotLSAKU2VudCB2aWEgcGdzcWwtYWRtaW4gbWFp bGluZyBsaXN0IChwZ3NxbC1hZG1pbkBwb3N0Z3Jlc3FsLm9yZykKVG8gbWFr ZSBjaGFuZ2VzIHRvIHlvdXIgc3Vic2NyaXB0aW9uOgpodHRwOi8vd3d3LnBv c3RncmVzcWwub3JnL21haWxwcmVmL3Bnc3FsLWFkbWluCg==