CYBERTEC 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

New old "debug_parallel_query" setting in PostgreSQL 16

by Pavlo Golub | 03.2023
Naming variables Why will force_parallel_mode - the runtime option be renamed to debug_parallel_query in PostgreSQL 16? Proper variable and function […]

pg_timetable v5.3 is out!

by Pavlo Golub | 03.2023
Our team is proud to introduce a new pg_timetable v5.3 release! This time we focused solely on implementing new features […]

ER diagrams with SQL and Mermaid

by Pavlo Golub | 02.2023
What does ER stand for? An Entity Relationship (ER) diagram is one of the most important tools for database design. […]

Go & PostgreSQL: FOSDEM 2023 talk

by Pavlo Golub | 02.2023
Intro On the 5th of February 2023, I had the privilege of giving a talk at the PostgreSQL devroom during […]

Reserve connections in PostgreSQL 16

by Pavlo Golub | 02.2023
Reserve connections for the pg_use_reserved_connections group in PostgreSQL 16 Nathan Bossart implemented a brand-new patch that provides a way to […]

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 […]
CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf
Austria

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

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