Re: Calculation for Max_FSM_pages : Any rules of thumb?

In response to Ow Mun Heng <Ow.Mun.Heng@wdc.com>:
>
> Even with the regular vacuuming and even a vacuum full ( on my test DB)
> I still see that perhaps something is wrong (from the below)
>
> (I got this gem from the mailling list archives)
> hmxmms=> SELECT
>     c.relname,
>     c.reltuples::bigint as rowcnt,
>     pg_stat_get_tuples_inserted(c.oid) AS inserted,
>     pg_stat_get_tuples_updated(c.oid) AS updated,
>     pg_stat_get_tuples_deleted(c.oid) AS deleted
> FROM pg_class c
> WHERE c.relkind = 'r'::"char"
> GROUP BY c.oid, c.relname, c.reltuples
> HAVING pg_stat_get_tuples_updated(c.oid) +
> pg_stat_get_tuples_deleted(c.oid) > 1000
> ORDER BY pg_stat_get_tuples_updated(c.oid) +
> pg_stat_get_tuples_deleted(c.oid) DESC;
>         relname        |  rowcnt  | inserted | updated | deleted
> -----------------------+----------+----------+---------+----------
>  tst_r                 | 11971691 |        0 |       0 | 22390528 <--
>  pg_statistic          |     1465 |      280 |    7716 |      153
>  dr_ns                 |  2305571 |     1959 |       0 |     1922
>  pg_attribute          |     3787 |     1403 |     184 |     1292
>
> No matter how many times I vacuum/full the deleted number still doesn't
> go down.

Are you sure you're interpreting that number correctly?  I took it to
mean a counter of the number of delete operations since server start.

--
Bill Moran
http://www.potentialtech.com