| From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
|---|---|
| To: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | PostgreSQL-development <hackers(at)postgreSQL(dot)org> |
| Subject: | Re: [HACKERS] Bushy Plans fixed |
| Date: | 1999-02-18 01:58:42 |
| Message-ID: | Pine.BSF.4.05.9902172157330.59717-100000@thelab.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, 17 Feb 1999, Bruce Momjian wrote:
> Frankly, I would like to enable bushy plans and right-handed plans by
> default. The optimizer is now fast enough that a 9-table join is almost
> instantaneous, even with bush plans. People are not sophisticated
> enough to know when to enables these options themselves. I am not sure I
> am either. I would like to enables both, fix whatever breaks, and
> programmatically enable the options when they make sense.
Sounds reasonable to me...I know, in my case, it isn't something I'd think
to enable, and tend to be the type that uses btree's for indices all the
time cause I don't really understand why/where I'd use others...
Marc G. Fournier
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vadim Mikheev | 1999-02-18 02:54:20 | Re: [HACKERS] Bushy Plans fixed |
| Previous Message | Stupor Genius | 1999-02-18 01:37:36 | RE: [HACKERS] 8K block limit |