| From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
|---|---|
| To: | "justin" <justin(at)emproshunts(dot)com>, "Saurabh Dave" <saurabhdave(at)gmail(dot)com> |
| Cc: | "Guillaume Cottenceau" <gc(at)mnc(dot)ch>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Bundling postgreSQL with my Java application |
| Date: | 2009-07-07 13:40:22 |
| Message-ID: | 4A5309F60200002500028478@gw.wicourts.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Saurabh Dave <saurabhdave(at)gmail(dot)com> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tim Uckun | 2009-07-08 02:26:56 | Re: [PERFORM] Postgres Clustering |
| Previous Message | Hartman, Matthew | 2009-07-07 12:32:58 | Re: Speeding up a query. |