Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 3FB432E009C for ; Fri, 29 Feb 2008 09:11:44 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 66113-02 for ; Fri, 29 Feb 2008 09:11:31 -0400 (AST) X-Greylist: delayed 00:30:16.448866 by SQLgrey-1.7.5 Received: from hook.sigaev.ru (hook.sigaev.ru [212.192.243.50]) by postgresql.org (Postfix) with ESMTP id 8F4882E00C6 for ; Fri, 29 Feb 2008 09:11:38 -0400 (AST) Received: by hook.sigaev.ru (Postfix, from userid 1003) id D5FCD398F1; Fri, 29 Feb 2008 15:41:18 +0300 (MSK) Received: from xor.sai.msu.ru (xor.sai.msu.ru [212.192.243.97]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by hook.sigaev.ru (Postfix) with ESMTP id 906DD398E4; Fri, 29 Feb 2008 15:41:06 +0300 (MSK) Message-ID: <47C7FD61.3050205@sigaev.ru> Date: Fri, 29 Feb 2008 15:41:05 +0300 From: Teodor Sigaev User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.8.1.11) Gecko/20080227 SeaMonkey/1.1.7 MIME-Version: 1.0 To: Tom Lane CC: pgsql-patches@postgresql.org, Gregory Stark , Jan Wieck Subject: Re: Proposed patch to change TOAST compression strategy References: <26048.1203271939@sss.pgh.pa.us> <47B95782.7090302@sigaev.ru> <25566.1203360760@sss.pgh.pa.us> In-Reply-To: <25566.1203360760@sss.pgh.pa.us> Content-Type: text/plain; charset=KOI8-R; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/184 X-Sequence-Number: 5036 Tsvector dump (taken by Magnus from mail archives of pgsql's lists) http://www.sigaev.ru/misc/tstest.sql.bz2 Query: select sum(ts_rank( vector, 'asdfjkl' )) from tstest ; ts_rank detoasts value in any case, even tsvector doesn't contain needed lexemes. Test was on my notebook: Core2 Duo 1.8MHz, 2Gb with default postgres.conf 8.4 without patch: Time: 10883,368 ms 8.4 with patch (db was reinited) Time: 9654,266 ms -- Teodor Sigaev E-mail: teodor@sigaev.ru WWW: http://www.sigaev.ru/