| From: | Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in> |
|---|---|
| To: | "david(at)shadovitz(dot)com" <david(at)shadovitz(dot)com> |
| Cc: | "'pgsql-performance(at)postgresql(dot)org'" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Query plan - now what? |
| Date: | 2003-12-12 09:14:05 |
| Message-ID: | 3FD986DD.7000909@persistent.co.in |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
David Shadovitz wrote:
> Well, now that I have the plan for my slow-running query, what do I do? Where
> should I focus my attention?
Briefly looking over the plan and seeing the estimated v/s actual row mismatch,I
can suggest you following.
1. Vacuum(full) the database. Probably you have already done it.
2. Raise statistics_target to 500 or more and reanalyze the table(s) in question.
3. Set enable_hash_join to false, before running the query and see if it helps.
HTH
Shridhar
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hartmut Raschick | 2003-12-12 10:47:54 | Re: TRUNCATE veeeery slow compared to DELETE in 7.4 |
| Previous Message | David Shadovitz | 2003-12-12 08:18:12 | Query plan - now what? |