On Tue, May 14, 2013 at 9:06 AM, S H wrote:
> Got some information from following
>
> http://www.depesz.com/2011/07/06/bloat-happens/
>
> What is the general solution to avoid bloating.
1: Don't do massive deletes
2: Make sure your autovacuum is tuned aggressively enough to keep up
with your work
Got some information from following
http://www.depesz.com/2011/07/06/bloat-happens/
What is the general solution to avoid bloating.
> On Tue, 2013-05-14 at 14:51 +, S H wrote:
> > I am doing some experiment to understand the behaviour of manual
> > vacuum.
> >
> > I created small table and sta
On Tue, May 14, 2013 at 7:51 AM, S H wrote:
> I created small table and started doing insertion/deletion/updation on
> 2 rows in infinite loop. It started bloating around 844 times, but after it
> stopped bloating.. what could be the reason?
>
Did autovacuum kick in and clean up the table?
Is
On Tue, 2013-05-14 at 14:51 +, S H wrote:
> I am doing some experiment to understand the behaviour of manual
> vacuum.
>
> I created small table and started doing insertion/deletion/updation on
> 2 rows in infinite loop. It started bloating around 844 times, but
> after it stopped bloating.. w
I am doing some experiment to
understand the behaviour of manual vacuum.
I created small
table and started doing insertion/deletion/updation on 2 rows in infinite loop.
It started bloating around 844 times, but after it stopped bloating.. what
could be the reason?
In between i am running manual
