CYBERTEC PostgreSQL Logo
Ants Aasma Profile Picture

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.
github iconfacebook iconlinkedin iconx twitter iconcommunity group iconPostgresql.org iconWebsite icon

Articles by Pavlo Golub

usql: universal psql?

by Pavlo Golub | 01.2023
usql? But why? usql is a universal command-line interface for many database. But why are we still using CLI (command […]

hex, oct, bin integers in PostgreSQL 16

by Pavlo Golub | 12.2022
SQL and integer notations NEW in PostgreSQL 16 - support for non-decimal notation of integer constants! PostgreSQL already has powerful […]

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 […]

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 […]
1 2 3 4 5
CYBERTEC Logo white
STAY TUNED WITH OUR NEWSLETTER
Get the newest PostgreSQL Info & Tools


    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    ©
    2024
    CYBERTEC PostgreSQL International GmbH
    phone-handsetmagnifiercrosscross-circle
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram