Re: Proposed patch to change TOAST compression strategy

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Teodor Sigaev <teodor(at)sigaev(dot)ru>
Cc: pgsql-patches(at)postgresql(dot)org, Gregory Stark <stark(at)enterprisedb(dot)com>, Jan Wieck <JanWieck(at)Yahoo(dot)com>
Subject: Re: Proposed patch to change TOAST compression strategy
Date: 2008-02-18 18:52:40
Message-ID: 25566.1203360760@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Teodor Sigaev <teodor(at)sigaev(dot)ru> 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 me that ranking test
> will be very clear: rank function reads whole tsvector and returns small amount
> of data (just a number).

I have no test data sets with large tsvector fields. If you do, could
you try it with this patch and see what the results are like?

regards, tom lane

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2008-02-18 19:22:03 Re: tzcode update
Previous Message Peter Eisentraut 2008-02-18 16:49:05 Backend makefile refactoring