databasepostgresqlperformancedatabase-tools

Auto-tuning tools for Postgres?


I am looking for tools to auto-tuning for postgresql database. Do you know any tools for postgres like DB2 Design Advisor in DB2, Database Tuning Advisor in Microsoft SQL Server or SQL Access Advisor in Oracle? Thanks for any links and ideas:).


Solution

  • Are you looking for pgtune?

    Based on some inputs regarding hardware, it can suggest parameters for the postgresql.conf, so Postgres can operate with its best, based on your hardware, type of system and expected number of connections.