| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com> |
| Cc: | Kevin Grittner <kevin(dot)grittner(at)wicourts(dot)gov>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Florian Helmberger <fh(at)25th-floor(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [ADMIN] pg_class reltuples/relpages not updated by autovacuum/vacuum |
| Date: | 2011-05-25 17:37:07 |
| Message-ID: | 1306344946-sup-417@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-hackers |
Excerpts from Cédric Villemain's message of mié may 25 13:24:01 -0400 2011:
> > Well, we only actually need to store one number, because you can figure
> > out a much more precise number-of-pages figure with pg_relation_size()
> > divided by configured page size.
> I may miss something but we need relation size in costsize.c even if
> we have a reldensity (or we need a reltuples). Else what values should
> be used to estimate the relation size ? (pg_relation_size() goes down
> to kernel/fs to ask the stat.st_size, is it really what we want?)
Actually yes, the planner does go to kernel to determine the current
relation size, and then multiplies by density as computed from catalog
data to figure out current reasonably accurate number of tuples.
--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marcelo Leite | 2011-05-25 17:44:23 | Re: How to remove conflicts when installing postgres where some other installation of postgres is already running using silent installer |
| Previous Message | Robert Haas | 2011-05-25 17:31:03 | Re: [ADMIN] pg_class reltuples/relpages not updated by autovacuum/vacuum |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2011-05-25 17:40:56 | Re: Hash Anti Join performance degradation |
| Previous Message | Hitoshi Harada | 2011-05-25 17:37:04 | Re: Pull up aggregate subquery |