Database Engines:pgdbe
Performance considerations Professional
Avoiding * in searches and using explicit fields reduces the payload
Adding indexes on the SQL server to tables which are large increases performance
Instead of performing a navigational query, use Universal SQL SELECT
Beware of blobs in SELECT statements. Query them only if required.
Feedback
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.