On Sun, 8 Feb 2004, Bruno BAGUETTE wrote:
> > On Fri, 6 Feb 2004, Bruno BAGUETTE wrote:
> >
> > > > In addition to what Tom said, the row estimates look suspiciously
> > > > default. You mention vacuuming, but do you ever analyze
> > > > the tables?
> > >
> > > I run VACUUM FULL ANALYZE with the postgres user on all the
> > > PostgreSQL
> > > databases on the server, twice a day, sometimes more.
> >
> > Wierd, because you're getting 1000 estimated on both people
> > and organizations. What does pg_class have to say about
> > those two tables?
>
> I'm sorry but I think that I misunderstand you. Are you telling me that
> running VACUUM FULL ANALYZE is weird ? Or do you mean another thing ?
No, I was saying it's wierd that it'd be misestimating to the default
values after a vacuum full analyze.
