Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WuTjX-0005hT-4k for pgsql-performance@arkaria.postgresql.org; Tue, 10 Jun 2014 21:37:31 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WuTjW-0002HT-2z for pgsql-performance@arkaria.postgresql.org; Tue, 10 Jun 2014 21:37:30 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1WuTjU-0002HJ-Tt for pgsql-performance@postgresql.org; Tue, 10 Jun 2014 21:37:28 +0000 Received: from sam.nabble.com ([216.139.236.26]) by magus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1WuTjP-0003fX-AX for pgsql-performance@postgresql.org; Tue, 10 Jun 2014 21:37:27 +0000 Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1WuTjM-0000zL-71 for pgsql-performance@postgresql.org; Tue, 10 Jun 2014 14:37:20 -0700 Date: Tue, 10 Jun 2014 14:37:20 -0700 (PDT) From: tim_wilson To: pgsql-performance@postgresql.org Message-ID: <1402436240210-5806743.post@n5.nabble.com> In-Reply-To: <1402053752755-5806320.post@n5.nabble.com> References: <1400459729388-5804416.post@n5.nabble.com> <11299.1400559202@sss.pgh.pa.us> <1402016119875-5806283.post@n5.nabble.com> <1402037012706-5806302.post@n5.nabble.com> <1402053752755-5806320.post@n5.nabble.com> Subject: Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -0.1 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org Was my example not able to be repeated or do I need to give you a better example of the problem, or is there just a lot of stuff happening? Happy to do more work on example sql for the problem if it needs it, just need some feed back on how whether this problem is going to be looked at or not. regards Tim -- View this message in context: http://postgresql.1045698.n5.nabble.com/autovacuum-vacuum-creates-bad-statistics-for-planner-when-it-log-index-scans-0-tp5804416p5806743.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance