Postgres extension request: postgresql-hll

[Abe Voelker]

This extension adds support for a HyperLogLog data structure - useful for counting distinct values while using a reasonable amount of space: https://github.com/aggregateknowledge/postgresql-hll

In the meantime a Redis instance tuned for persistence can be used instead, as Redis natively supports HyperLogLog. But I would like to get rid of the additional dependency if possible.

[Vladimir Rusinov]

Hi Abe,

Thank you for your feedback!

It does not seems like this extension supports PostgreSQL 9.4 or older, and it does not seems like it's actively maintained.

We only provide 9.6 currently, so it is not likely that we'll be able to add this extension soon.

The good news is that it's licensed under Apache2, so these problems are fixable.

If anybody else would like to use this extension please let us know. It will help us prioritize.

Short-term, I'd recommend to continue using Redis.

Thank you!

--
Vladimir Rusinov
PostgreSQL SRE, Google Ireland

Google Ireland Ltd.,Gordon House, Barrow Street, Dublin 4, Ireland
Registered in Dublin, Ireland
Registration Number: 368047

On Sun, Mar 26, 2017 at 11:56 PM, Abe Voelker <a...@abevoelker.com> wrote:

This extension adds support for a HyperLogLog data structure - useful for counting distinct values while using a reasonable amount of space: https://github.com/aggregateknowledge/postgresql-hll

In the meantime a Redis instance tuned for persistence can be used instead, as Redis natively supports HyperLogLog. But I would like to get rid of the additional dependency if possible.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsub...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/112a5fd4-978e-4181-a668-27a871536a1d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Abe Voelker]

Hi Vladimir,

You're right, that specific repo is not actively maintained. I would probably use Citus's fork instead: https://github.com/citusdata/postgresql-hll

I do believe this extension works with 9.6, it's just not in the master branch's Travis CI build config. A PR that added 9.6 to the build matrix did pass successfully: https://travis-ci.org/aggregateknowledge/postgresql-hll/builds/192062965

I'll continue using Redis; just wanted to provide some additional info.

Thanks!

Abe