Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 0348C9F97E1 for ; Sun, 19 Aug 2007 11:24:08 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 71057-02 for ; Sun, 19 Aug 2007 11:23: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.233]) by postgresql.org (Postfix) with ESMTP id 9A23F9F97DC for ; Sun, 19 Aug 2007 11:24:03 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id h29so1016551wxd for ; Sun, 19 Aug 2007 07:24:02 -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=U0fTEbAZ5edIFR4sRjN9xmmAH7uENXSr6Uimf2R7erpqgmCQ/tGGOV4t45xV5GGJnPwwhlpWYtVsSbJ4NNpalAeiwblSTcQtEPLua0D1Ct8KDM+OuOqMUxTRX304zwyP6lHC9zWT+c/BXlhyxo5XAOq584wjR2ouLLxmwlVwgmI= 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=c3Ebe/po3HEYD6uUaTylhHFwe6UFwU57BKgU+9tcQ3Ia2iKC64tKyR0SGcqJn7mxOtSny2jrZYm2qvhy3MppOQ31DROkZbqFsGa7TOFPCKt1Xxik+DpUP9dVvNIrT3xax7rox4KWdcS6kM8p4uBbtphZsotNvpbHcvDxfV9qD6I= Received: by 10.70.123.14 with SMTP id v14mr8803241wxc.1187533441533; Sun, 19 Aug 2007 07:24:01 -0700 (PDT) Received: from ?192.168.3.150? ( [68.79.189.145]) by mx.google.com with ESMTPS id i18sm6208646wxd.2007.08.19.07.23.59 (version=SSLv3 cipher=RC4-MD5); Sun, 19 Aug 2007 07:23:59 -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: Content-Type: text/plain Date: Sun, 19 Aug 2007 10:24:14 -0400 Message-Id: <1187533454.4416.0.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/194 X-Sequence-Number: 26324 > Maybe not completely the wright place to ask but... I have this schema > design question (db is postgres of course). I have a couple of classes > with attributes. The only goal is to search the object that I want to > find (which is stored on the harddrive). > I have hundreds of classes that are similar but not the same. They all > have attributes/properties (type is probably String), e.g. (in pseudo > code): Use table inheritance. -- Adam Tauno Williams, Network & Systems Administrator Consultant - http://www.whitemiceconsulting.com Developer - http://www.opengroupware.org