Saurabh Dave <saurabhdave@xxxxxxxxx> wrote: > what I need to do is to check the queries that are slow and do a > vacuum analyze and share the results along with postgresql.conf > being used. Hopefully just a typo there. While you need to ensure that adequate VACUUM and ANALYZE maintenance is being performed, and a suggestion was made to use VACUUM VERBOSE for diagnostic purposes, what you need to do with the slow queries you identify is to run them with EXPLAIN ANALYZE in front (not VACUUM ANALYZE as your post stated). -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
