| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | "Peter T(dot) Brown" <peter(at)memeticsystems(dot)com> |
| Cc: | <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: stange optimizer results |
| Date: | 2002-11-21 21:26:44 |
| Message-ID: | 20021121132423.X99265-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 21 Nov 2002, Peter T. Brown wrote:
> trouble is that this SQL is being automatically created by my
> object-relational mapping software and I can't easily customize it. Is
> there any other way I can force Postgres to do the most efficient thing?
Given no changes to the query, probably only by using blunt hammers like
seeing if set enable_seqscan=off or set enable_mergejoin=off helps, but
you'd want to wrap the statement with them (setting them globally is
bad) and you might not be able to do that as well if your software won't
let you.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter T. Brown | 2002-11-21 21:34:12 | Re: stange optimizer results |
| Previous Message | scott.marlowe | 2002-11-21 21:24:00 | Re: [ADMIN] H/W RAID 5 on slower disks versus no raid on |