4 ms·

Can I use this with RDS?

__s 6y ago
Yes: https://aws.amazon.com/premiumsupport/knowledge-center/rds-postgresql-running-queries https://aws.amazon.com/premiumsupport/knowledge-center/rds-p...
- aleksi 6y ago
  This page talks about pg_stat_activity, which is a standard PostgreSQL feature, not about Percona's custom extension that was just announced.
  - GordonS 6y ago
    Yep, so the answer to the GP's question is "no". This is one of the biggest PITAs with hosted Postgres - you can't just use whatever extensions you want, or indeed whatever version of those extension. Invariably AWS and Azure (presumably GCP too, I haven't used it) have only the most popular extensions available, and invariably woefully outdated versions.
    - petergeoghegan 6y ago
      pg_stat_activity isn't an extension -- it's a standard system view
      - GordonS 6y ago
        I don't know how you figure that - the article describes it as a "plugin", which fore Postgres generally means "extension". I just checked the github repo too - pg_stat_monitor is definitely an extension, not merely a view (it includes views that build on top of the standard pg_stat_statements extension).
        deleted 6y ago
        [deleted]
        sbuttgereit 6y ago
        I think you may be talking past each other. @petergeoghegan referenced pg_stat_activity which is a system view; now his response to you is definitely a non-sequitur, but he's right. Now of course your statement about pg_stat_monitor is correct, too. But you missed when you questioned Peter since he was talking about something different. Fun fact: Peter Geoghegan is a PostgreSQL major contributor per https://www.postgresql.org/community/contributors/ https://www.postgresql.org/community/contributors/, pretty sure he's a committer as well.
        GordonS 6y ago
        I did notice they had written "pg_stat_activity", but assumed it was a typo, since the original question was about running the Percona extension. Never thought to check their profile; seems like crossed wires.
    - craigkerstiens 6y ago
      This is something we're actively looking to change with Crunchy Bridge (https://www.crunchydata.com/products/crunchy-bridge/ https://www.crunchydata.com/products/crunchy-bridge/). We've started with PL/R and PL/Python in addition to the standard set of extensions. We're in the process of evaluating our next set of extensions including pg_repack, zhparser, pgroonga, and possibly pgsync. Longer term we're exploring the ability to bring your own and already have some thoughts on how to make that possible.
PeterZaitsev 6y ago
If this plugin gets and traction either directly or through its feature set incorporated in some other plugins I hope we can convince Amazon and other cloud vendors to support it.
chucky_z 6y ago
The way I've used external extensions in the past is by using a weird setup with non read-only replicas off the RDS primaries running in an EC2. It "works," but... operator beware. I'm also not exactly sure if you'll get full stats out of a replica.

__s 6y ago

Yes: https://aws.amazon.com/premiumsupport/knowledge-center/rds-postgresql-running-queries https://aws.amazon.com/premiumsupport/knowledge-center/rds-p...

aleksi 6y ago
This page talks about pg_stat_activity, which is a standard PostgreSQL feature, not about Percona's custom extension that was just announced.
- GordonS 6y ago
  Yep, so the answer to the GP's question is "no". This is one of the biggest PITAs with hosted Postgres - you can't just use whatever extensions you want, or indeed whatever version of those extension. Invariably AWS and Azure (presumably GCP too, I haven't used it) have only the most popular extensions available, and invariably woefully outdated versions.
  - petergeoghegan 6y ago
    pg_stat_activity isn't an extension -- it's a standard system view
    - GordonS 6y ago
      I don't know how you figure that - the article describes it as a "plugin", which fore Postgres generally means "extension". I just checked the github repo too - pg_stat_monitor is definitely an extension, not merely a view (it includes views that build on top of the standard pg_stat_statements extension).
      - deleted 6y ago
        [deleted]
      - sbuttgereit 6y ago
        I think you may be talking past each other. @petergeoghegan referenced pg_stat_activity which is a system view; now his response to you is definitely a non-sequitur, but he's right. Now of course your statement about pg_stat_monitor is correct, too. But you missed when you questioned Peter since he was talking about something different. Fun fact: Peter Geoghegan is a PostgreSQL major contributor per https://www.postgresql.org/community/contributors/ https://www.postgresql.org/community/contributors/, pretty sure he's a committer as well.
        GordonS 6y ago
        I did notice they had written "pg_stat_activity", but assumed it was a typo, since the original question was about running the Percona extension. Never thought to check their profile; seems like crossed wires.
  - craigkerstiens 6y ago
    This is something we're actively looking to change with Crunchy Bridge (https://www.crunchydata.com/products/crunchy-bridge/ https://www.crunchydata.com/products/crunchy-bridge/). We've started with PL/R and PL/Python in addition to the standard set of extensions. We're in the process of evaluating our next set of extensions including pg_repack, zhparser, pgroonga, and possibly pgsync. Longer term we're exploring the ability to bring your own and already have some thoughts on how to make that possible.

PeterZaitsev 6y ago

If this plugin gets and traction either directly or through its feature set incorporated in some other plugins I hope we can convince Amazon and other cloud vendors to support it.

chucky_z 6y ago

The way I've used external extensions in the past is by using a weird setup with non read-only replicas off the RDS primaries running in an EC2. It "works," but... operator beware. I'm also not exactly sure if you'll get full stats out of a replica.