Postgres Pro
Downloads
Home   >   mailing lists

Re: inaccurate stats on large tables - Mailing list pgsql-performance

From David Wilson
Subject Re: inaccurate stats on large tables
Date
Msg-id e7f9235d0809042025o5eae2885p34e701a320309699@mail.gmail.com
Whole thread Raw
In response to inaccurate stats on large tables  (Kiran Mukhyala <mukhyala.kiran@gene.com>)
List pgsql-performance
Tree view 
On Thu, Sep 4, 2008 at 2:21 PM, Kiran Mukhyala <mukhyala.kiran@gene.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.t.wilson@gmail.com

pgsql-performance by date:

Previous
From: Duan Ligong
Date:
Subject: Re: too many clog files
Next
From: Thomas Finneid
Date:
Subject: Re: slow update of index during insert/copy