Re: Using a GIN index on an integer array to model sets of tags

From: "T(dot) E(dot) Lawrence" <t(dot)e(dot)lawrence(at)icloud(dot)com>
To: Mike Jarmy <mjarmy(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Using a GIN index on an integer array to model sets of tags
Date: 2012-11-17 16:39:20
Message-ID: D587E3E7-0721-47FD-AFFC-9C3635E2C64B@icloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> I am researching how to set up a schema for querying a set of tags
> associated with an object.

I would be interested in hearing your conclusions.

I am currently researching in a similar direction.

We have streaming replication where the slaves are used for data mining, storing currently about 100m objects and expected to grow in direction of 1-2b or more.

While part of the data is stored in a classic RDBM model, there are "soft" properties, for which we are looking for "soft" and in the same time, if possible, searchable/indexable storage.

So far I have mostly looked into hstore and JSON, but arrays are an interesting option, as well.

The only conclusion which we have reached so far is that we should divorce the core storage from search optimization and from versioning.

T.E.L.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2012-11-17 19:33:07 Re: 9.2 streaming replication issue and solution strategy
Previous Message Любен Каравелов 2012-11-17 16:01:41 Re: Parser - Query Analyser