Re: inaccurate stats on large tables

From: "David Wilson" <david(dot)t(dot)wilson(at)gmail(dot)com>
To: mukhyala(at)gene(dot)com
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: inaccurate stats on large tables
Date: 2008-09-05 03:25:43
Message-ID: e7f9235d0809042025o5eae2885p34e701a320309699@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Sep 4, 2008 at 2:21 PM, Kiran Mukhyala <mukhyala(dot)kiran(at)gene(dot)com> 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(dot)t(dot)wilson(at)gmail(dot)com

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Thomas Finneid 2008-09-05 08:09:21 Re: slow update of index during insert/copy
Previous Message Duan Ligong 2008-09-05 02:58:00 Re: too many clog files