ArturFormella

Hello! Thank you for your reply. > Just to make sure I understand, you want to see how many news items in category 5/7/9 have each tag? For instance: yes,...

Hello! It is not easy to use map structure in C but I think I've got it. https://github.com/ArturFormella/aggs_for_arrays/commit/495d7df142c3ec6b9ae3bdaedd134fa2b2fb7b2a Example usage: ```SQL explain analyze select key,value from ( SELECT faceted_count(tags) FROM...

I've made a parallel safe version of faceted_count. It's even faster. ```SQL set max_parallel_workers_per_gather to 2; set force_parallel_mode to on; explain analyze select key,value from ( SELECT faceted_count(tags) FROM public.news...

+1 Possible dup of #23

+1

Hi! Could you try the following query? I hope I didn't make any typo here. ``` EXPLAIN ANALYZE with items as ( SELECT content_type, docid, row_number() over ( PARTITION BY...

It is worth saying that without an index all queries work as expected

The same problem. What can I do?

This is a surprising workaround: ``` ➜ uv pip install pip Resolved 1 package in 176ms Installed 1 package in 16ms + pip==24.0 ```

> ...would finally give me an acceptable replacement to SearchWP 3.0 ... the same problem here