| From: | Amit Langote <amitlangote09(at)gmail(dot)com> |
|---|---|
| To: | Jeff Amiel <becauseimjeff(at)yahoo(dot)com> |
| Cc: | "depesz(at)depesz(dot)com" <depesz(at)depesz(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Why does row estimation on nested loop make no sense to me |
| Date: | 2013-05-20 15:49:32 |
| Message-ID: | CA+HiwqHuL+1As6rM3LL+3-v4Yj1QvZmwLhQ5DDcjf60MZqju6Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, May 21, 2013 at 12:43 AM, Jeff Amiel <becauseimjeff(at)yahoo(dot)com> wrote:
> Thanks much!
> (sorry for top-posting, yahoo email sucks)
>
I wonder if you could arrive at some conclusions with the statistics
(pg_stats) you have and the join selectivity formulas described in the
referred documentation link. I would like to know if you still get the
same row estimates (after explain) and also if possible, the value
that is computed from that formula. Do they resemble each other?
--
Amit Langote
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nicklas Avén | 2013-05-20 19:23:35 | Re: cal I pass arguments directly to final function in aggregates |
| Previous Message | Jeff Amiel | 2013-05-20 15:43:57 | Re: Why does row estimation on nested loop make no sense to me |