From: Teodor Sigaev <teodor@sigaev.ru>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-patches@postgresql.org, Gregory Stark <stark@enterprisedb.com>
Cc: Jan Wieck <JanWieck@Yahoo.com>
Subject: Re: Proposed patch to change TOAST compression strategy
Date: Fri, 29 Feb 2008 15:41:05 +0300
Message-ID: <47C7FD61.3050205@sigaev.ru> (raw)
In-Reply-To: <25566.1203360760@sss.pgh.pa.us>
References: <26048.1203271939@sss.pgh.pa.us>
<47B95782.7090302@sigaev.ru>
<25566.1203360760@sss.pgh.pa.us>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-patches@postgresql.org
Cc: teodor@sigaev.ru, tgl@sss.pgh.pa.us, stark@enterprisedb.com, JanWieck@Yahoo.com
Subject: Re: Proposed patch to change TOAST compression strategy
In-Reply-To: <47C7FD61.3050205@sigaev.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox