Re: Database size Vs performance degradation

[Andrzej Zawadzki <zawadaa(at)wp(dot)pl>]

Mark Roberts wrote:
> On Wed, 2008-07-30 at 13:51 -0400, Tom Lane wrote:
>   
> > Huh?  Vacuum doesn't block writes.
> >
> >                         regards, tom lane
> >
> >     
>
> Of course, you are correct.  I was thinking of Vacuum full, which is
> recommended for use when you're deleting the majority of rows in a
> table.
>
> http://www.postgresql.org/docs/8.1/interactive/sql-vacuum.html
>   
Maybe I'm wrong but if this "bulk insert and delete" process is cyclical 
then You don't need vacuum full.
Released tuples will fill up again with fresh data next day - after 
regular vacuum.

I have such situation at work. Size of database on disk is 60GB and is 
stable.

--
Andrzej Zawadzki