Tips for finding Knowledge Articles

  • - Enter just a few key words related to your question or problem
  • - Add Key words to refine your search as necessary
  • - Do not use punctuation
  • - Search is not case sensitive
  • - Avoid non-descriptive filler words like "how", "the", "what", etc.
  • - If you do not find what you are looking for the first time,reduce the number of key words you enter and try searching again.
  • - Minimum supported Internet Explorer version is IE9
Home  >

KB-11932: Requirements for Enabling Performance Improvements for Customer Managed PostgreSQL

Privileged Access Service ,  

2 April,19 at 03:46 PM

How can the FastDB performance improvements for Customer Managed Privilege Access Service (PAS) version 19.3 and later, be enabled when the PostgreSQL 9.6 database is also customer managed?
The FastDB feature for PAS can be realized when the the PostgreSQL database has the plv8 framework installed.  This framework requires the following PostgreSQL extensions:
  • plv8 - version 2.X
  • ip4r - version 2.X
  • postgres_fdw
  • dblink
These extensions can be downloaded from the web and installed, by the PostgreSQL database administrator, for the various PostgreSQL supported platforms.  The psql client can be used to verify that the extensions are available using the command:
postgres=# select * from pg_extension;
User-added image
Once the extensions are verified, the PAS FastDB can be enabled by following the steps in KB-11818