On Sat, Jan 22, 2011 at 2:27 AM, John Lister <john.lister@xxxxxxxxxxxxx> wrote: > Instead I tried to vacuum them, but this didn't make any difference (or > indeed do anything), so in the end I deleted the tables manually instead, > which instantly reset the transaction count back to the 1billion mark. I > now need to find out which process probably died due to its temp tables > disappearing, again they appeared odd - single alphabetical names - which I > wasn't expecting... > > Was this expected behaviour with temporary tables? It's more expected behavior when you have long running transactions. I haven't seen it caused by temp tables. Was the parent process in a really long transaction or just open a long time without one? -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
