Statistics on a table - Mailing list pgsql-general

From Maksim Likharev
Subject Statistics on a table
Date
Msg-id 56510AAEF435D240958D1CE8C6B1770A014A0DF3@mailc03.aurigin.com
Whole thread Raw
Responses Re: Statistics on a table  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
Hi,
I just found very interesting situation,
statistic ( n_distinct in particular) records for one of my columns,
greatly under calculated it saying:

49726, but in reality 33409816.

So planer never choose index but rather using table scan, and query
never returns,
is it any way how I can improve that?

I can turn seqscan off but is it safe?

pgsql-general by date:

Previous
From: "Maksim Likharev"
Date:
Subject: Re: PG crash on simple query, story continues
Next
From: Joseph Shraibman
Date:
Subject: where is the list of companies that provide commercial support?