[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

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

2012-08-31 Thread Tom Lane
amacvar kahitarich-postgresfo...@yahoo.com 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