Skip to main content

New answers tagged

0 votes

AWS Postgres replication: adding indexes to a replica?

You certainly can use logical replication with extra indexes on the subscriber to support the SQL statements there. That solution may be good enough for your queries. If it is not good enough, design ...
Laurenz Albe's user avatar
  • 53.4k
0 votes

high cpu spikes on postgresql (rds)

The graphs indicate a significant increase in inserts and updates between 5 PM and 8 PM, along with a rise in concurrent sessions compared to the single-session transactions observed from 2 PM to 5 PM....
Shaamil A's user avatar
0 votes

I need to move from sqlite to a distributed setup. What are my options?

If I understand you environment correctly, then the best way would be to do a "timestamp based" partitioning. Keep current business objects in the operational copy of the database, move ...
White Owl's user avatar
  • 795
2 votes
Accepted

Can not create logon trigger on AWS RDS sql server instance

Amazon's documentation for Amazon RDS for Microsoft SQL Server lists Server-level Triggers under the category of "The following Microsoft SQL Server features aren't supported on Amazon RDS". ...
Doug Deden's user avatar
  • 1,817
2 votes
Accepted

Unable to enable Performance Insights on Amazon RDS db.t3.small instance

I found a page entitled "Amazon RDS DB engine, Region, and instance class support for Performance Insights". According to the first table on that page (under the column "Instance class ...
RolandoMySQLDBA's user avatar

Top 50 recent answers are included