Schedule Meeting

a

PostgreSQL Database
Health Checks

Get your PostgreSQL instances audited by highly skilled database professionals!

Subscribe to our PostgreSQL Blog Posts

We often write informative blog articles and guides on PostgreSQL. All you need to do is subscribe to be notified of new posts.


Quick Intro to PostgreSQL Health Checks

Our PostgreSQL Health Check service will cover PosgreSQL configurations, schema design (with indexes), most impacting queries, and more. We also work with many of the PostgreSQL forks, including the cloud versions, as well as popular and trusted extensions.

When a Database Health Check Can Help

A database is the heart of your application, and you want it to work well. Without a proper health check, it may start to invisibly lead you to money and / or reputation losses. A thorough examination will cost much less.

Why is your database so slow?

We will find slowdowns and will scientifically investigate them to find the root causes. Then we will explain to you what to do to speed up your database.

Why can't your database 'just scale'?

Databases are complex multi-purpose technologies. Scaling is possible but it may require specific knowledge of database internals.

Why does your database demonstrate strange behavior?

Database problems can be complicated and counterintuitive. It might be hard to understand what exactly went wrong without the years of experience we have.

Are your queries and your schema well optimised?

Trying to scale a cluster is often useless when SQL queries and the schema are not optimised. We’ll find the slowest queries, and the queries that slow down your servers. Sometimes the only problem of a slow application is missing or poorly designed indexes.

Why is your database consuming so many resources?

In many cases, you can spend less on IT infrastructure by using less nodes with more optimal schema and queries. We can get you there!

What if I want to replace my database technology?

We can help you to weigh the pros and cons, and find out if you just need to optimise your current database, because migrations are expensive.

Supported Technologies

Vettabase professionals use open source tools trusted and recommended by experts developing databases for decades. If a technology is spoken about, chances are that we have worked with it, too. We decide on a toolkit with automation at heart.

Database Health Check: Process Description

To maximize the value of our database health checks, we follow a standardized procedure that proved to be efficient throughout the years. Below you will find the description of its stages and understand what to expect from each of them. Basically, our database health check takes three working days.

1

Intro Call

At our intro calls, we usually ask if there are any specific cases or issues to investigate. Tell us more!

2

Monitoring-based check

We will examine metrics from your existing monitoring systems and setup more advanced open source monitoring solutions if required.

3

Schema Check

We will check your existing database schemas to see the logical and physical structure of your data and propose changes.

4

Server Check

We will take a look at your server configurations and see whether they can be tuned for your database to function better.

5

Health Check Results

You will get a detailed report with your database health check results split into several sections, and recommendations.

6

Explanatory Call

You will get a call from a Vettabase consultant to discuss the report, our recommendations and actions to be taken.

PostgreSQL Health Check Pricing

This pricing only applies to one PostgreSQL database cluster consisting of 3 nodes. For N-node clusters, multi-database environments and all types of complex database setups, please contact us directly to get a precise quotation.

Periodical health checks & discounts

If you commit do database health checks with us for more than one year, we might negotiate a special discounted price for you. You can order any number of database health checks you need, but normally we recommend doing them on a quarterly basis. To get more information on applicable discounts, contact us via sales@vettabase.com.

Security Standards

We understand that you trust us your database and the data inside it. This is why we will follow the industry's highest security standards to protect the integral part of your business.

  • No password will ever be transferred via unsafe communication channels.
  • A Non-Disclosure Agreement will be signed upon your first request.
  • SSH connection and key-based authentication will be employed by our experts when connecting to your database.
  • A Virtual Private Network (VPN) or jumphosts will be used by our team connecting to your database if you find it reasonable.

For full information on what else we do to ensure your database security, read our Consultancy Policy.

Client Testimonials

Take a look at the testimonials provided by Vettabase customers and partners – many of them are key people of the open source database community. If you want to add your reference, please contact us.

Michael ‘Monty’ Widenius

At MariaDB Foundation, we asked Vettabase to produce an analysis of the differences between MariaDB and another database technology, from a user perspective. The outcome was helpful and accurate, showing how Vettabase thorough skills cover multiple technologies.

Michael 'Monty' Widenius
Tommaso Franceschi

Vettabase is a valuable partner for Treedom. Their consulting services allowed us to improve our databases performance, scalability and security over time. In the process, Vettabase automated several maintenance tasks for our databases, using Ansible and custom scripts. Vettabase also trained our developers to write faster and more expressive SQL queries. The feedback from the attendees was great.

Tommaso Franceschi

Get Started With Vettabase Today

Professional help for your database infrastructure is just one click away! Use our contact form to explain your recent and (or) critical database issues to us. Your message will remain strictly confidential to the Vettabase team. Our experts will respond to you as soon as possible. You can also book a meeting with Federico Razzoli, the Director and Founder of Vettabase Ltd.

We at Vettabase respect our customers and offer good value for money compared to many other database consulting companies. We automate things where others leave them as they are because it means more support incidents or consulting engagements. Unlike many other companies, we will not recommend you a solution we are interested in. Quite the opposite, we will remain unbiased and use the best tools and technologies that fit your existing infrastructure, plans for growth and budget.