Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M53758=pgsql-performance-ar@postgresql.org>)
 id 1a8mlk-0000on-VD
 for pgsql-performance@arkaria.postgresql.org; Tue, 15 Dec 2015 10:23:45 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.84) (envelope-from
 <pgsql-performance-owner+M53758=pgsql-performance-ar@postgresql.org>)
 id 1a8mlj-00087R-D1
 for pgsql-performance@arkaria.postgresql.org; Tue, 15 Dec 2015 10:23:43 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
 (Exim 4.84) (envelope-from <gunnar.bluth.extern@elster.de>)
 id 1a8mk6-0006CU-F3
 for pgsql-performance@postgresql.org; Tue, 15 Dec 2015 10:22:02 +0000
Received: from edmmai01.een.elster.de ([217.237.175.34] helo=elster.de)
 by magus.postgresql.org with esmtp (Exim 4.84)
 (envelope-from <gunnar.bluth.extern@elster.de>) id 1a8mk2-0006Tc-S8
 for pgsql-performance@postgresql.org; Tue, 15 Dec 2015 10:22:02 +0000
X-AuthUser: gunnar.bluth.extern@elster.de
Received: from [10.200.128.23] ([192.168.90.2]:37350)
 by elster.de with [XMail 1.27 ESMTP Server]
 id <S10273A3> for <pgsql-performance@postgresql.org> from
 <gunnar.bluth.extern@elster.de>; Tue, 15 Dec 2015 11:21:57 +0100
Subject: Re: Estimation row error
To: pgsql-performance@postgresql.org
References: 
 <CAL+j8ETNDw=76dfWtbM5-eToD-nEEXf+e2jTMy71ugr+j2Sjkw@mail.gmail.com>
 <CAL+j8ERpv43D=oc8gGdfA7FKMwPWWOxteDdZ0=6ya1kB-9GhNA@mail.gmail.com>
 <CAL+j8ETVj=Y7Vo1PtyG5k4c0pBXRArnTfHC1YreUNB7uRNhHZg@mail.gmail.com>
 <566FDC8A.8050701@elster.de> <20151215094938.GA19049@tux>
From: "Gunnar \"Nick\" Bluth" <gunnar.bluth.extern@elster.de>
Message-ID: <566FE9C5.3080505@elster.de>
Date: Tue, 15 Dec 2015 11:21:57 +0100
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101
 Thunderbird/38.4.0
MIME-Version: 1.0
In-Reply-To: <20151215094938.GA19049@tux>
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -4.2 (----)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Am 15.12.2015 um 10:49 schrieb Andreas Kretschmer:
> Gunnar Nick Bluth <gunnar.bluth.extern@elster.de> wrote:
> 
>> Am 15.12.2015 um 09:05 schrieb Mathieu VINCENT:
>>> Hello,
>>>
>>> No one to help me to understand this bad estimation rows ?
>>
>> Well,
>>
>> on a rather beefy machine, I'm getting quite a different plan:
>> http://explain.depesz.com/s/3y5r
> 
> you are using 9.5, right? Got the same plan with 9.5.

Nope...:
                                                  version

------------------------------------------------------------------------------------------------------------
 PostgreSQL 9.3.5 on x86_64-unknown-linux-gnu, compiled by gcc
(Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit

So much for those correlation improvements then ;-/


> Btw.: Hi Gunnar ;-)

Hi :)

-- 
Gunnar "Nick" Bluth
DBA ELSTER

Tel:   +49 911/991-4665
Mobil: +49 172/8853339


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance