Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 874829FB7DC for ; Mon, 30 Jul 2007 17:40:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 73491-09 for ; Mon, 30 Jul 2007 17:40:27 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 97F669FB609 for ; Mon, 30 Jul 2007 17:40:27 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 25E5631440; Mon, 30 Jul 2007 22:40:26 +0200 (MET DST) From: Ron Mayer X-Newsgroups: pgsql.performance Subject: Re: Questions on Tags table schema Date: Mon, 30 Jul 2007 13:40:31 -0700 Organization: Hub.Org Networking Services Lines: 11 Message-ID: <46AE4CBF.5090707@cheapcomplexdevices.com> References: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org To: Jay Kang User-Agent: Icedove 1.5.0.10 (X11/20070329) In-Reply-To: To: pgsql-performance@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.03 tagged_above=0 required=5 tests=AWL=0.029, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200707/429 X-Sequence-Number: 26113 Jay Kang wrote: > Hello, > > I'm currently trying to decide on a database design for tags in my web > 2.0 application. The problem I'm facing is that I have 3 separate tables > i.e. cars, planes, and schools. All three tables need to interact with > the tags, so there will only be one universal set of tags for the three > tables. It strikes me that some tsearch2 ts_vector like datatype might work well for this; depending on the types of queries you're doing.