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.
In response to
pgsql-performance by date
|Next:||From: Hartmut Raschick||Date: 2003-12-12 10:47:54|
|Subject: Re: TRUNCATE veeeery slow compared to DELETE in 7.4|
|Previous:||From: David Shadovitz||Date: 2003-12-12 08:18:12|
|Subject: Query plan - now what?|