Skip site navigation (1) Skip section navigation (2)

Re: Data Partition is Growing

From: Mike Darretta <michael(dot)darretta(dot)ctr(at)metnet(dot)navy(dot)mil>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Data Partition is Growing
Date: 2004-09-30 16:43:12
Message-ID: 415C37A0.2080602@metnet.navy.mil (view raw or flat)
Thread:
Lists: pgsql-admin
Thanks. I'll investigate and let you know how things go....

Mike

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
>pg_largeobject.
>
>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: RWilkeDate: 2004-09-30 19:55:42
Subject: Clustering PostgreSQL
Previous:From: Tom LaneDate: 2004-09-30 16:30:09
Subject: Re: reconstructing database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group