Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Questions on Tags table schema
- From: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
- To: Jay Kang <arrival123(at)gmail(dot)com>
- To: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Questions on Tags table schema
- Date: Mon, 30 Jul 2007 13:40:31 -0700
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.
- References:
- Questions on Tags table schema
- From: Jay Kang
- Questions on Tags table schema
- Prev by Date: Re: Slow query with backwards index scan
- Next by Date: Re: Postgres configuration for 64 CPUs, 128 GB RAM...
- Previous by thread: Re: Questions on Tags table schema
- Next by thread: Query optimization....
- Indexes: