Pavlo Golub

Senior Developer & Consultant

Pavlo is a PostgreSQL expert and developer at CYBERTEC. He's been working with PostgreSQL since 2002. He has an M.Ed. with an emphasis in Mathematics and Computer Science from the Central Ukrainian State Pedagogical University, and previously worked as a professor at the Kirovograd Medical Professional College. He is the co-founder of PostgreSQL Ukraine. He develops and maintains the PostgreSQL tools PGWatch2 and pg_timetable.

community group icon

Postgresql.org icon

Articles by Pavlo Golub

pg_dump compression specifications in PostgreSQL 16

by Pavlo Golub | 12.2022

What is pg_dump compression? pg_dump is a PostgreSQL utility for backing up a local or remote PostgreSQL database. It creates […]

News & Performance

GRANT VACUUM, ANALYZE in PostgreSQL 16

by Pavlo Golub | 11.2022

What is GRANT VACUUM, ANALYZE? PostgreSQL uses table VACUUM and ANALYZE commands to optimize the database. The VACUUM command reclaims […]

Migrate scheduled jobs to pg_timetable from pgAgent

by Pavlo Golub | 08.2022

Why migrate to pg_timetable from pgAgent? There are many reasons, actually, why people might want to export pgAgent jobs to […]

Aliases for sub-SELECTS in FROM clause

by Pavlo Golub | 08.2022

What are aliases in SQL? SQL aliases in FROM clauses are used to give a result set a temporary name. […]

Migrate scheduled jobs to pg_timetable from pg_cron

by Pavlo Golub | 06.2022

Why migrate to pg_timetable from pg_cron? There are a lot of reasons you may want to migrate from pg_cron: maybe […]

Run multiple jobs but limit number of sessions - PostgreSQL: pg_timetable

by Pavlo Golub | 05.2022

If you are using pg_timetable to run multiple jobs on PostgreSQL, you need to understand how to calculate the number […]

pgwatch2 v1.9 Final Release

by Pavlo Golub | 04.2022

We are thrilled to announce that the FINAL version of pgwatch2 v1.9 is now ready for your production environment! pgwatch […]

pgwatch2 v1.9 Beta released and available for testing

by Pavlo Golub | 03.2022

We want to announce that the beta release of pgwatch2 v1.9 is now available for download. This release contains previews […]

pg_timetable v4.4 is available immediately!

by Pavlo Golub | 02.2022

Our team is proud to introduce a new pg_timetable v4.4 release! This time we focused on implementing a couple of […]

PostgreSQL on WSL2 for Windows: Install and setup

by Pavlo Golub | 11.2021

UPDATE on 23.02.2023: This post explains how to install PostgreSQL on WSL2 for Windows, apply the necessary changes to PostgreSQL […]

« Previous 1 2 3 4 5 Next »

Stay tuned with our

NEWSLETTER

CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf
Austria

+43 (0) 2622 93022-0
office@cybertec.at

Customer Support

Support Platform

Services

Support CYBERTEC Partner PostgreSQL Books

Company

STAY TUNED WITH OUR NEWSLETTER

Get the newest PostgreSQL Info & Tools

Data Protection Policy Terms and conditions Terms of Service Imprint

©

2024

CYBERTEC PostgreSQL International GmbH