| From: | Tod McQuillin <devin(at)spamcop(dot)net> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Eh? |
| Date: | 2001-08-14 05:31:04 |
| Message-ID: | Pine.GSO.4.33.0108140029260.22208-100000@sysadmin |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Mon, 13 Aug 2001, Josh Berkus wrote:
> > > SHould I be concerned about this?
> >
> > > DEBUG: geqo_main: using edge recombination crossover [ERX]
> >
> > Nope. See
> > http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/geqo.html
>
> Cool! I love it when I actually get the chance to see some advance
> theory applied. And congrats on implementing it!
Yeah, this is really excellent.
> Of course, we'll see if it really boosts query optimization when there's
> a full data population. This view has 3 UNION statements, 11
> subselects, 35 JOINS, and calls on 3 custom formatting functions ...
This makes me wonder... in the case of a stored complex view, would it be
helpful to ask PostgreSQL to spend extra time in query optimisation and
then cache the result? Or does it do this already?
--
Tod McQuillin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alan Gutierrez | 2001-08-14 06:51:33 | Re: DateDiff, IsNull? |
| Previous Message | Josh Berkus | 2001-08-14 04:50:36 | Re: Eh? |