citusdata / citusdata/postgresql-hll

Hll out of memory error

Open
#90 1 comment 3 reactions 0 assignees View on GitHub
Dominant language
C
Stars
1.2k
Forks
115
PR merge metrics
No merged PRs in 30d

Description

I got this error with hll query.

```
SET citus.count_distinct_error_rate to 0.01;

select data_info ->> 'domain', count(distinct userid)
from users
group by data_info ->> 'domain'
order by 2 desc;

ERROR: out of memory
DETAIL: Failed on request of size 131120 in memory context "multiset".
SQL state: 53200
```

Setting hll.force_groupagg to "on" and then the problem was resolved.

But group aggregation slower than count(distinct xxx) query. (3 times slower)

Is it possible to add memory setting options for hash aggregation?

@byucesoy

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.