Skip site navigation (1) Skip section navigation (2)

Re: Questions on Tags table schema

From: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
To: Jay Kang <arrival123(at)gmail(dot)com>
Subject: Re: Questions on Tags table schema
Date: 2007-07-30 20:40:31
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
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.

In response to

pgsql-performance by date

Next:From: DimitriDate: 2007-07-30 21:26:03
Subject: Re: Postgres configuration for 64 CPUs, 128 GB RAM...
Previous:From: Nis JørgensenDate: 2007-07-30 20:05:14
Subject: Re: Slow query with backwards index scan

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group