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. BTW, there is a post-8.3.10 patch for a problem that could easily match what you are showing. Dunno if you are up for applying patches yourself, but if so try adding this one: http://archives.postgresql.org/pgsql-committers/2010-04/msg00122.php Now, the fact that that's fixing a problem introduced in January might mean it's not what you're seeing. However, the January patch was fixing a different issue in the same general area. It could be that your app was managing to tickle both the old bug (in 8.3.7) and the new one (in 8.3.10). 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
