Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id F00342E0057 for ; Tue, 19 Feb 2008 11:48:16 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 56376-06 for ; Tue, 19 Feb 2008 11:48:08 -0400 (AST) Received: from hook.sigaev.ru (hook.sigaev.ru [212.192.243.50]) by postgresql.org (Postfix) with ESMTP id 4F9902E00BB for ; Tue, 19 Feb 2008 11:46:37 -0400 (AST) Received: by hook.sigaev.ru (Postfix, from userid 1003) id A1F96398F1; Tue, 19 Feb 2008 18:46:34 +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 19A2E398E4; Tue, 19 Feb 2008 18:46:24 +0300 (MSK) Message-ID: <47BAF9D0.3070404@sigaev.ru> Date: Tue, 19 Feb 2008 18:46:24 +0300 From: Teodor Sigaev User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.8.1.11) Gecko/20071204 SeaMonkey/1.1.7 MIME-Version: 1.0 To: Magnus Hagander CC: Tom Lane , 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/67 X-Sequence-Number: 4919 Magnus, could you provide dump of tsvector column of archive search? I'll make a test with and without Tom's patch. >>> I have not done any performance testing of these changes --- does >>> anyone have specific test scenarios they'd like to try? -- Teodor Sigaev E-mail: teodor@sigaev.ru WWW: http://www.sigaev.ru/