I didn't see any improvement in terms of size of the index (14 MB for
642 738 rows in the index in both cases) or speed.
Our dictionary table contains 78367 words and its size is 3 MB.

Did I miss something?
Comparing integers is cheaper than strings. Although it hasn't significant matter for index scan.

The attached patch adds a RECHECK too. It seems to work correctly but
the RECHECK COND costs a lot of time :/.

:(

How long is average length of strings in table?
--
Teodor Sigaev                                   E-mail: [EMAIL PROTECTED]
                                                   WWW: http://www.sigaev.ru/

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to