pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Stephen Frost <sfrost@snowman.net>
To: Imre Samu <pella.samu@gmail.com>
Cc: pgsql <pgsql-general@postgresql.org>
Subject: Re: PostgreSQL Mailing list public archives : search not working ...
Date: Thu, 6 Apr 2023 19:47:55 -0400
Message-ID: <ZC9aK0k3WkW1Grhl@tamriel.snowman.net> (raw)
In-Reply-To: <CAJnEWwkKwHpa8X5TV-vV-RuKyo0hQMqNtpZ978ucTxCyUv-Bhg@mail.gmail.com>
References: <CAJnEWwkKwHpa8X5TV-vV-RuKyo0hQMqNtpZ978ucTxCyUv-Bhg@mail.gmail.com>

Greetings,

* Imre Samu (pella.samu@gmail.com) wrote:
> Theory: Maybe the search doesn't always work ...

It does ... but perhaps not as expected (or as ideal).

> Is this a known problem?

Yes and no.

> My use case:
> in https://www.postgresql.org/list/  ->  "Search the Archives"
> search for the "large database backup"
> ->
> https://www.postgresql.org/search/?m=1&q=large+database+backup&l=&d=365&s=r
> -> "Your search for large database backup returned no hits."

Note that the default is "within the last year".  That may not be ideal
though and perhaps we should change it.

> But at least one big thread exists:

"big" is perhaps over-stating it, and most of it is actually about ZFS
anyway, though a few of the initial emails on the thread are
informative.

> To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
> Subject: postgres *large database backup*
> Date: 2022-11-30 15:40:23
> https://www.postgresql.org/message-id/flat/CA%2BONtZ7CdiJ2X8x_8sPHR%2Btz-vv7mR1uoDzLia3fzWVZA9k0JQ%4...
> 
> *Changing the "Sort by" ..*

Changing date to 'anytime', sorting by 'date' and using 'database
backup' instead turns this thread up pretty quickly (number 7):

https://www.postgresql.org/search/?m=1&q=database+backup&l=&d=-1&s=d

That said, we should really be including the Subject line in the search
and I don't think we are today (looks like we just search the body).
The code is available for review here:

https://git.postgresql.org/gitweb/?p=pgarchives.git;a=summary

Patches to improve certainly welcome.

Thanks,

Stephen

Attachments:

  signature.asc (application/pgp-signature, 832B) download

view thread (4+ messages)

Message-ID: <ZC9aK0k3WkW1Grhl@tamriel.snowman.net>
Permalink:  ../ZC9aK0k3WkW1Grhl@tamriel.snowman.net/
Also on:    postgresql.org/message-id/ZC9aK0k3WkW1Grhl@tamriel.snowman.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: sfrost@snowman.net, pella.samu@gmail.com
  Subject: Re: PostgreSQL Mailing list public archives : search not working ...
  In-Reply-To: <ZC9aK0k3WkW1Grhl@tamriel.snowman.net>
  References: <CAJnEWwkKwHpa8X5TV-vV-RuKyo0hQMqNtpZ978ucTxCyUv-Bhg@mail.gmail.com> <ZC9aK0k3WkW1Grhl@tamriel.snowman.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox