On Mon, 22 Sep 2014 12:15:27 -0700 Luke Coldiron <[email protected]> wrote:
> > > I'd guess that some other process held a transaction open for a > > > couple of week, and that prevented any vacuuming from taking > > > place. > > > > Interesting idea, on the surface I'm not sure how this would have > happened in the system but I can certainly explore forcing this to > happen and see if the result is similar. It happened when I developed with Java+Hibernate. It opened a transaction and made a lot of inserts and deletes while the app run. It created GB size tables with few rows and a permament 'IDLE in TRANSACTION' stops any autovacuum. --- --- Eduardo Morras <[email protected]> -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
