New answers tagged amazon-rds
1
vote
Amazon Aurora RDS (serveless) - How to match an ACU in terms of CPU number and memory
The majority of the server instance classes behind Aurora sport 8 GiB per CPU core. The "serverless" class is not documented, but I think it's safe to assume it follows the same principle (...
- 25.2k
0
votes
How to schedule PostgreSQL replication?
This might be an old question, but I had the same question today. One approach to do this is to schedule those commands for pausing and resuming replication.
-- to pause replication:
SELECT ...
- 101
1
vote
Accepted
Oracle Batch Deletion
With 1.8 billion rows you really should have EE. By far the best method is to recreate the table without the rows you want to delete. Formatting new blocks, especially direct path, is much faster than ...
- 558
0
votes
Oracle Batch Deletion
CTAS with NOLOGGING is a very good option for deleting ~15% of a big table.
Export + import with QUERY parameter is another, a very similar concept.
Both methods require additional storage space and ...
- 40.4k
0
votes
Get postgres snapshot from Amazon RDS
Navigate to the snapshot list in AWS RDS console
Select a desired snapshot with a checkbox
In the "Actions" dropdown button in the top right corner select "Export to S3"
Download ...
0
votes
Understanding RAM Usage, ReadThroughput, and Freeable Memory Metrics in PostgreSQL RDS
Postgres heavily relies on the OS cache. Freeable memory includes memory that is used by the OS for caching purposes (but can be reclaimed by other processes, hence freeable).
So by increasing the ...
- 101
0
votes
Sudden spike in BinLogDiskUsage
I have created a Python tool, which extracts and counts the statements from the binary logs and creates a nice report. This report can help during the investigation of such cases. Especially UPDATE ...
- 101
Top 50 recent answers are included