On Mon, May 2, 2011 at 10:39 PM, Tom Lane wrote:
> alan bryan writes:
>> Checking out postgres.core and we see:
>
>> (gdb) bt
>> #0 0x0008f5f19afd in pthread_mutex_lock () from /lib/libthr.so.3
>> #1 0x000800d22965 in xmlRMutexLock () from /us
Our developers started to use some xpath features and upon deployment
we now have an issue where PostgreSQL is seg faulting periodically.
Any ideas on what to look at next would be much appreciated.
FreeBSD 8.1
PostgreSQL 9.0.3 (also tried upgrading to 9.0.4) built from ports
Libxml2 2.7.6 (also
I've got a web site (apache/php) with a postgres 8.2.5 database(s).
We're now getting some periods of high load. We have a lot of dynamic
queries so I'm not able to just tune and optimize a few known queries
ahead of time.
Is there a way that I can get a list of all the actually SQL queries
as p