"analyze" putting wrong reltuples in pg_class
| От | Ron Mayer |
|---|---|
| Тема | "analyze" putting wrong reltuples in pg_class |
| Дата | |
| Msg-id | Pine.LNX.4.33.0208021416210.13301-100000@ron обсуждение исходный текст |
| Ответ на | Re: Bug #728: Interactions between bytea and character encoding when doing analyze (Anders Hammarquist <iko@strakt.com>) |
| Ответы |
Re: "analyze" putting wrong reltuples in pg_class
|
| Список | pgsql-bugs |
On a number of my tables, "analyze" seems to be putting the wrong value of
"reltuples" in pg_class. "vacuum" seems to be doing the right thing.
An example of the failure mode is shown below. Please let me know what
additional info I could supply if more info would help.
Ron
logs2=# select count(*) from e_ip_full;
count
---------
1697755
(1 row)
logs2=# analyze e_ip_full;
logs2=# select relname,reltuples from pg_class where relname = 'e_ip_full';
relname | reltuples
-----------+-----------
e_ip_full | 7555
(1 row)
logs2=# vacuum e_ip_full;
VACUUM
logs2=# select relname,reltuples from pg_class where relname = 'e_ip_full';
relname | reltuples
-----------+-------------
e_ip_full | 1.69776e+06
(1 row)
logs2=# analyze verbose e_ip_full;
NOTICE: Analyzing e_ip_full
ANALYZE
logs2=# select relname,reltuples from pg_class where relname = 'e_ip_full';
relname | reltuples
-----------+-----------
e_ip_full | 7555
(1 row)
logs2=# \d e_ip_full;
Table "e_ip_full"
Column | Type | Modifiers
----------+-------------------------+-----------
ip | character varying(16) |
dat | date |
dom1 | character varying(255) |
dom2 | character varying(255) |
dom3 | character varying(255) |
dom4 | character varying(255) |
domn | character varying(1024) |
obsolete | boolean |
Indexes: e_ip__domain
Unique keys: e_ip__ip_obsolete_dat
logs2=#
В списке pgsql-bugs по дате отправления: