Обсуждение: Synonyms in doc search
Is is possible to add synonyms (in some way, or similar functionality) to the
docs search in order to promote content? I just searched for TLS in the v10
docs and the number one hit, out of meagre 7 in total, is the 9.1.17 release
notes. If I instead search for SSL there are 130 hits with the first one being
the relevant page. Personally I know the reason for this, but a newcomer is
unlikely to.
Where we use terminology which is different from what is commonly used, it
wouldn’t hurt to point users in the right direction. Is it enough to add is as
another indexterm as in the below, or would it require more invasive changes?
--- a/doc/src/sgml/runtime.sgml
+++ b/doc/src/sgml/runtime.sgml
@@ -2162,6 +2162,7 @@ pg_dumpall -p 5432 | psql -d postgres -p 5433
<indexterm zone="ssl-tcp">
<primary>SSL</primary>
+ <secondary>TLS</secondary>
</indexterm>
cheers ./daniel
On Sat, Oct 13, 2018 at 1:15 AM Daniel Gustafsson <daniel@yesql.se> wrote:
Is is possible to add synonyms (in some way, or similar functionality) to the
docs search in order to promote content? I just searched for TLS in the v10
docs and the number one hit, out of meagre 7 in total, is the 9.1.17 release
notes. If I instead search for SSL there are 130 hits with the first one being
the relevant page. Personally I know the reason for this, but a newcomer is
unlikely to.
We don't have the ability to do this specifically for the docs search, but we could do it globally across either all the website search or even all the website + all the archives. A bit of a pain to reindex the archives (especially since I just did it a couple of days ago, see note on -www about downtime), but the website part should be quick. It's just a tsearch synonym dictionary...
If we do want to do that, we may want to give some thought to if we should add any more synonoyms at the same time?
Where we use terminology which is different from what is commonly used, it
wouldn’t hurt to point users in the right direction. Is it enough to add is as
another indexterm as in the below, or would it require more invasive changes?
Docs search is freetext based, on the generated HTML only. There's a long standing TODO to try to do something better based on the structured data we have, but nothing's been done so far. It's probably easier now with XML, but the question is how much easier...
> On 14 Oct 2018, at 18:47, Magnus Hagander <magnus@hagander.net> wrote: > > On Sat, Oct 13, 2018 at 1:15 AM Daniel Gustafsson <daniel@yesql.se <mailto:daniel@yesql.se>> wrote: > Is is possible to add synonyms (in some way, or similar functionality) to the > docs search in order to promote content? I just searched for TLS in the v10 > docs and the number one hit, out of meagre 7 in total, is the 9.1.17 release > notes. If I instead search for SSL there are 130 hits with the first one being > the relevant page. Personally I know the reason for this, but a newcomer is > unlikely to. > > We don't have the ability to do this specifically for the docs search, but we could do it globally across either all thewebsite search or even all the website + all the archives. A bit of a pain to reindex the archives (especially since Ijust did it a couple of days ago, see note on -www about downtime), but the website part should be quick. It's just a tsearchsynonym dictionary... > > If we do want to do that, we may want to give some thought to if we should add any more synonoyms at the same time? I see, I was hoping it would be a simpler fix. I still think TLS should be added as a synonym, but there is no rush of course. Whenever indexing happens next would be good. cheers ./daniel
On Mon, Oct 15, 2018 at 2:41 PM Daniel Gustafsson <daniel@yesql.se> wrote:
>
> > On 14 Oct 2018, at 18:47, Magnus Hagander <magnus@hagander.net> wrote:
> >
> > On Sat, Oct 13, 2018 at 1:15 AM Daniel Gustafsson <daniel@yesql.se <mailto:daniel@yesql.se>> wrote:
> > Is is possible to add synonyms (in some way, or similar functionality) to the
> > docs search in order to promote content? I just searched for TLS in the v10
> > docs and the number one hit, out of meagre 7 in total, is the 9.1.17 release
> > notes. If I instead search for SSL there are 130 hits with the first one being
> > the relevant page. Personally I know the reason for this, but a newcomer is
> > unlikely to.
> >
> > We don't have the ability to do this specifically for the docs search, but we could do it globally across either
allthe website search or even all the website + all the archives. A bit of a pain to reindex the archives (especially
sinceI just did it a couple of days ago, see note on -www about downtime), but the website part should be quick. It's
justa tsearch synonym dictionary...
> >
> > If we do want to do that, we may want to give some thought to if we should add any more synonoyms at the same time?
>
> I see, I was hoping it would be a simpler fix. I still think TLS should be
> added as a synonym, but there is no rush of course. Whenever indexing happens
> next would be good.
It's possible to do without reindexing, just try ts_rewrite
create table aliases( t tsquery primary key, s tsquery);
insert into aliases values(to_tsquery('supernovae'),
to_tsquery('supernovae|sn'));
select ts_rewrite(to_tsquery('supernovae'),
'select * from aliases');
ts_rewrite
--------------------
'supernova' | 'sn'
(1 row)
>
> cheers ./daniel
--
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company