Feature: Add Greek language fulltext search
Hackorum builds and tests every patch posted to the lists, not only commitfest submissions. This is Hackorum's own CI rather than the PostgreSQL project's, and it is still under testing - please report anything that looks wrong.
You can run a PostgreSQL built from this patch straight from Docker, with no checkout and no build:
docker run --rm -p 5432:5432 ghcr.io/hackorum-dev/postgres-patch:t40328psql -h localhost -U postgresBuilt from patchset v1 (message #1), July 28, 2026 at 04:27 AM.
Every patchset is also pushed to a branch of our PostgreSQL fork, so you can check out the same tree CI built. Without a PostgreSQL checkout:
git clone --branch t40328_1 https://github.com/hackorum-dev/postgres.gitIn a checkout you already have, add the fork once:
git remote add hackorum https://github.com/hackorum-dev/postgres.gitthen, for this patchset and every later one:
git fetch hackorum t40328_1 && git checkout t40328_1Patchset v1 (message #1) is on t40328_1
Hello all,
Last November snowball added support for Greek language [1]https://github.com/snowballstem/snowball/commits/master/algorithms/greek.sbl. Following the
instructions [2]https://github.com/postgres/postgres/blob/97c39498e5ca9208d3de5a443a2282923619bf91/src/backend/snowball/README, I wrote a patch that adds fulltext search for Greek in
Postgres. The patch is attached.
I would appreciate any feedback that will help in getting this merged.
with kind regards,
Panos
[1]: https://github.com/snowballstem/snowball/commits/master/algorithms/greek.sbl
https://github.com/snowballstem/snowball/commits/master/algorithms/greek.sbl
[2]: https://github.com/postgres/postgres/blob/97c39498e5ca9208d3de5a443a2282923619bf91/src/backend/snowball/README
https://github.com/postgres/postgres/blob/97c39498e5ca9208d3de5a443a2282923619bf91/src/backend/snowball/README
Panagiotis Mavrogiorgos <pmav99@gmail.com> writes:
Last November snowball added support for Greek language [1]. Following the
instructions [2], I wrote a patch that adds fulltext search for Greek in
Postgres. The patch is attached.
Cool!
I would appreciate any feedback that will help in getting this merged.
We're past the deadline for submitting features for v12, but please
register this patch in the first v13 commitfest so that we remember
about it when the time comes:
https://commitfest.postgresql.org/23/
regards, tom lane
On 2019-03-25 12:04, Panagiotis Mavrogiorgos wrote:
Last November snowball added support for Greek language [1]. Following
the instructions [2], I wrote a patch that adds fulltext search for
Greek in Postgres. The patch is attached.
I have committed a full sync from the upstream snowball repository,
which pulled in the new greek stemmer.
Could you please clarify where you got the stopword list from? The
README says those need to be downloaded separately, but I wasn't able to
find the download location. It would be good to document this, for
example in the commit message. I haven't committed the stopword list yet.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
On Thu, Jul 4, 2019 at 1:39 PM Peter Eisentraut <
peter.eisentraut@2ndquadrant.com> wrote:
On 2019-03-25 12:04, Panagiotis Mavrogiorgos wrote:
Last November snowball added support for Greek language [1]. Following
the instructions [2], I wrote a patch that adds fulltext search for
Greek in Postgres. The patch is attached.I have committed a full sync from the upstream snowball repository,
which pulled in the new greek stemmer.Could you please clarify where you got the stopword list from? The
README says those need to be downloaded separately, but I wasn't able to
find the download location. It would be good to document this, for
example in the commit message. I haven't committed the stopword list yet.
Thank you Peter,
Here is the repo with the stop-words:
https://github.com/pmav99/greek_stopwords
The list is based on an earlier publication with modification by me. All
the relevant info is on github.
Disclaimer 1: The list has not been validated by an expert.
Disclaimer 2: There are more stop-words lists on the internet, but they are
less complete and they also use ancient greek words. Furthermore, my
testing showed that snowball needs to handle accents (tonous) and ς (teliko
sigma) in a special way if you want the stemmer to work with capitalized
words too.
https://github.com/Xangis/extra-stopwords/blob/master/greek
https://github.com/stopwords-iso/stopwords-el/tree/master/raw
all the best,
Panagiotis
On 7/4/19 1:39 PM, Peter Eisentraut wrote:
On 2019-03-25 12:04, Panagiotis Mavrogiorgos wrote:
Last November snowball added support for Greek language [1]. Following
the instructions [2], I wrote a patch that adds fulltext search for
Greek in Postgres. The patch is attached.I have committed a full sync from the upstream snowball repository,
which pulled in the new greek stemmer.Could you please clarify where you got the stopword list from? The
README says those need to be downloaded separately, but I wasn't able to
find the download location. It would be good to document this, for
example in the commit message. I haven't committed the stopword list yet.
Thanks, I noted snowball pushed a new commit related to greek stemmer few days
after your sync:
https://github.com/snowballstem/snowball/commit/533602101f963eeb0c38343d94c428ceef740c0c
As it seems there is no policy for stable release on Snowball, I don't know what
is the best way to keep in sync :(