X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 088568B9C34 for ; Thu, 3 Feb 2005 01:33:11 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 60734-02 for ; Thu, 3 Feb 2005 01:33:06 +0000 (GMT) Received: from smtp4.brturbo.com.br (unknown [200.199.201.180]) by svr1.postgresql.org (Postfix) with ESMTP id 587FB8B9B16 for ; Thu, 3 Feb 2005 01:33:06 +0000 (GMT) Received: from [200.180.188.41] (200-180-188-041.paemt7005.dsl.brasiltelecom.net.br [200.180.188.41]) by smtp4.brturbo.com.br (Postfix) with ESMTP id AA50033EDC for ; Wed, 2 Feb 2005 23:33:02 -0200 (BRST) Received: from 127.0.0.1 (AVG SMTP 7.0.300 [265.8.2]); Wed, 02 Feb 2005 23:33:05 -0200 Message-ID: <002d01c50990$4f187270$0105a8c0@Luizrafael> From: "Luiz Rafael Culik Guimaraes" To: References: <1101136693.18148.66.camel@richard> <1101149501.18148.81.camel@richard> Subject: problem with postgres Date: Wed, 2 Feb 2005 23:33:03 -0200 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2527 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.026 tagged_above=0 required=5 tests=RCVD_IN_NJABL_PROXY X-Spam-Level: * X-Archive-Number: 200502/53 X-Sequence-Number: 20164 Dear friends I hope some one can help me Server machine celeron 2.4Gb with 512 Ram postgres 7.4.5 conectiva 8 with kernel 2.4.19 i´m getting many message of Erro:canceling query due to user request how to solve this i even get with an just booted up server, and running vacuum analyze verbose inside psql with no other people connected the only changes i has on postgresql.conf is max_connection=512 shared_buffers=8192 sort_mem=8192 vacuum_mem=31792 Regards Luiz Rafael