Postgres Pro
Downloads
Home   >   mailing lists

Re: strange row number estimates in pg9.1rc1 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: strange row number estimates in pg9.1rc1
Date
Msg-id 18366.1314722499@sss.pgh.pa.us
Whole thread Raw
In response to Re: strange row number estimates in pg9.1rc1  ("Sergey E. Koposov" <math@sai.msu.ru>)
List pgsql-hackers
Tree view 
"Sergey E. Koposov" <math@sai.msu.ru> writes:
> I wonder what should be the best way to proceed for already migrated 
> databases -- running analyze repeatedly may not be the best way for 
> very large clusters with large tables...

You can just manually update pg_class.reltuples to a more reasonable
value.
        regards, tom lane

pgsql-hackers by date:

Previous
From: "Sergey E. Koposov"
Date:
Subject: Re: strange row number estimates in pg9.1rc1
Next
From: Josh Kupershmidt
Date:
Subject: Re: dropdb and dropuser: IF EXISTS