On Mon, Sep 28, 2009 at 6:26 PM, Tom Lane wrote:
> Sergey Konoplev writes:
>> The table filled with about 7.5E+6 rows. Most of them have different
>> from default values in obj_tsvector column. I use "estimated rows
>> count trick" to make search results counter faster, and every time
>> when obj
Sergey Konoplev writes:
> The table filled with about 7.5E+6 rows. Most of them have different
> from default values in obj_tsvector column. I use "estimated rows
> count trick" to make search results counter faster, and every time
> when obj_tsvector is used estimation rows count is extremely dif
BTW, dead tupples <5%
On Mon, Sep 28, 2009 at 11:09 AM, Sergey Konoplev wrote:
> Hi, community
>
> I have a table containing column for FTS and an appropriate index:
>
> zzz=# \d search_table
> ...
> obj_tsvector | tsvector |
> not null default ''::tsv
Hi, community
I have a table containing column for FTS and an appropriate index:
zzz=# \d search_table
...
obj_tsvector | tsvector |
not null default ''::tsvector
...
"i_search_table__tsvector_1" gist (obj_tsvector) WHERE obj_status_did = 1
The t
