On Mon, 22 Sep 2014 12:15:27 -0700 Luke Coldiron <lukecoldiron@xxxxxxxxxxx> 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 <emorrasg@xxxxxxxx> -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
