SoporteDBA

Sometimes we need an auditing solution for some tables in our databases and face some of the following requirements: Auditing from applicati...

pg_dump command doesn´t provide a native way to execute the dump based in a filter criteria.  Sometimes we need such feature in order to du...

"select count without where clause" is a performance headache in most of the database engines, in this post we´ll talk about Postg...

We usually observe locking problems in applications that use monolithically increase identifiers for their application components, where mul...