Cortex Agent and PostgreSQL Server

Showing results for 
Show  only  | Search instead for 
Did you mean: 

Cortex Agent and PostgreSQL Server

L0 Member

Has anyone installed a Cortex Agent on a high performance database server such as PostgreSQL?  We are reaching the point in our rollout where we will need to decide if this is something that we can do without negatively impacting the performance of our OLTP system during normal operations.  We are looking to find out what lessons other users of Cortex XDR can teach us without having to go through the same pain ourselves.  🙂


L5 Sessionator

Hi @kenlacrosse this is a very subjective question and the answer to it is 'it depends'. Customers have deployed across different database standalone or cluster deployments with little to no issues. Given that each environment is unique, I recommend you to go ahead and deploy Cortex XDR in UAT and consider perform profiling as an added measure (e.g. disk I/O).  Once your team is satisfied with the performance, you can deploy it to Production environments.

L4 Transporter

Hi @kenlacrosse ,

Apart from what @bbarmanroy mentioned which is a must to do in this cases.

I would also have a clear picture of your resources on that DB server before you deploy XDR. If in the production server you are almost up to the limit of resources, please just bear in mind that even XDR is designed to not to have much impact on your resources, it still some resources to work, and the more activity you have in your server, the more resources XDR might need to check and inspect all transactions, processes executing in the server ... 

Ive seen customers running already at 98% on their servers far way too much processes running so if XDR needs a bit of memory and a bit of CPU to check the behaviour of every process, the amount of resources increase and so the server can be overloaded. 

Keep an eye to have your UAT server as similar as the production server as possible. 

Hope this helps, 


L0 Member

Cortex is the most sophisticated product in the market for highly automated migrations of Oracle databases to native PostgreSQL. In fact, migrating the business logic and combining this with all its dependencies between the Data and Code Objects makes Cortex unique. On average, Cortex is able to automatically migrate at least 80% of all the Oracle Code Objects to native PostgreSQL. Because we believe in database freedom, we always migrate Oracle databases to native PostgreSQL to avoid any vendor lock-in and to deliver maximum freedom of deployment on-premise and/or in the Cloud. facetime app

Like what you see?

Show your appreciation!

Click Like if a post is helpful to you or if you just want to show your support.

Click Accept as Solution to acknowledge that the answer to your question has been provided.

The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!

These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!

The LIVEcommunity thanks you for your participation!