Database Administration, Database Contractor

Vacuuming in PostgreSQL

04/01/202406/12/2022 by Philip

Is Vacuuming important in Postgresql

PostgreSQL is a database management system, and as such, vacuuming is an important maintenance task to help keep the database running efficiently. Vacuuming helps to clean up dead tuples (rows that have been deleted or obsoleted) and free up space on the database, which can help to improve performance and prevent the database from becoming bloated or fragmented. It’s generally recommended to vacuum a PostgreSQL database regularly to help maintain its health and performance.

All about Indexing in PostgreSQL

06/12/202206/12/2022 by Philip

What are the types of indexes available in PostgresQL and when should each be used?

PostgreSQL offers several different types of indexes, each of which can be useful in different situations. Here are some of the most common types of indexes in PostgreSQL:

All about Table Partitioning in PostgreSQL

04/01/202406/12/2022 by Philip

What is Partitioning in PostgreSQL

Partitioning in PostgreSQL is a technique for dividing a large table into smaller, more manageable pieces called partitions. Each partition contains a subset of the data in the table, and the data in each partition is organized and stored in a way that is optimized for the specific subset of data it contains.

Overall, partitioning is a useful technique for dividing large tables into smaller, more manageable pieces in PostgreSQL. It can improve the performance and manageability of the table, and can make it easier to work with large datasets in your database.

The Quick Redshift AWS Tutorial – Everything you need to get started.

28/02/2020 by Philip

AWS Redshift is a very powerful database, but it is quite different from traditional a RDBMS in terms of architecture and also the sorts of decisions that you need to make and planning that you need to perform before building and operating a Amazon Redshift cluster.

This Redshift AWS tutorial aims to give you everything that you need to get started with AWS Redshift in as little time as possible, by covering the basics of architecture and the structure of the database, optimizations that you can make and some advice on performance tuning and maintaining a AWS Redshift cluster.

AWS Well-Architected Framework – The 5 Pillars

26/02/2020 by Philip

The AWS Well-Architected Framework is a set of Documents and Tools that sets out best practices and procedures to follow to build high quality applications in the cloud on AWS

The core of the well architected framework is 5 pillars that group the important considerations and practices that you need to stick to when building in AWS.

The 5 Pillars of the AWS Well-Architected Framework

Security
Reliability
Performance Efficiency
Operational Excellence
Cost Optimization

Find the size of a table in Postgres

25/02/202025/02/2020 by Philip

You often need to know the size of a table in postgres and there is no particularly easy way to get that information directly from the psql client. Fortunately, all of the information is in there and is available through nice simple functions. All you have to do is pull it together and a stock …

AWS IAM Notes – AWS Solutions Architect

25/02/202025/02/2020 by Philip

This is some rough notes on IAM in AWS, covering IAM Roles, IAM Users and IAM Policies. The notes are aims at studying for the AWS Solutions Architect Certification and should cover the main points required for that exam.

AWS IAM can be summed up by saying that it authenticates and authorities you to and in AWS.

Root user is first user and has all permissions to everything on the account. It can’t be removed.

Can you improve your Oracle database using Postgres?

25/02/202007/01/2020 by Philip

Oracle is a great database. It is cutting edge and it has a huge team of developers behind it as well as massive funding.

There are not any areas where it lacks anything major that exists in other comparable databases.

The problem with Oracle is both that it is expensive in the first place, but also that all of the extras are chargeable and also expensive!

High Availability Options in Oracle vs Postgres

03/01/2020 by Philip

Oracle is the database to beat in terms performance and features or at least is positioned that way. More importantly, if you are thinking of migrating from Oracle to Postgres to save money, you need to know that your new database has at least the same features at the one that you are moving from.

High availability is one of the most important concepts and features for a database system. For most enterprise level applications, downtime has a direct financial cost and the actual loss of some or all of your data would be catastrophic.
You need to know that the system that you are moving to can protect your data as well as the system that you are on at the moment.