Re: [GENERAL] FTS GIN Index Question

2010-09-29 Thread Christian Ramseyer
On 09/29/2010 12:10 PM, Oleg Bartunov wrote: 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

Re: [GENERAL] FTS GIN Index Question

2010-09-29 Thread Oleg Bartunov
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

[GENERAL] FTS GIN Index Question

2010-09-28 Thread Christian Ramseyer
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 an