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

LZ4 and ZSTD pg_dump compression in PostgreSQL 16

by Pavlo Golub | 04.2023
LZ4 and ZSTD pg_dump compression I wrote a "pg_dump compression specifications in PostgreSQL 16" post a while ago. Frankly speaking, […]

Underscores in numeric constants in PostgreSQL 16

by Pavlo Golub | 04.2023
SQL and numeric constants NEW in PostgreSQL 16 - support for underscores in integer and numeric constants! I already wrote […]

Parallel aggregate - PostgreSQL 16 - better performance

by Pavlo Golub | 04.2023
What is a parallel aggregate? In PostgreSQL, a parallel aggregate refers to a way of processing aggregate functions (such as […]

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

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

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