Re: large table

On Monday, September 22, 2014 11:17:05 AM Luke Coldiron wrote:
> The actual size of the table is around 33 MB.
> The myFunc function is called every 2.5 seconds and the wasUpdated function
> every 2 seconds by separate processes. I realize that running a FULL VACUUM
> or CLUSTER command on the table will resolve the issue but I am more
> interested in a root cause that explains why this table would end up in
> this state. I have tried to reproduce this issue by running the exact setup
> and have not been able to get the table to grow like this example. Any
> plausible cause'es or explanations would be much appreciated. Luke

I'd guess that some other process held a transaction open for a couple of
week, and that prevented any vacuuming from taking place.