As a database administrator (DBA), you play an important role in making sure your organization’s databases are secure, available, and perform well. From installation and configuring, through...

As a database administrator (DBA), you play an important role in making sure your organization’s databases are secure, available, and perform well. From installation and configuring, through...

First, a big thanks for the kind responses to this series, and, as requested, here is an overview of index types available in PostgreSQL. The supporting video with bonus material can be found...

Those new to the realm of PostgreSQL from other databases will find little gems sprinkled liberally through the software.  One of those gems is the watch command. It can be used to repeatedly run...

Thank you for the many kind responses to this series.  There are many out there who have MySQL experience and are seeking to expand into PostgreSQL for reasons ranging from simple curiosity to...

Episode 8 in the PostgreSQL for MySQL DBAs series covers materialized views. MySQL has had views for many years and they are very useful, but it has never had materialized views. Those who use...

Experienced MySQL DBAs exploring PostgreSQL are often shocked to learn that they will need to vacuum their tables. This is not using a Hoover brand-like device or letting a Roomba-like robot loose...

The differences between MySQL and PostgreSQL are often trivial but occasionally there are stark differences.  A MySQL DBA wanting to optimize a query on a PostgreSQL server will hopefully have...