Comments (9)
obartunov
commented on May 24, 2024
You didn't make rum index :)
…On Fri, Apr 29, 2022 at 7:17 AM ZhuQingChao ***@***.***> wrote:
CREATE TABLE testrum(c1 tsvector);
insert into testrum values (to_tsvector('hello rum, i''m digoal')), (to_tsvector('hello world, i''m postgresql')), (to_tsvector('how are you, i''m digoal'));
EXPLAIN select *,c1 <=> to_tsquery('postgresql') from testrum order by c1 <=> to_tsquery('postgresql');
Sort (cost=1.81..1.82 rows=3 width=36)
Sort Key: ((c1 <=> to_tsquery('postgresql'::text)))
-> Seq Scan on testrum (cost=0.00..1.79 rows=3 width=36)
—
Reply to this email directly, view it on GitHub
<#106>, or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ABQURYUCZ55ZKJOV4LMFAPTVHNPG3ANCNFSM5UUR7LCQ>
.
You are receiving this because you are subscribed to this thread.Message
ID: ***@***.***>
--
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
from rum.
zhuqingchao
commented on May 24, 2024
I created the rum index. I am sure.
from rum.
funny-falcon
commented on May 24, 2024
@zhuqingchao in your example in first comment ( #106 (comment) ) there is no CREATE INDEX.
Please, provide example with CREATE INDEX.
from rum.
obartunov
commented on May 24, 2024
On Thu, May 5, 2022 at 11:17 AM ZhuQingChao ***@***.***> wrote:
I created the rum index. I am sure.
Please, provide how did you create rum index
…
—
Reply to this email directly, view it on GitHub, or unsubscribe.
You are receiving this because you commented.Message ID: ***@***.***>
--
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
from rum.
zhuqingchao
commented on May 24, 2024
@funny-falcon @obartunov Sorry for long time no login to github。
I created the index as follows:
CREATE INDEX idx_testrum ON testrum USING rum(c1 rum_tsvector_ops);
// or just
CREATE INDEX idx_testrum ON testrum USING rum(c1);
Both rum index not working. I wonder if the amount of data is too small?
I also tested with RANDOM_PAGE_COST setting of pg.
The default value of RANDOM_PAGE_COST is 4, When i SET RANDOM_PAGE_COST = 0.1; for test, its no effect.
But this setting effected when i test my Chinese word segmentation plugin:pg_jieba
from rum.
obartunov
commented on May 24, 2024
On Mon, Jul 4, 2022 at 8:17 AM ZhuQingChao ***@***.***> wrote:
@funny-falcon <https://github.com/funny-falcon> @obartunov
<https://github.com/obartunov> Sorry for long time no login to github。
I created the index as follows:
CREATE INDEX idx_testrum ON testrum USING rum(c1 rum_tsvector_ops);
// or just
CREATE INDEX idx_testrum ON testrum USING rum(c1);
Both rum index not working. I wonder if the amount of data is too small?
yes, index scan is useless for this data. Try to disable seq scan as below:
[local]:5433 ***@***.***=# set enable_seqscan to off;
SET
Time: 0.110 ms
[local]:5433 ***@***.***=# EXPLAIN analyze select *,c1 <=>
to_tsquery('postgresql') from testrum order by c1 <=>
to_tsquery('postgresql');
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------
Index Scan using idx_testrum on testrum (cost=3600.00..3608.80 rows=3
width=36) (actual time=0.102..0.110 rows=3 loops=1)
Order By: (c1 <=> to_tsquery('postgresql'::text))
Planning Time: 0.070 ms
Execution Time: 0.136 ms
(4 rows)
Time: 0.518 ms
… I also tested with RANDOM_PAGE_COST setting of pg.
The default value of RANDOM_PAGE_COST is 4, When i SET RANDOM_PAGE_COST =
0.1; for test, its no effect.
But this setting effected when i test my Chinese word segmentation
plugin:pg_jieba
—
Reply to this email directly, view it on GitHub
<#106 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ABQURYTVVLPTMXJQEVYH3ADVSJXV3ANCNFSM5UUR7LCQ>
.
You are receiving this because you were mentioned.Message ID:
***@***.***>
--
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
from rum.
zhuqingchao
commented on May 24, 2024
So the index is worked, i think.
but i wonder if this is expected behavior? When this data is to small or seq scan or some what else, the rum index is useless.
And this index will be used at the right time ? how to understand the 'right time'. tks
from rum.
obartunov
commented on May 24, 2024
On Wed, Jul 6, 2022, 07:50 ZhuQingChao ***@***.***> wrote:
So the index is worked, i think.
but i wonder if this is expected behavior? When this data is to small or
seq scan or some what else, the rum index is useless.
This is how Postgres optimizer works. Index is not a silver bullet for
speeding up query, it also introduces some overhead.
And this index will be used at the right time ? how to understand the
'right time'. tks
Read how postgres optimizer works.
…
—
Reply to this email directly, view it on GitHub
<#106 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ABQURYSM3Y62TYMRY3VPT7DVSUGAHANCNFSM5UUR7LCQ>
.
You are receiving this because you were mentioned.Message ID:
***@***.***>
from rum.
zhuqingchao
commented on May 24, 2024
tks
from rum.
Related Issues (20)
- Querying 1.6 million records using RUM index takes 2 seconds HOT 1
- rum compile warnings on pg14.0 HOT 2
- New release with PG14 support HOT 2
- Ошибка: could not load library "/usr/pgsql-14/lib/rum.so" при выполнении create extension HOT 5
- rum_anyarray_addon_ops index not working HOT 1
- Is there a way to weight the rum_ts_score function?
- Build failure with PG15: src/rumsort.c:1316:38: error: too many arguments to function ‘LogicalTapeBackspace’ HOT 14
- ERROR: could not load library rum.so: undefined symbol: postgresql_sort__done_semaphore HOT 5
- Hello, may I ask why rum deleted the fast update function, what is the consideration?
- Can we compute two tsvectors like array op?
- New release with PG15 support? HOT 2
- warning on var totalCount compile on mac venture clang
- create rum index without "WITH" cause an error when select use “ORDER BY”
- In a query, `||` does not work when nested in `<->` HOT 3
- Index with jsonb and int8?
- [bug] the result is different when rum index(for tsquery) used and not used HOT 2
- Feasibility of adding range operator for tsquery HOT 5
- Extension ready for Postgres 14? HOT 2
- [Bug] addInfo is (Datum) 0, which is expected to be not, coredump in func DatumGetByteaP HOT 8
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from rum.