| From: | Maciek Sakrejda <msakrejda(at)truviso(dot)com> |
|---|---|
| To: | Joby Joba <jobyjoba59(at)gmail(dot)com> |
| Cc: | tv(at)fuzzy(dot)cz, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Two different execution plans for similar requests |
| Date: | 2011-03-01 17:07:18 |
| Message-ID: | AANLkTim-Gz2t17ztX-Hj894WFibKk3Mfe5wpKXPJe308@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tue, Mar 1, 2011 at 4:44 AM, Joby Joba <jobyjoba59(at)gmail(dot)com> wrote:
> Me again ! I have checked this question of 'explain analyze' and I
> understand now.
>
> When the problem occured I have run a 'EXPLAIN'
>
> I have run the request again to open this case using 'EXPLAIN ANALYZE' but I
> didn't reproduce the case. That's why I sent the other trace but it doesn't
> countain the information you are asking for.
> So Tomas, you were right !
>
> All apologies !!!!! (I'm confused)
>
>
> But the problem still not resolved .....
What exactly is the problem? Is one version of this plan slow? Which
one? If you can't reproduce with EXPLAIN ANALYZE (which actually runs
the query), how are you reproducing this?
---
Maciek Sakrejda | System Architect | Truviso
1065 E. Hillsdale Blvd., Suite 215
Foster City, CA 94404
(650) 242-3500 Main
www.truviso.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2011-03-01 17:33:54 | Re: inheritance: planning time vs children number vs column number |
| Previous Message | Marc Cousin | 2011-03-01 15:39:19 | Re: inheritance: planning time vs children number vs column number |