Postgres Pro
Downloads
Home   >   mailing lists

Re: Why does row estimation on nested loop make no sense to me - Mailing list pgsql-general

From Amit Langote
Subject Re: Why does row estimation on nested loop make no sense to me
Date
Msg-id CA+HiwqHuL+1As6rM3LL+3-v4Yj1QvZmwLhQ5DDcjf60MZqju6Q@mail.gmail.com
Whole thread Raw
In response to Re: Why does row estimation on nested loop make no sense to me  (Jeff Amiel <becauseimjeff@yahoo.com>)
List pgsql-general
Tree view 
On Tue, May 21, 2013 at 12:43 AM, Jeff Amiel <becauseimjeff@yahoo.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

pgsql-general by date:

Previous
From: Jeff Amiel
Date:
Subject: Re: Why does row estimation on nested loop make no sense to me
Next
From: Nicklas Avén
Date:
Subject: Re: cal I pass arguments directly to final function in aggregates