From: | Ron Snyder <snyder(at)roguewave(dot)com> |
---|---|
To: | 'Tom Lane' <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Ron Snyder <snyder(at)roguewave(dot)com> |
Cc: | Tzvetan Tzankov <ceco(at)noxis(dot)net>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: disk space usage enlarging despite vacuuming |
Date: | 2003-05-19 23:01:56 |
Message-ID: | F888C30C3021D411B9DA00B0D0209BE803BBA52C@cvo-exchange.cvo.roguewave.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: Monday, May 19, 2003 3:29 PM
> To: Ron Snyder
> Cc: Tzvetan Tzankov; pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] disk space usage enlarging despite vacuuming
>
>
> Ron Snyder <snyder(at)roguewave(dot)com> writes:
> >> What's your turnover rate for updating or deleting large objects?
> > There's probably only about 10K additions/day, and there
> should be about
> > 7500 deletions/day.
>
> How large are the objects in question?
They average 24K (or less).
>
> >> I'm guessing that you have the FSM parameters (in
> postgresql.conf) set
> >> too small to allow the system to keep track of all the
> free space in
> >> pg_largeobject.
>
> > Doh! I meant to include this info, because I knew you'd want it.
> > max_fsm_pages is 100K, and max_fsm_relations is left at the
> default (of
> > 100).
>
> 100 is almost certainly too small for max_fsm_relations (we've changed
> the default to 1000 as of 7.3.something). How many active
> databases do
> you have, and how many user tables?
In that database cluster, there are 4 databases (template0, template1, pgqv,
quickview). A '\d' for the first three says "No relations", and for the
last one lists 17. (15 tables, 1 view, 1 sequence). Running the following
query for the quickview database:
"Select count(*) from pg_indexes where tablename not like 'pg%';"
count
-----
31
Thanks,
-ron
From | Date | Subject | |
---|---|---|---|
Next Message | Dennis Gearon | 2003-05-19 23:19:38 | If you can't write it yourself, buy it, the story of microsoft |
Previous Message | Reece Hart | 2003-05-19 23:00:35 | Re: inheritance vs 1-1 relationship |