[PERFORM] How to improve Postgres performance

Hi All, I am running an application, which connects to the postgres database at initialization time and perform the database operations like Select/Update. Database queries are very simple. On analyzing my application through Quantifier( Performance analyzing tool), I found the most

[PERFORM] Update is more affected( taking more time) than Select ( if Auto vacuum is not running)

Hi All, I have an ODBC application( using postgres database) which has three different operations. Each operation is having combination of SELECT and UPDATE. For example: Operation A:6 Fetch + 1 Update Operation B:9 Fetch Operation C:5 Fetch + 3 Updat