Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 25D6864FCFE for ; Fri, 5 Sep 2008 00:26:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 10254-08 for ; Fri, 5 Sep 2008 00:26:23 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from yx-out-2324.google.com (yx-out-2324.google.com [74.125.44.30]) by postgresql.org (Postfix) with ESMTP id 44F3D64FCEF for ; Fri, 5 Sep 2008 00:25:44 -0300 (ADT) Received: by yx-out-2324.google.com with SMTP id 8so155759yxb.73 for ; Thu, 04 Sep 2008 20:25:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=TthsNPtxCP8hWWyntGJQioprx3Ym8cNXFiIg+D6mgeM=; b=TlgM25fLtBW1c2vDbx5ZYm6Ib6Nx+M6uXkwpBiKbHdAwwR0s6B5Iht4GPYNesGSIa/ oao3xKBEVpD/C6e3H/EpAUFUAqLsjs+J2TAv+eWRz5yJneiewnnBh4++kPmaOG424l3n J+KcoBaZ3PZf4qX/NJHFSnzvhMyvzCRStov6E= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=fIkjf2ZKYc4uEA+vRqtE2qKRpay4M2SnOzoAdxDs8YSV7+FlqfPiyeknhy+wUeaIuW 7lPus4OE1M5OEqzLs8rgqcfvlQHvN5KGdQZxnC48E85C3zOu2eki8QF8bwVPD/yIq2oV r4SvU7yAbO33zSo+PVN3erOYd5HCIm52ZCKsw= Received: by 10.150.54.6 with SMTP id c6mr15567923yba.223.1220585143972; Thu, 04 Sep 2008 20:25:43 -0700 (PDT) Received: by 10.150.134.10 with HTTP; Thu, 4 Sep 2008 20:25:43 -0700 (PDT) Message-ID: Date: Thu, 4 Sep 2008 23:25:43 -0400 From: "David Wilson" To: mukhyala@gene.com Subject: Re: inaccurate stats on large tables Cc: pgsql-performance@postgresql.org In-Reply-To: <1220552512.3853.320.camel@sausalito.gene.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <1220552512.3853.320.camel@sausalito.gene.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/68 X-Sequence-Number: 31381 On Thu, Sep 4, 2008 at 2:21 PM, Kiran Mukhyala wrote: > Can someone please tell me how to improve the query planner > estimate? I did try vacuum analyze. Here are some details: Have you tried increasing the statistics target for that table (or in general)? -- - David T. Wilson david.t.wilson@gmail.com