search

sraoss / pg_ivm

IVM (Incremental View Maintenance) implementation as a PostgreSQL extension
Other
942 stars 27 forks source link

Installing pg_ivm for AWS RDS #52

Open Hemsza opened 1 year ago

Hemsza commented 1 year ago

How to add pg_ivm as cutsom extension using pg_tle.

yss14 commented 1 year ago

@Hemsza If you find a way, I would also be interested.

gsharp021 commented 1 year ago

I need this as well, please and thank you!

mansueli commented 1 year ago

I see some code in C, which isn't a trusted language. Is it possible to have it in Rust? (so we can have it on pg_lte)

Or is it possible to install it just with the SQL scripts?

elsebastiann commented 1 year ago

Any news on this guys?

yugo-n commented 1 year ago

Unfortunately, as @mansueli says, extensions that pg_tle can make are limited to trusted languages, and pg_ivm's functions are written in C, so we cannot install pg_ivm by using pg_tle.

If we rewritten pg_ivm in a trusted language, it might work, but it does not seem realistic to me because pg_ivm calls C functions in the PostgreSQL core code internally.

rotten commented 1 year ago

Contact your AWS TAM (Technical Account Manager) and have them add your vote for this extension being officially supported. Presumably, if they get enough votes, they'll actually commit some people to adding support for it some day.

yoni-yad2 commented 6 months ago

Also please upvote here: https://repost.aws/questions/QUOtJI7pRBSRSJw7FpszR2WQ/will-pg-ivm-extension-be-supported-in-aws-rds-postgresql-when

And here: https://repost.aws/questions/QUF12RpagpTey5vszbg4Fm9w/pg-ivm-plugin-for-aurora-postgresql