SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-08-2008, 08:23 PM
| ||||
| ||||
 Re: Recovering real disk space On Wed, Mar 30, 2005 at 13:09:33 -0500, Adam Siegel <adam@sycamore.us> wrote: > > We perform a vacuum full after each mass delete. This cycle can happen > many times during over a couple of weeks. We are in a test lab > environment and are generating a lot of data. > > One of the problems we have is that the vacuum on the table can take up > to 10 hours. We also expect to see the physical disk space go down, but > this does not happen. If we accidently fill up the disk, then all bets > are off and we are unable to recover. A vacuum never seems to finish > (several days). This may mean that there are open transactions pinning the records you have deleted so that they aren't being removed by the vacuum. Also, under some circumstances a CLUSTER can be faster than a VACUUM FULL. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq      |
|
04-08-2008, 08:25 PM
| ||||
| ||||
| Re: Recovering real disk space Isn't this also a symptom of inappropriate FSM settings? Try running a VACUUM VERBOSE and check the FSM settings at the end. -tfo -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC Strategic Open Source — Open Your i™ http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005 On Apr 3, 2005, at 8:21 AM, Bruno Wolff III wrote: > On Wed, Mar 30, 2005 at 13:09:33 -0500, > Adam Siegel <adam@sycamore.us> wrote: >> >> We perform a vacuum full after each mass delete. This cycle can >> happen >> many times during over a couple of weeks. We are in a test lab >> environment and are generating a lot of data. >> >> One of the problems we have is that the vacuum on the table can take >> up >> to 10 hours. We also expect to see the physical disk space go down, >> but >> this does not happen. If we accidently fill up the disk, then all >> bets >> are off and we are unable to recover. A vacuum never seems to finish >> (several days). > > This may mean that there are open transactions pinning the records you > have deleted so that they aren't being removed by the vacuum. > Also, under some circumstances a CLUSTER can be faster than a VACUUM > FULL. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org |
Linear Mode
