Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TxoWF-0001he-6u for pgsql-admin@arkaria.postgresql.org; Wed, 23 Jan 2013 00:48:47 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1TxoWE-0006oA-5v for pgsql-admin@arkaria.postgresql.org; Wed, 23 Jan 2013 00:48:46 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TxoWD-0006o5-Eb for pgsql-admin@postgresql.org; Wed, 23 Jan 2013 00:48:45 +0000 Received: from [64.207.29.137] (helo=mail.illumen.com) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TxoWB-000708-6C for pgsql-admin@postgresql.org; Wed, 23 Jan 2013 00:48:44 +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 17:48:42 -0700 Message-ID: In-Reply-To: <20130123002301.120590@gmx.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] Schema design question as it pertains to performance Thread-Index: Ac34/86lDPZY97jHRMi/5ebij4MQJAAAwjEg References: <20130123002301.120590@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: 0.8 (/) 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 VGhhbmtzIGZvciB0aGUgY2xhcmlmaWNhdGlvbi4gIE5vdyBJIHVuZGVyc3Rh bmQgLSBpdCBpcyBhbiBhbGwgb3Igbm90aGluZyBkdWUgdG8gcmVxdWlyZWQg ZW50cmllcyBmb3IgZWFjaCByb3cgdmVyc2lvbiBvbiB0aGUgbWFpbiB0YWJs ZS4NCkkgd2lsbCBoYXZlIHRvIHNlZSBpZiByZW1vdmluZyB0aGUgY29uc3Rh bnRseSBjaGFuZ2luZyB2YWx1ZSBmcm9tIHRoZSBpbmRpY2VzIHdpbGwgYWZm ZWN0IHRoZSBwZXJmb3JtYW5jZSBvZiBvdXIgc2VsZWN0cy4NCg0KDQotLS0t LU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KRnJvbTogS2V2aW4gR3JpdHRuZXIg W21haWx0bzprZ3JpdHRuQG1haWwuY29tXSANClNlbnQ6IFR1ZXNkYXksIEph bnVhcnkgMjIsIDIwMTMgNToyMyBQTQ0KVG86IEJlbmphbWluIEtyYWptYWxu aWs7IHBnc3FsLWFkbWluQHBvc3RncmVzcWwub3JnDQpTdWJqZWN0OiBSRTog W0FETUlOXSBTY2hlbWEgZGVzaWduIHF1ZXN0aW9uIGFzIGl0IHBlcnRhaW5z IHRvIHBlcmZvcm1hbmNlDQoNCkJlbmphbWluIEtyYWptYWxuaWsgd3JvdGU6 DQo+IEtldmluIEdyaXR0bmVyIHdyb3RlOg0KPj4gQmVuamFtaW4gS3Jham1h bG5payB3cm90ZToNCg0KPj4+IEkgYWxzbyBhc3N1bWUgdGhhdCBpZiBubyBk YXRhIGhhcyBjaGFuZ2VkIGluIGFuIGluZGV4LCBub3RoaW5nIGlzIA0KPj4+ IGRvbmUgd2hlbiB0aGUgcmVjb3JkIGlzIHVwZGF0ZWQgYXMgcGVydGFpbnMg dG8gdGhlIHBhcnRpY3VsYXIgaW5kZXggDQo+Pj4gLSBhbSBJIGNvcnJlY3Qg aW4gdGhpcyBhc3N1bXB0aW9uPw0KPj4gDQo+PiBOby4gWy4uLl0gSWYgYW55 IGluZGV4ZWQgY29sdW1uIGlzIHVwZGF0ZWQsIFsuLi5dIGl0IG5lZWRzIG5l dyANCj4+IGVudHJpZXMgaW4gYWxsIHRoZSBpbmRleGVzLg0KDQo+IFRoYXQg d2FzIG15IGludGVudCAtIGlmIG5vIGNvbHVtbiBvZiBhbiBpbmRleCBjaGFu Z2VzIGluIGFuIHVwZGF0ZSANCj4gdGhlbiBubyBjaGFuZ2VzIGFyZSBkb25l IG9uIHRoZSBpbmRleC4NCg0KSSBkb24ndCB0aGluayB5b3UgdW5kZXJzdG9v ZCAtLSBpZiBhbnkgY29sdW1uIHJlZmVyZW5jZWQgYnkgYW55IGluZGV4IGlz IHVwZGF0ZWQsIHRoZW4gYWxsIGluZGV4ZXMgbXVzdCBnZXQgYSBuZXcgZW50 cnkgZm9yIHRoYXQgcm93IHdoZXRoZXIgb3Igbm90IHRoZXkgaW5jbHVkZSB0 aGF0IGNvbHVtbi4gVGhlIG5ldyB2ZXJzaW9uIG9mIHRoZSByb3cgd2lsbCBi ZSBhdCBhIG5ldyBsb2NhdGlvbiwgc28gbmV3IGVudHJpZXMgYXJlIG5lZWRl ZCBpbiBhbGwgaW5kZXhlcyB0byBwb2ludCB0byB0aGUgbmV3IGxvY2F0aW9u Lg0KDQpJIGRpZCAqbm90KiBzYXkgdGhhdCBvbmx5IGluZGV4ZXMgcmVmZXJl bmNpbmcgdGhlIHVwZGF0ZWQgY29sdW1uIG5lZWQgYSBuZXcgZW50cnkuDQoN Ci1LZXZpbg0KCi0tIApTZW50IHZpYSBwZ3NxbC1hZG1pbiBtYWlsaW5nIGxp c3QgKHBnc3FsLWFkbWluQHBvc3RncmVzcWwub3JnKQpUbyBtYWtlIGNoYW5n ZXMgdG8geW91ciBzdWJzY3JpcHRpb246Cmh0dHA6Ly93d3cucG9zdGdyZXNx bC5vcmcvbWFpbHByZWYvcGdzcWwtYWRtaW4K