Thanks. I'll investigate and let you know how things go....
Tom Lane wrote:
>Mike Darretta <michael(dot)darretta(dot)ctr(at)metnet(dot)navy(dot)mil> writes:
>>I'm an application developer trying to understand a pg data partition
>>issue. We are storing large objects (gifs) at a rate of about 1GIG /day.
>>After about a week, most of the objects are recycled -- that is, an
>>insert triggers a delete of a similar object. The postgres data
>>partition, though, continues to grow, even though the objects are
>>successfully deleted from the application *and* largeobject tables.
>You need to check your free-space-map settings --- it sounds like the
>FSM is not large enough to keep track of all the free space in
>If you do a "vacuum verbose" across the whole database, the tail end of
>the (voluminous) printout will tell you something about where you need
>to set the FSM parameters.
> regards, tom lane
In response to
pgsql-admin by date
|Next:||From: RWilke||Date: 2004-09-30 19:55:42|
|Subject: Clustering PostgreSQL|
|Previous:||From: Tom Lane||Date: 2004-09-30 16:30:09|
|Subject: Re: reconstructing database |