From: | Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com> |
---|---|
To: | Bill Moran <wmoran(at)potentialtech(dot)com> |
Cc: | Vivek Khera <vivek(at)khera(dot)org>, Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Calculation for Max_FSM_pages : Any rules of thumb? |
Date: | 2007-11-21 00:14:07 |
Message-ID: | 1195604047.19563.4.camel@neuromancer.home.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, 2007-11-19 at 08:24 -0500, Bill Moran wrote:
> In response to Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)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.
>
You are right. This is definitely a snafu in my interpretation. After I
restarted PG on the laptop, the numbers went away. So, then I'm confused
as to why the above "gem" was provided as a means to see which tables
needs more vacumming.
ANyway...
From | Date | Subject | |
---|---|---|---|
Next Message | Finn Lassen | 2007-11-21 00:54:52 | VB ADODB .Open failing |
Previous Message | Steve Atkins | 2007-11-20 23:54:38 | Re: IP addresses |