Arvind Singh wrote: > I have come across a very peculiar situation. > > We have a postgres installation 9.0. It was installed last year. > > But we started implementation on it, just recently. > > And therefore the need to develop a Logparser application. > > During our preliminary parsing , What we discovered is just beyond the grasp of my knowledge. > > It seems that during a certain period lastyear in November, it created a Session entry that holds more > than > Fifty thousand records for a SINGLE SESSION (4ebccaa2.20c) . Yes that is 5 with five zeros > > One does look at wonder of the Dawn of November when such occurance holds place. > Is it divine intervention, because we never parsed the log in those days and therefore cannot > ascertain the reasons for such verbosity.
It would indeed be divine intervention if fifty thousand had five zeros. Other than that, I don't see anything special about that. A session can last pretty long. Maybe you can solve your mystery by looking at the log entries. They should tell you what was going on. > Although it never reoccurs and luckily we had csv option on during that period. > > Where should i report such findings I don't think there is anything wrong. At least nothing database related. > I have uploaded that Part of Log at http://dl.dropbox.com/u/71964910/pg_log_with_lot_of_session.zip That looks like somebody turned on "log_statement_stats" for a spell. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
