[GENERAL] pqSocketCheck() didn't return, hung in poll()? Is it a bug?

2009-07-08 Thread Lizzy M
Hi all, I have this problem today: one thread of our application hung, and we found the thread waiting for the result of poll() function. poll() was called by pgSocketCheck(). So is it a bug of pg? I found the bug report from website(http://archives.postgresql.org/pgsql-bugs/2008-02/msg00260.

[GENERAL] Can postgresql store its data on raw device now?

2009-06-09 Thread Lizzy M
Hello, I have an problem: can postgresql store its data on the raw disks now? I have checked the mail list and manual, but haven’t found the answer. In some early mails, they mentioned pg didn’t support this character. But how about now? Raw disk may reduce the risks brought by fi