groonga/en

anthonydafc

@anthonydafc

@kou Works great. Many thanks

anthonydafc

@anthonydafc

I have a question concerning the score. If i use an inner join i get a sql message saying : ERROR: ERREUR: la colonne « tableoid » n'existe pas
LINE 1: select f.fid_recherchefichiers, pgroonga_score(tableoid, cti...
^
HINT: Il existe une colonne nommée « tableoid » pour la table « p » mais elle ne peut pas être référencée dans cette partie de la requête.

SQL state: 42703
Character: 48

anthonydafc

@anthonydafc

the tableoid doesn't exist

Sutou Kouhei

@kou

Could you open an issue from here https://github.com/pgroonga/pgroonga/issues and write full SQLs (CREATE TABLE, CREATE INDEX, INSERT, SELECT, ...) to reproduce the case?

anthonydafc

@anthonydafc

ok, have you ever had issues concerning lock tables with groonga ???

Sutou Kouhei

@kou

If your PostgreSQL is crashed, lock may be remained.

anthonydafc

@anthonydafc

what do u mean ?

Sutou Kouhei

@kou

Did you talk about http://groonga.org/docs/reference/commands/lock_clear.html related?
If you didn't, you don't need to understand my answer.
(I hope that you explain what you want to know with concrete examples. Concrete examples are easy to understand.)

anthonydafc

@anthonydafc

Sorry, but i have had a few problems, with the database been locket, while executing tasks. the lof files that a pgrn table has been locked and only way to work around is to delete pgrn files and reindex...is there any easier way or an explanation to these locks ?

Sutou Kouhei

@kou

Could you open an issue from here https://github.com/pgroonga/pgroonga/issues and attach your ${PGDATA}/pgroonga.log to the issue? pgroonga.log will include the details for this case.

anthonydafc

@anthonydafc

Hello, have you a problem with the download section on https://pgroonga.github.io/, because the link announce "not found"

i'm looking for the windows versions

Kentaro Hayashi

@kenhys

@anthonydafc you can download here. https://github.com/pgroonga/pgroonga/releases/tag/2.2.0

Sutou Kouhei

@kou

I've fixed these links.

weldomha

@weldomha

hi all, pgroonga 11 debian

there is no package following this :

https://pgroonga.github.io/install/debian.html

using https://github.com/pgroonga/pgroonga/releases/download/2.2.1/pgroonga-2.2.1-postgresql-11-x64.zip

doesn't follow debian directory tree for postgres

any idea how to install pgroonga 11 on debian ??

weldomha

@weldomha

without compelling the source

Sutou Kouhei

@kou

I've uploaded deb packages for PostgreSQL 11: https://pgroonga.github.io/install/debian.html

Zhanzhao (Deo) Liang

@DeoLeung

Hi guys, is there any hints about using rk search on Chinese with pinyin?

Sutou Kouhei

@kou

You can't use prefix RK search for pinyin. You can just use prefix search.

Zhanzhao (Deo) Liang

@DeoLeung

Hi, I have an index question, I create a table with two column id, name and around 3m records, which having name a pgroonga index. but the query doesn't use the index, it just performs a seq scan, is there any technique to enforce it?

-- Table Definition ----------------------------------------------

CREATE TABLE datamarket.test_name (
    id integer PRIMARY KEY,
    name character varying
);

-- Indices -------------------------------------------------------

CREATE UNIQUE INDEX test_name_pkey ON datamarket.test_name(id int4_ops);
CREATE INDEX test_name_name_pgroonga ON datamarket.test_name(name pgroonga_text_full_text_search_ops_v2);

explain SELECT _default_.name AS name
        FROM datamarket.test_name AS _default_
        WHERE _default_.name &@ '欧莱雅' limit 10;

Limit  (cost=10000000000.00..10000005192.86 rows=10 width=38)
  ->  Seq Scan on test_name _default_  (cost=10000000000.00..10001984712.56 rows=3822 width=38)
        Filter: (name &@ '欧莱雅'::character varying)

-- this seems not working neither
set enable_seqscan = off;
show enable_seqscan; -- it does show off

Zhanzhao (Deo) Liang

@DeoLeung

if I use ilike '%xx%', it uses the index, I tried other operators with no luck

Zhanzhao (Deo) Liang

@DeoLeung

I cast the column to text works alter table datamarket.test_name alter column name type text; , so is it required that the column should be text type?

Horimoto Yasuhiro

@komainu8

I think, If the type of column is varchar, we need to specify to pgroonga_varchar_full_text_search_ops_v2 operator class.

For example, how about below example?

CREATE INDEX ${INDEX_NAME} ON ${TABLE_NAME} USING pgroonga (${COLUMN_NAME} pgroonga_varchar_full_text_search_ops_v2);

Zhanzhao (Deo) Liang

@DeoLeung

i c, let me have a try

Zhanzhao (Deo) Liang

@DeoLeung

it works , thx @komainu8 , and I check the document the default for varchar & text are different :)

