Re: Extremely irregular query performance

From: Jean-Philippe Cote <jean-philippe(dot)cote(at)crt(dot)umontreal(dot)ca>
To: "'Kenneth Marshall'" <ktm(at)it(dot)is(dot)rice(dot)edu>, "'Simon Riggs'" <simon(at)2ndquadrant(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Extremely irregular query performance
Date: 2006-01-12 20:23:14
Message-ID: 20060112201353.5C39138409A@crt0.crt.umontreal.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Can I actully know whether a given plan is excuted with GEQO on ?
In other words, if I launch 'explain <query>', I'll get a given plan, but if I re-launch
the <query> (withtout the 'explain' keyword), could I get a different
plan given that GEQO induces some randomness ?

>Is it the plan that is different in the fastest case with GEQO or is it
>the time needed to plan that is causing the GEQO to beat the exhaustive
>search?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kenneth Marshall 2006-01-12 21:05:50 Re: Extremely irregular query performance
Previous Message Jaime Casanova 2006-01-12 20:16:00 Re: Please Help: PostgreSQL performance Optimization