Re: [GENERAL] Seg Fault in backend after beginning to use xpath (PG 9.0, FreeBSD 8.1)

2011-05-02 Thread alan bryan
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

[GENERAL] Seg Fault in backend after beginning to use xpath (PG 9.0, FreeBSD 8.1)

2011-05-02 Thread alan bryan
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

[GENERAL] How to track query execution time

2008-02-05 Thread alan bryan
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