Zhanzhao (Deo) Liang

@DeoLeung

hi, we are experiencing a pg crash, which we suspect it may be pgroonga, we found a lot

6790878 2019-09-03 10:35:19.987139|n|11768: pgroonga: initialize: <2.2.1>
6790879 2019-09-03 10:35:19.989661|n|11654: io(base/23522/pgrn) collisions(1000/7): lock failed 1000 times
6790880 2019-09-03 10:35:20.039066|n|11664: io(base/23522/pgrn) collisions(1000/7): lock failed 1000 times

around crashing time

also, will pgroonga create tcp connections? we see the connections keep increasing

Sutou Kouhei

@kou

Did your PostgreSQL process crash?

Zhanzhao (Deo) Liang

@DeoLeung

argh, not process crash, it's cpu and memory increase then killed by system

as we run it in docker, then the server brought back automatically, and cpu/memory keep increasing again, and got killed again

Sutou Kouhei

@kou

It's the problem.
You need to assign more resources to the docker container.

Zhanzhao (Deo) Liang

@DeoLeung

i c, is there any hardware recommendation about it? we have a total db around 1TB and single table around 500MB, the docker has full 16c32g resource(normally without pgroonga it uses <50%)

Sutou Kouhei

@kou

http://groonga.org/docs/troubleshooting/mmap_cannot_allocate_memory.html
http://groonga.org/docs/reference/tuning.html
will help you.

Zhanzhao (Deo) Liang

@DeoLeung

good, will give it a try, thx

anthonydafc

@anthonydafc

Hello, could you explain to me how this regular expression works :

select from trecherchepages where (ftexte &~ 'BARRY') gives results
select from trecherchepages where (ftexte &~ 'SOPHIE') gives results
select * from trecherchepages where (ftexte &~ 'BARRY') AND (ftexte &~ 'SOPHIE') gives no results

Sutou Kouhei

@kou

Could you also show sample data?

anthonydafc

@anthonydafc

BARRY ANDRE CORINNE RESOPHIE ERIC

sorry i used select from trecherchepages where (ftexte &~ '.BARRY') AND (ftexte &~ '.*SOPHIE')

Sutou Kouhei

@kou

select * from trecherchepages where (ftexte &~ 'BARRY') AND (ftexte &~ 'SOPHIE') matches a record that contains both BARRY and SOPHIE.
Your sample data don't include such record.

anthonydafc

@anthonydafc

the word RESOPHIE ends with SOPHIE, is that not possible to search with &~~?

Sutou Kouhei

@kou

RESOPHIE doesn't contain BARRY.

anthonydafc

@anthonydafc

i was looking for bith words : (ftexte &~ 'BARRY') AND (ftexte &~ 'SOPHIE')

Sutou Kouhei

@kou

If you need more help, could you create a new issue https://github.com/pgroonga/pgroonga/issues/new with SQL to reproduce your case?

CREATE TABLE ...;
CREATE INDEX ...;
INSERT ...;
SELECT ...;

anthonydafc

@anthonydafc

have you done a documentation for using &~ (regular expression) ?

ふりだしにもどる

@kenhys_twitter

@anthonydafc

Where communities thrive

People

Repo info

Activity