Vladimir Svedov

A system column is a a table with OIDs. OID is auto-incrementing integer value, unique within a PostgreSQL database (not just a table) that can be automatically assigned to each row of a table created WITH OIDS option.

This blog provides an overview of custom trigger based upgrades for PostgreSQL; and some insight into how computer game strategies can be lessons for database administration life.

Pgpool is a useful piece of software for connection pooling and load balancing. This is part three of the blog, which provides additional hints & observations by its author Vladimir Svedov to round up this topic.

Pgpool is a useful piece of software for connection pooling and load balancing. This is part two of the blog which provides information on failover and recovery.

Pgpool is a useful piece of software for connection pooling and load balancing. This is part one of the blog which provides an overview and tips on how to get up and running with pgpool.

This blog provides an overview of pgBouncer, a connection pooler for PostgreSQL that dramatically reduces processing time.

This blog offers a short summary of how you can perform a PostgreSQL 10 upgrade, including what method to chose, how to prepare and what to check for after the upgrade is complete.