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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
