pgsql <pgsql@xxxxxxxxxxx> writes: > one of our pgsql instances recently started to segfault multiple times a > week. I tried a couple of things to pin it down to a certain query > or job but failed to find any pattern. All I can offer is some notes > and a set of similar looking back traces. All of those traces seem to be within plpgsql functions that are doing some sort of schema update on a table. Sure you can't pin it down a little better? Looking at debug_query_string in the core dumps would at least show what SQL command is calling the function(s) --- and I wouldn't be surprised if there's exactly one function involved here. As per Alvaro's suggestion, installing postgresql-debuginfo would make the stack traces a lot more useful, too. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
