On Mon, 2008-09-29 at 12:32 +0200, Jérôme Jouanin wrote:
Upgrade 8.3.4 is available. Before compiling, I have to apply the
optimized toast patch : bin7hetTGkMRL.bin.
There are differences in 1 of the 3 files patched : tuptoaster.c
The patch runs successfully but before installing on
Gregory Stark [EMAIL PROTECTED] writes:
Tom Lane [EMAIL PROTECTED] writes:
* Adds an early-failure path to the compressor as suggested by Jan:
if it's been unable to find even one compressible substring in the
first 1KB (parameterizable), assume we're looking at incompressible
input and give
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
On 2/18/2008 5:33 AM, Gregory Stark wrote:
Tom Lane [EMAIL PROTECTED] writes:
* Adds an early-failure path to the compressor as suggested by Jan:
if it's been unable to find even one compressible substring in the
first 1KB (parameterizable), assume we're looking at incompressible
input and
On Tue, Feb 19, 2008 at 06:46:24PM +0300, Teodor Sigaev wrote:
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
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
Teodor Sigaev [EMAIL PROTECTED] writes:
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