Michael Aboagye, Author at Vettabase

<img alt='' src='https://secure.gravatar.com/avatar/ed6ab480e4dfc7f7398b9751153eb4a2?s=60&d=mm&r=g' srcset='https://secure.gravatar.com/avatar/ed6ab480e4dfc7f7398b9751153eb4a2?s=120&d=mm&r=g 2x' class='avatar avatar-60 photo' height='60' width='60' />

About Michael Aboagye

Michael is PostgreSQL consultant at Vettabase. He is specialised in PostgreSQL performance, security and automation.

Tuning PostgreSQL Auto-vacuum

Posted on 28 April 2022 by Michael Aboagye — 3 Comments ↓

<img width="287" height="200" src="https://vettabase.com/blog/wp-content/uploads/2021/04/health_check_postgresql_smaller.jpeg" class="attachment-featured-slider size-featured-slider wp-post-image" alt="Vettabase PostgreSQL Health Check" srcset="https://vettabase.com/blog/wp-content/uploads/2021/04/health_check_postgresql_smaller.jpeg 287w, https://vettabase.com/blog/wp-content/uploads/2021/04/health_check_postgresql_smaller-16x12.jpeg 16w" sizes="(max-width: 287px) 100vw, 287px" />

Vettabase PostgreSQL Health Check

Why autovacuum is important in PostgreSQL and how to configure it properly. Continue reading Tuning PostgreSQL Auto-vacuum→

Populating tables faster in PostgreSQL

Posted on 9 July 2021 by Michael Aboagye — No Comments ↓

<img width="600" height="291" src="https://vettabase.com/blog/wp-content/uploads/2021/09/postgresql_populate_tables_faster-1.png" class="attachment-featured-slider size-featured-slider wp-post-image" alt="" srcset="https://vettabase.com/blog/wp-content/uploads/2021/09/postgresql_populate_tables_faster-1.png 600w, https://vettabase.com/blog/wp-content/uploads/2021/09/postgresql_populate_tables_faster-1-300x146.png 300w, https://vettabase.com/blog/wp-content/uploads/2021/09/postgresql_populate_tables_faster-1-16x8.png 16w" sizes="(max-width: 600px) 100vw, 600px" />

Fast-loading rows into a PostgreSQL table using the COPY FROM command. Continue reading Populating tables faster in PostgreSQL→

Tuning Linux kernel for PostgreSQL

Posted on 19 June 2021 by Michael Aboagye — No Comments ↓

<img width="600" height="314" src="https://vettabase.com/blog/wp-content/uploads/2021/06/tuning_linux_for_postgresql.jpeg" class="attachment-featured-slider size-featured-slider wp-post-image" alt="" srcset="https://vettabase.com/blog/wp-content/uploads/2021/06/tuning_linux_for_postgresql.jpeg 600w, https://vettabase.com/blog/wp-content/uploads/2021/06/tuning_linux_for_postgresql-300x157.jpeg 300w, https://vettabase.com/blog/wp-content/uploads/2021/06/tuning_linux_for_postgresql-16x8.jpeg 16w" sizes="(max-width: 600px) 100vw, 600px" />

Learn how to tune Linux parameters to improve PostgreSQL performance and reliability. Continue reading Tuning Linux kernel for PostgreSQL→

Row-level Security Policy in PostgreSQL

Posted on 11 June 2021 by Michael Aboagye — No Comments ↓

<img width="600" height="314" src="https://vettabase.com/blog/wp-content/uploads/2021/06/pg_row_security-2.jpeg" class="attachment-featured-slider size-featured-slider wp-post-image" alt="" srcset="https://vettabase.com/blog/wp-content/uploads/2021/06/pg_row_security-2.jpeg 600w, https://vettabase.com/blog/wp-content/uploads/2021/06/pg_row_security-2-300x157.jpeg 300w, https://vettabase.com/blog/wp-content/uploads/2021/06/pg_row_security-2-16x8.jpeg 16w" sizes="(max-width: 600px) 100vw, 600px" />

Learn how to grant or revoke rows privileges in PostgreSQL. Continue reading Row-level Security Policy in PostgreSQL→

Basic practices for optimizing read and write performance in PostgreSQL

Posted on 11 March 2021 by Michael Aboagye — 2 Comments ↓

<img width="640" height="318" src="https://vettabase.com/blog/wp-content/uploads/2021/03/postgres_write-640x318.jpg" class="attachment-featured-slider size-featured-slider wp-post-image" alt="" srcset="https://vettabase.com/blog/wp-content/uploads/2021/03/postgres_write-640x318.jpg 640w, https://vettabase.com/blog/wp-content/uploads/2021/03/postgres_write-16x9.jpg 16w" sizes="(max-width: 640px) 100vw, 640px" />

Optimizing read and write performance varies for every Postgres database server in a different environment. Continue reading Basic practices for optimizing read and write performance in PostgreSQL→