A veces, es necesario importar en las bases de datos PostgreSQL grandes cantidades de datos a través de una única operación o de un número limitado de ellas. Este proceso puede resultar inaceptablemente lento. En este artículo, analizaremos algunos consejos basados en las mejores prácticas para la importación masiva de datos en PostgreSQL.

VACUUM y ANALYZE son las dos operaciones más importantes para el mantenimiento de la base de datos PostgreSQL. Vacuum se emplea para recuperar el espacio ocupado por las “tuplas muertas” de una tabla. Una tupla muerta se genera al borrar o actualizar (una eliminación seguida de una inserción) un registro. PostgreSQL no elimina físicamente la fila obsoleta de la tabla, sino que aplica un “marcador”...

VACUUM and ANALYZE are the two most important PostgreSQL database maintenance operations. A vacuum is used for recovering space occupied by “dead tuples” in a table. A dead tuple is created when a record is either deleted or updated (a delete followed by an insert). PostgreSQL doesn’t physically remove the old row from the table but puts a “marker” on it so that queries don’t return that row. When...

Sometimes, PostgreSQL databases need to import large quantities of data in a single or a minimal number of steps. This process can be sometimes unacceptably slow. In this article, we will cover some best practice tips for bulk importing data into PostgreSQL databases.

Learn how to effectively configure PostgreSQL log management for troubleshooting performance problems.

In a previous article of this series , we created a two-node PostgreSQL 12 cluster in the AWS cloud. We also installed and configured 2ndQuadrant OmniDB in a third node. The image below shows the architecture: We could connect to both the primary and the standby node from OmniDB’s web-based user interface. We then restored a sample database called “dvdrental” in the primary node which started to...

OmniDB is an open-source, graphical database management tool developed by 2ndQuadrant , a world-leader in PostgreSQL technologies and services. OmniDB is a browser-based, universal client tool that can manage major database engines like PostgreSQL, MariaDB, MySQL, and Oracle. Other soon-to-be-supported engines include SQLite, Firebird, MS SQL Server, and IBM DB2. Like any excellent database client...

In today’s world, organizations increasingly face an unprecedented level of threat of cyberattacks against their information assets. Cyberattacks can come in many forms. One such attack is called SQL injection . With SQL injection, rogue players target the backend database of any system. Usually, these systems are public-facing. Hackers try to send seemingly innocuous and regular queries to a...

This is the second installment of a two-part series on 2ndQuadrant’s repmgr, an open-source high-availability tool for PostgreSQL. In the first part, we set up a three-node PostgreSQL 12 cluster along with a “witness” node. The cluster consisted of a primary node and two standby nodes. The cluster and the witness node were hosted in an Amazon Web Service Virtual Private Cloud (VPC). The EC2...