Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pkZKo-0000hP-6f for pgsql-general@arkaria.postgresql.org; Thu, 06 Apr 2023 23:48:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pkZKm-0004KI-KI for pgsql-general@arkaria.postgresql.org; Thu, 06 Apr 2023 23:48:04 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pkZKl-0004K9-Tz for pgsql-general@lists.postgresql.org; Thu, 06 Apr 2023 23:48:04 +0000 Received: from tamriel.snowman.net ([2001:470:e38f::11]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pkZKj-0006Hu-Cv for pgsql-general@postgresql.org; Thu, 06 Apr 2023 23:48:02 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 756315F7B9; Thu, 6 Apr 2023 19:47:55 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=snowman.net; s=dkim; t=1680824875; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: in-reply-to:in-reply-to:references:references; bh=AxoEOj/bUNCZTgXZFysUFCWiBrjDpBjKOhaMYEIyBxY=; b=yGgBFUmFHL+bE88NFhjZlzrhThgY0AIggLiTtIpJVQgGkhBlNhZUlPAlSy1gMp+3ZCLZgf meM0pwpNeHP4iRkXMhEXXgHzznTVwfL4bAmdyB0KbSs/MBDC6pIh4UKDeMxfYBa9wGNEsV ax9wmNROGoJ2X59mBiabkyYcckp/bXk= Date: Thu, 6 Apr 2023 19:47:55 -0400 From: Stephen Frost To: Imre Samu Cc: pgsql Subject: Re: PostgreSQL Mailing list public archives : search not working ... Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="cOJIOkihfjH00E+g" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/2.1.4 (2021-12-11) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --cOJIOkihfjH00E+g Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable 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=3D1&q=3Dlarge+database+backup&l=3D&d= =3D365&s=3Dr > -> "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 > Subject: postgres *large database backup* > Date: 2022-11-30 15:40:23 > https://www.postgresql.org/message-id/flat/CA%2BONtZ7CdiJ2X8x_8sPHR%2Btz-= vv7mR1uoDzLia3fzWVZA9k0JQ%40mail.gmail.com >=20 > *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=3D1&q=3Ddatabase+backup&l=3D&d=3D-1&s= =3Dd 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=3Dpgarchives.git;a=3Dsummary Patches to improve certainly welcome. Thanks, Stephen --cOJIOkihfjH00E+g Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEwf6gbxKhD863zrx/7WyKOINHZFUFAmQvWigACgkQ7WyKOINH ZFXKnA/+OHLcf1BDzH1dtiKSLzw97sm/3esc+bNKoxgsllp55IUyM3KMtjLuNsuT aKmgK8cUa82WcIlpcsLAWUVrHPzf0nIT7bn5rkvhpbJW+YWwd8PNVMaPQcH/7gZM 84DFTpj8UUP0Gfv1Iw1u5TNuCPCoHwexGTU7GzgWoYUK4kgVFD0q/DNFe1DN3GTR nrFctCwlj94MdGM1vI6EfxAF5Zk9gu3l0EHZKmdpV1wDxPOShpxU/mpYHNe7Pk8d Y3RsYYNb/PU3jzLKSS725eNrp97osredTQg6texYvZE3odY7i+YxfPkdf+MfOvhI jjn7Bcm27OjDeEJxfDM8id8IOlk5HULJexJ47E/ckDqXUgicrJptm8+GBLy/JpME KpHVdB1J9sIRwsupYr/nGFTvXjXwfU29Ue7i7E13lYYG2xie5w3xhGg8dCRzXqkf gOq49seDgbjLTC4bgYeEKu4x9V/2jlEGWMM3Gd9Qgm6m0D3U7+OKP3PbjqFGeuov ZgZwvosJWsJ5c29jJ7EBOhCCDAhAhFfVupgGd9EYbklj/W0DmYxRUdM6xFtg6Gzi lbvT+2qmK59Ysf91iQEnmcNRrdlEy+xXUQJghg7brQZ/c6fVnf4SDxlMWSn+LlQ2 LLSdcuL1Hf9IYM/FgoLOJTuL7BcIn553odSegXYIhmTa3Rthwa0= =b+f4 -----END PGP SIGNATURE----- --cOJIOkihfjH00E+g--