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
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
I have such situation at work. Size of database on disk is 60GB and is
In response to
pgsql-performance by date
|Next:||From: Scott Marlowe||Date: 2008-08-01 01:27:46|
|Subject: Re: SSD Performance Article|
|Previous:||From: Matthew T. O'Connor||Date: 2008-07-31 17:45:38|
|Subject: SSD Performance Article|