Re: [HACKERS] Serious problem with my postgres

2002-08-28 Thread Tom Lane
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes: > After a crash and several restarts this morning, my postgres 7.2.1 is > running very oddly. > The processes are hanging in semwait or sbwait or biord states, but mostly > sbwait. Some random poking around in google says that sbwait state is

[HACKERS] Serious problem with my postgres

2002-08-28 Thread Christopher Kings-Lynne
Hi guys, After a crash and several restarts this morning, my postgres 7.2.1 is running very oddly. Every time you execute a query it basially takes forever. Some of them actually do take forever. eg: "select * from users" just hangs forever. As people use the site all available postgres slots