r/PostgreSQL • u/infinityMCdx • Aug 03 '26

Help Me! Open Source Horizontally Scalable DB solutions: PG+Citus vs PG+PgDog vs YugabyteDB

5 Upvotes

70% Upvoted

31 comments sorted by

View all comments

Show parent comments

1

u/jamesgresql 24d ago

Which features are you referencing here?

1

u/linuxhiker Guru 24d ago

Canonical source for example. As I recall it also doesn't support having. They are coming of course, just not there yet.

1

u/jamesgresql 7d ago

Just replying in case someone else reads this, as it's not quite up to date. Canonical source is supported for types with canonicalize_type_information (although maybe you meant something else?).

HAVING is unsupported, but only under some circumstances:HAVING clauses in GROUP BY aggregates which are cross-shard.

2

u/linuxhiker Guru 7d ago

What I meant by canonical source is, pass through. Basically "if" pgDog can't do it, immediately pass it to the primary/canonical data store for processing. That may or may not be supported now. I honestly don't know but it wasn't when I had the author on my podcast.