From: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
---|---|
To: | Christian Ramseyer <rc(at)networkz(dot)ch> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: FTS GIN Index Question |
Date: | 2010-09-29 10:10:00 |
Message-ID: | Pine.LNX.4.64.1009291406540.466@sn.sai.msu.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Christian,
On Wed, 29 Sep 2010, Christian Ramseyer wrote:
> Hi List
>
> I have a largish partitioned table, it has ~60 million records in each of 12
> partitions. It appears that a Full Text Index could speed up some user
> queries a lot.
>
> A quick test with an additional tsvector column revealed that this would take
> up around 35 GB of space for this column and then maybe 5 more for the gin
> index on it. As this is a lot of space (~ 480 GB), I'm a bit tempted to use a
> gin index without the separate tsvector column. However, the doc says that
> this will be slower.
do you have problem with disk space ? Searching index is usually very fast
operation, only small part of index readed. Did you checked time to read
index ?
>
> Does anyone have an idea of how much slower we're talking here? The index
> defintion would be a concatenation of two setweights(), i.e.:
>
> ... using gin(
> (setweight(to_tsvector('config',coalesce(col1,'')), 'A') ||
> setweight(to_tsvector('config',coalesce(col2,'')), 'B')))
>
> Also, general recommendations regarding full text search configurations of
> that size are very welcome.
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
From | Date | Subject | |
---|---|---|---|
Next Message | Andrus | 2010-09-29 10:11:50 | Optimizing postgresql.conf for dedicated windows server 2003 x64 standard edition |
Previous Message | Raymond O'Donnell | 2010-09-29 10:01:43 | Re: Postgresql for a CEP app |