Postgres includes lots of monitoring tools that allow you to see what is happening, but there are a few settings that really go into detail, e.g. log_statement_stats:
SET client_min_messages = log; S...
A question came to me from a DBA friend asking about SQL differences between releases of the database. IE: behavioral differences in SQL processing. The question posed by this person was that they fe...
This tip covers the expectation that Quest SQL Optimizer will always be able to improve the performance of your SQL statements. Occasionally, even when you have increased the intelligence level up to...