Message-ID: <47B95782.7090302@sigaev.ru>
Date: Mon, 18 Feb 2008 13:01:38 +0300
From: Teodor Sigaev <teodor@sigaev.ru>
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: Tom Lane <tgl@sss.pgh.pa.us>
CC: pgsql-patches@postgreSQL.org, Gregory Stark <stark@enterprisedb.com>,
	Jan Wieck <JanWieck@Yahoo.com>
Subject: Re: Proposed patch to change TOAST compression strategy
References: <26048.1203271939@sss.pgh.pa.us>
In-Reply-To: <26048.1203271939@sss.pgh.pa.us>
Content-Type: text/plain; charset=KOI8-R; format=flowed
Content-Transfer-Encoding: 7bit

 > This proposed patch addresses some issues in TOAST compression strategy that
> I have not done any performance testing of these changes --- does
> anyone have specific test scenarios they'd like to try?

That's very important change for text search, because of tsvector storage. 
Headline and rank reads a lot of tsvectors. It seems to me that ranking test 
will be very clear: rank function reads whole tsvector and returns small amount 
of data (just a number).

Another testing focus may be a lossy indexes, like a index over polygons.

-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/