Re: tsvector pg_stats seems quite a bit off. - Mailing list pgsql-hackers

From Jesper Krogh
Subject Re: tsvector pg_stats seems quite a bit off.
Date
Msg-id 4C03FC23.8000109@krogh.cc
Whole thread Raw
In response to Re: tsvector pg_stats seems quite a bit off.  (Jan Urbański <wulczer@wulczer.org>)
Responses Re: tsvector pg_stats seems quite a bit off.
List pgsql-hackers
On 2010-05-30 20:02, Jan Urbański wrote:
> Here's a patch against recent git, but should apply to 8.4 sources as
> well. It would be interesting to measure the memory and time needed to
> analyse the table after applying it, because we will be now using a lot
> bigger bucket size and I haven't done any performance impact testing on
> it. I updated the initial comment block in compute_tsvector_stats, but
> the prose could probably be improved.
>    
Just a small follow up. I tried out the patch (or actually a fresh git
checkout) and it now gives very accurate results for both upper and
lower end of the MCE-histogram with a lower cutoff that doesn't
approach 2.

Thanks alot.

-- 
Jesper


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: 9.0b1: "ERROR: btree index keys must be ordered by attribute"
Next
From: Tom Lane
Date:
Subject: Re: tsvector pg_stats seems quite a bit off.