11

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:).

pmoniq
  • 1,883
  • 2
  • 19
  • 22

1 Answers1

15

Are you looking for pgtune?

Wayne Conrad
  • 103,207
  • 26
  • 155
  • 191
  • Thanks for info about pgtune. Do you know about other applications? I would like to compare the effects of actions of those apps, this topic is a part of my research connected with my studies, any idea will by very helpfull. – pmoniq Jan 27 '10 at 14:28
  • @pmoniq, That's the only one I know of. There may be others. – Wayne Conrad Jan 27 '10 at 14:35
  • 2
    As stated in https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server, you can use https://github.com/jfcoz/postgresqltuner and https://github.com/dalibo/pgbadger – frb May 07 '18 at 15:18
  • @frb - pgbadger did not exist when I wrote this answer, but that's a great tip. You should add it as an answer, except this was an off-topic question, so I guess not. – Wayne Conrad May 07 '18 at 21:19
  • Yes, unable to add a new answer. – frb May 09 '18 at 07:56