Done, and paragraph added to 8.1.X. (7.3 mention retained for 8.1.X.)
---
Tom Lane wrote:
> Bruce Momjian writes:
> >
> > !Genetic query optimization (GEQO) randomly
> > !tests execution plans. Therefore, wh
Bruce Momjian writes:
>
> !Genetic query optimization (GEQO) randomly
> !tests execution plans. Therefore, when the number of tables
> !exceeds geqo and genetic query optimization is in use,
> !the execution plan will change each time the statement is executed.
>
geqo
Simon Riggs wrote:
> On Wed, 2006-01-11 at 22:23 -0500, Tom Lane wrote:
> > =?iso-8859-1?Q?Jean-Philippe_C=F4t=E9?= <[EMAIL PROTECTED]> writes:
> > > Thanks a lot for this info, I was indeed exceeding the genetic
> > > optimizer's threshold. Now that it is turned off, I get
> > > a very stable res
On Thu, Jan 12, 2006 at 03:23:14PM -0500, Jean-Philippe Cote wrote:
>
>
> Can I actully know whether a given plan is excuted with GEQO on ?
> In other words, if I launch 'explain ', I'll get a given plan, but if
> I re-launch
> the (withtout the 'explain' keyword), could I get a different
> pla
On Thu, Jan 12, 2006 at 09:48:41AM +, Simon Riggs wrote:
> On Wed, 2006-01-11 at 22:23 -0500, Tom Lane wrote:
> > =?iso-8859-1?Q?Jean-Philippe_C=F4t=E9?= <[EMAIL PROTECTED]> writes:
> > > Thanks a lot for this info, I was indeed exceeding the genetic
> > > optimizer's threshold. Now that it is
Hi,
I'm running version 8.1 on a dedicated Sun v20 server (2 AMD x64's)
with 4Gb of RAM. I have recently noticed that the performance of
some more complex queries is extremely variable and irregular.
For example, I currently have a query that returns a small number
of rows (5) by joining a dozen
Jean-Philippe Cote wrote:
>
>
> Can I actully know whether a given plan is excuted with GEQO on ?
> In other words, if I launch 'explain ', I'll get a given plan, but if
> I re-launch
> the (withtout the 'explain' keyword), could I get a different
> plan given that GEQO induces some randomness
Can I actully know whether a given plan is excuted with GEQO on ?
In other words, if I launch 'explain ', I'll get a given plan, but if I
re-launch
the (withtout the 'explain' keyword), could I get a different
plan given that GEQO induces some randomness ?
>Is it the plan that is different in
On Wed, 2006-01-11 at 22:23 -0500, Tom Lane wrote:
> =?iso-8859-1?Q?Jean-Philippe_C=F4t=E9?= <[EMAIL PROTECTED]> writes:
> > Thanks a lot for this info, I was indeed exceeding the genetic
> > optimizer's threshold. Now that it is turned off, I get
> > a very stable response time of 435ms (more or
=?iso-8859-1?Q?Jean-Philippe_C=F4t=E9?= <[EMAIL PROTECTED]> writes:
> Thanks a lot for this info, I was indeed exceeding the genetic
> optimizer's threshold. Now that it is turned off, I get
> a very stable response time of 435ms (more or less 5ms) for
> the same query. It is about three times slo
If this is a query that will be executed more than once, you can also
avoid incurring the planning overhead multiple times by using PREPARE.
-- Mark Lewis
On Wed, 2006-01-11 at 18:50 -0500, Jean-Philippe Côté wrote:
> Thanks a lot for this info, I was indeed exceeding the genetic
> optimizer's th
erformance@postgresql.org
Subject: Re: [PERFORM] Extremely irregular query performance
=?iso-8859-1?Q?Jean-Philippe_C=F4t=E9?= <[EMAIL PROTECTED]> writes:
> I'm running version 8.1 on a dedicated Sun v20 server (2 AMD x64's)
> with 4Gb of RAM. I have recently noticed that the pe
On Wed, 2006-01-11 at 16:37, Jean-Philippe Côté wrote:
> Hi,
>
> I'm running version 8.1 on a dedicated Sun v20 server (2 AMD x64's)
> with 4Gb of RAM. I have recently noticed that the performance of
> some more complex queries is extremely variable and irregular.
> For example, I currently have a
=?iso-8859-1?Q?Jean-Philippe_C=F4t=E9?= <[EMAIL PROTECTED]> writes:
> I'm running version 8.1 on a dedicated Sun v20 server (2 AMD x64's)
> with 4Gb of RAM. I have recently noticed that the performance of
> some more complex queries is extremely variable and irregular.
> For example, I currently ha
Hi,
I'm running version 8.1 on a dedicated Sun v20 server (2 AMD x64's)
with 4Gb of RAM. I have recently noticed that the performance of
some more complex queries is extremely variable and irregular.
For example, I currently have a query that returns a small number
of rows (5) by joining a dozen
15 matches
Mail list logo
