| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | "Peterson, Bjorn" <Bjorn(dot)Peterson(at)pearson(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Zombie processes |
| Date: | 2005-03-30 15:12:31 |
| Message-ID: | 424AC1DF.90708@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Peterson, Bjorn wrote:
> My coworkers and I studied the EXPLAIN and EXPLAIN ANALYZE output for this
> query and determined that the query planner seemed to be causing problems
> with this query. By calling "set enable_nestloop = off" before executing
> our query we were able to get the execution time down to under 2 minutes,
> which is acceptable for our purposes.
Tampering with the enable_xxx settings is NOT recommended for production
systems. You might be better off posting the EXPLAIN ANALYSE details to
the performance list.
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | josue | 2005-03-30 15:14:33 | Re: Upgrade data |
| Previous Message | Scott Marlowe | 2005-03-30 15:09:28 | Re: Upgrade data |