Why can I not get lexemes for Hebrew but can get them for Armenian?

2019-02-27 Thread Sam Saffron
(This is a cross post from Stack Exchange, not getting much traction there) On my Mac install of PG: ``` =# select to_tsvector('english', 'abcd สวัสดี'); to_tsvector - 'abcd':1 (1 row) =# select * from ts_debug('hello สวัสดี'); alias | description | token | dictionaries

Faster way of estimating database size

2018-06-14 Thread Sam Saffron
Hi there, At the moment we are using: SELECT pg_database.datname, pg_database_size(pg_database.datname) as size FROM pg_database To gather size of databases for monitoring purposes in Prometheus. Our pg stat logging now shows this is our number one query cause we seem to be running it for some

Why is tuple_percent so low?

2018-02-26 Thread Sam Saffron
I am trying to refactor a table on disk so it consumes less space: Original is: create table post_timings( topic_id int not null, post_number int not null, user_id int not null, msecs int not null ) Target is: create table post_timings( post_id int not null, user_id int not nul