X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 3B5A89DCD5A for ; Tue, 6 Dec 2005 05:41:16 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 72538-04 for ; Tue, 6 Dec 2005 05:41:17 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from web31502.mail.mud.yahoo.com (web31502.mail.mud.yahoo.com [68.142.198.131]) by postgresql.org (Postfix) with SMTP id 9DE7F9DCC6A for ; Tue, 6 Dec 2005 05:41:13 -0400 (AST) Received: (qmail 42115 invoked by uid 60001); 6 Dec 2005 09:41:15 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=IQ523bWFxQ7NE113BczOC0WJWFR0n4ny/aJ0+RW2df7+H3P6eR9cRPZ8smg9NFcDf86CsvOPUAZ7C350IuaPyk8I4Q3Z7mABlBB8Q0QPXcrM3Q4QymTSPSmoQHqtd2q9pRIiVgfoWRIhbjU0/B0D+L2bWmFsZhrcLOk/pvBGi1M= ; Message-ID: <20051206094115.42113.qmail@web31502.mail.mud.yahoo.com> Received: from [202.6.239.250] by web31502.mail.mud.yahoo.com via HTTP; Tue, 06 Dec 2005 01:41:15 PST Date: Tue, 6 Dec 2005 01:41:15 -0800 (PST) From: Jenny Subject: need help (not anymore) To: pgsql-performance@postgresql.org, pgsql-sql@postgresql.org, pgsql-general@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.383 required=5 tests=[AWL=-0.096, DNS_FROM_RFC_ABUSE=0.479] X-Spam-Score: 0.383 X-Spam-Level: X-Archive-Number: 200512/300 X-Sequence-Number: 87863 I run the VACUUM as you suggested, but still no response from the server. So, I decided to DROP the database. I got a message that the database is being used. I closed every application that accessing it. But, the message remains. I checked the server processes (ps -ax). There were lots of 'UPDATE is waiting ...' on the list. I killed them all. I backuped current database and DROP the database, restore to the backup file I just made. Don't really know why this happened, but thankfully now, everything's normal. Thank you, guys. Regards, Jenny Tania __________________________________________ Yahoo! DSL – Something to write home about. Just $16.99/mo. or less. dsl.yahoo.com