Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group