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 4A65A8B9B16 for ; Thu, 3 Feb 2005 01:43:50 +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 60822-05 for ; Thu, 3 Feb 2005 01:43:38 +0000 (GMT) Received: from smtp.uol.com.br (smtpout2.uol.com.br [200.221.4.193]) by svr1.postgresql.org (Postfix) with ESMTP id 0899A8B9B72 for ; Thu, 3 Feb 2005 01:43:37 +0000 (GMT) Received: from [200.180.188.41] (200-180-188-041.paemt7005.dsl.brasiltelecom.net.br [200.180.188.41]) by scorpion2.uol.com.br (Postfix) with ESMTP id 062B97E05 for ; Wed, 2 Feb 2005 23:43:35 -0200 (BRST) Received: from 127.0.0.1 (AVG SMTP 7.0.300 [265.8.2]); Wed, 02 Feb 2005 23:43:38 -0200 Message-ID: <008a01c50991$c86223f0$0105a8c0@Luizrafael> From: "Luiz Rafael Culik Guimaraes" To: Subject: problem with postgres Date: Wed, 2 Feb 2005 23:43:38 -0200 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response 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.4 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, RCVD_IN_NJABL_PROXY X-Spam-Level: * X-Archive-Number: 200502/52 X-Sequence-Number: 20163 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