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. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings