AWS

AWS RDS for PostgreSQL – 4 – Changing parameters

If you followed that last posts about DB Parameter Groups, Subnet Groups and Setting up the RDS instance you should have a running RDS instance. You should also(…)

AWS RDS for PostgreSQL – 3 – Creating the RDS PostgreSQL instance

In the last tow posts we had a look at DB Parameter Groups and Subnet Groups as these need to be ready when you want to deploy a RDS PostgreSQL instance on(…)

AWS RDS for PostgreSQL – 2 – Subnet groups

In the last post we had a look at DB Parameter Groups when it comes to AWS RDS for PostgreSQL. This is one of the first things you should think about. But(…)

AWS RDS for PostgreSQL – 1 – DB Parameter Groups

When your go for AWS RDS you can very quickly bring up a database instance and start using it. I've written about my thoughts using this approach here and really encourage you(…)

Some thoughts about working with/on AWS

In the last year working with/on AWS has become an almost daily task in my life as a consultant and trainer. From a trainer perspective there is not much to say about it because we use a very limited amount(…)

Rapid PostgreSQL cloning using AWS EBS snapshots

When you go for AWS EC2 instances to host your PostgreSQL deployments and you want to rapidly clone PostgreSQL instances for development or testing purposes you can make use of AWS EBS(…)

DynamoDB: adding a Local covering index to reduce the cost

By Franck Pachot . This is a continuation on the previous post on DynamoDB: adding a Global Covering Index to reduce the cost. I have a DynamoDB partitioned on “MyKeyPart”,”MyKeySort” and I have many queries(…)

DynamoDB: adding a Global covering index to reduce the cost

By Franck Pachot . People often think of indexes as a way to optimize row filtering (“get item” faster and cheaper). But indexes are also about columns (“attribute projection”) like some kind of vertical partitioning. In relational (“SQL”) databases(…)