Re: "analyze" putting wrong reltuples in pg_class
| От | Ron Mayer |
|---|---|
| Тема | Re: "analyze" putting wrong reltuples in pg_class |
| Дата | |
| Msg-id | Pine.LNX.4.33.0208022328000.13301-100000@ron обсуждение исходный текст |
| Ответ на | Re: "analyze" putting wrong reltuples in pg_class (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: "analyze" putting wrong reltuples in pg_class
|
| Список | pgsql-bugs |
On Fri, 2 Aug 2002, Tom Lane wrote:
> >> it would be interesting to see what contrib/pgstattuple shows...
> >> if you can run that conveniently.
> > Gladly, if I'm shown where to find it.
> If you built from a source package, the contrib stuff should be in that
> package. If you used RPMs, look for the pgsql-contrib RPM in the same
> set.
I assume I run it like this... ?
logs2=#
logs2=# select pgstattuple('e_ip_full');
NOTICE: physical length: 293.84MB live tuples: 1697755 (169.26MB, 57.60%)
dead tuples: 0 (0.00MB, 0.00%) free/reusable space: 110.84MB (37.72%)
overhead: 4.67%
pgstattuple
-------------
0
(1 row)
logs2=#
В списке pgsql-bugs по дате отправления: