| From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-docs(at)postgresql(dot)org |
| Subject: | Re: Tsearch docs question |
| Date: | 2007-10-26 21:14:08 |
| Message-ID: | 1193433248.7624.88.camel@dogma.ljc.laika.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
On Fri, 2007-10-26 at 15:26 -0400, Tom Lane wrote:
> Are you looking at CVS HEAD, or what was there in beta1? I rewrote
> that stuff a few days ago:
> http://developer.postgresql.org/pgdocs/postgres/textsearch-indexes.html
>
Excellent, thanks, that's a big improvement to those docs all around. I
should have checked the latest before posting, almost everything I
mentioned was already addressed.
There's still one very minor thing:
"A GiST index is lossy, meaning it is necessary to check the actual
table row to eliminate false matches."
could be changed to something like:
"A GiST index is lossy, meaning that the index may produce false
matches, and it is necessary to check the actual table row before
eliminating these false matches.
And perhaps change:
"Lossiness causes performance degradation since random access to table
records is slow; ..."
to something like:
"Lossiness causes performance degradation due to unnecessary random
accesses to table records; ..."
The only reason I say this is because, on my first reading, I read that
to mean that lossless indexes don't require trips to the heap at all
(which isn't true, yet).
Regards,
Jeff Davis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2007-10-26 21:47:57 | Re: First mention option for Postgres |
| Previous Message | Marc G. Fournier | 2007-10-26 21:03:28 | Re: First mention option for Postgres |