Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id A38C69F96FB for ; Sun, 19 Aug 2007 21:22:08 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 06796-04 for ; Sun, 19 Aug 2007 21:21:57 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.237]) by postgresql.org (Postfix) with ESMTP id 7262A9F96F8 for ; Sun, 19 Aug 2007 21:22:02 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id h29so1121567wxd for ; Sun, 19 Aug 2007 17:22:01 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:subject:from:reply-to:to:in-reply-to:references:content-type:date:message-id:mime-version:x-mailer:content-transfer-encoding; b=YeO9ZB0IIGJFJHPw//W8o1Bwbrq2jsXyJAyAeMD0WUdx5k4GTb9IqzSGkCzmC99+/RUlmsGHlSS9Kew6wI/5kUL2cNBzaySH35sOp5iWtUjSOf+LhB2ACuDeEddUE6dvWgAavL7WDaCi0cFgCKtCrwMN9kUlRzTL6WR3Ro0GkjM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:subject:from:reply-to:to:in-reply-to:references:content-type:date:message-id:mime-version:x-mailer:content-transfer-encoding; b=j3AuSxjOcEEtXFOzqZQ452IPpFdqzDLVPOKypEDL2zidLTvCVPiYSfMv1JKv59IVI9Gv+3Ik/Z0XTxQtnniQk+TzYygGiVdrVKL8Pv+C5h2qY7HDPnegoJSGIiiYcs3ccWlYTbIwP1PSNODX2gTNHWE2hIEWDWAUIul7xjE6Tqg= Received: by 10.70.84.6 with SMTP id h6mr9555928wxb.1187569314206; Sun, 19 Aug 2007 17:21:54 -0700 (PDT) Received: from ?192.168.3.150? ( [68.79.189.145]) by mx.google.com with ESMTPS id i12sm6791888wxd.2007.08.19.17.21.51 (version=SSLv3 cipher=RC4-MD5); Sun, 19 Aug 2007 17:21:52 -0700 (PDT) Subject: Re: schema design question From: Adam Tauno Williams Reply-To: adamtaunowilliams@gmail.com To: pgsql-performance@postgresql.org In-Reply-To: References: <20070819181216.GK28490@fetter.org> <20070819182658.GC25214@uio.no> Content-Type: text/plain Date: Sun, 19 Aug 2007 20:22:07 -0400 Message-Id: <1187569327.4568.5.camel@aleph.wmmi.net> Mime-Version: 1.0 X-Mailer: Evolution 2.8.2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/206 X-Sequence-Number: 26336 > However, it still doesn't answer my question about the EV model (where > each attribute is given its own table). Do a TABLE(object_id INT, attribute STRING, value STRING) if you just want to be able to search for objects by an attribute. But better yet look at one of the thousand object persistence systems out there, not much to be gained from re-inventing the wheel. -- Adam Tauno Williams, Network & Systems Administrator Consultant - http://www.whitemiceconsulting.com Developer - http://www.opengroupware.org