PostgreSQL hang on FreeBSD,with CFLAGS='-O2 -pthread' workaround

hi~ pg hackers,
I find some problems when use pg on FreeBSD.On FreeBSD,If installed
extension which pthread lib is used,for example plv8,pljava,imcs etc,when
query touch these extenstions,the PG backend will hang.

there is a solution,which configure postgresql with CFLAGS='-O2 -pthread'
and compile pg from source ,then install the extension.But this solution is
not offical documented and not easy to use(you must compile pg from
source).It may make some extension developers or user waste much time to
solve it,and make people complain that PG or FreeBSD not stable.

Is it a PG problem and can we fix it?

I will also report this to the FreeBSD mail list.

ref:
http://www.postgresql.org/message-id/534785D2.6050105@matrix.gatewaynet.com

https://github.com/knizhnik/imcs/issues/25

http://code.google.com/p/plv8js/issues/detail?id=34

Jov
blog: http:amutu.com/blog <http://amutu.com/blog>