From: Ron Mayer <rm_pg@cheapcomplexdevices.com>
To: Jay Kang <arrival123@gmail.com>
Subject: Re: Questions on Tags table schema
Date: Mon, 30 Jul 2007 13:40:31 -0700
Message-ID: <46AE4CBF.5090707@cheapcomplexdevices.com> (raw)
In-Reply-To: <d251ee4a0707290722k50de5789lad616cb168791058@mail.gmail.com>
References: <d251ee4a0707290722k50de5789lad616cb168791058@mail.gmail.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: rm_pg@cheapcomplexdevices.com, arrival123@gmail.com
Subject: Re: Questions on Tags table schema
In-Reply-To: <46AE4CBF.5090707@cheapcomplexdevices.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox