Re: [ADMIN] Re: What else could I've done? COPY to unlogged tbl "hung"/locked the table

2012-08-31 Thread Tom Lane
amacvar writes: > In addition here is a backtrace of the process while it hung again today: > (thanks to our SA Eric) > #0 0x00396c8d4627 in semop () from /lib64/libc.so.6 > #1 0x005dc313 in PGSemaphoreLock () > #2 0x00616586 in LWLockAcquire () > #3 0x

[ADMIN] Re: What else could I've done? COPY to unlogged tbl "hung"/locked the table

2012-08-31 Thread amacvar
In addition here is a backtrace of the process while it hung again today: (thanks to our SA Eric) #0 0x00396c8d4627 in semop () from /lib64/libc.so.6 #1 0x005dc313 in PGSemaphoreLock () #2 0x00616586 in LWLockAcquire () #3 0x004a718c in ginHeapTupleF