Re: pg_statistic doesnt contain details for specific table

From: "Nimesh Satam" <nimesh(dot)zedo(at)gmail(dot)com>
To: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org, database(at)zedo(dot)com
Subject: Re: pg_statistic doesnt contain details for specific table
Date: 2007-06-11 08:58:32
Message-ID: 965aa3ed0706110158r27c9c19aj32a87d9ccf7e2383@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Heikki,

Thank you for replying.

We have already used analyze command on the table.
We have also ran the vacuum analyze command.

But they are not helping.

Thanks,
Nimesh.

On 6/11/07, Heikki Linnakangas <heikki(at)enterprisedb(dot)com> wrote:
>
> Nimesh Satam wrote:
> > While monitioring we noticed that there are no details in the
> pg_statistics
> > for a particular table. Can you let us know what might be the reason?
> Also
> > what steps can be taken care for adding the statistics?
>
> Have you ANALYZEd the table?
>
> --
> Heikki Linnakangas
> EnterpriseDB http://www.enterprisedb.com
>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Dave Cramer 2007-06-11 10:55:36 Re: How much ram is too much
Previous Message Heikki Linnakangas 2007-06-11 08:54:12 Re: pg_statistic doesnt contain details for specific table