X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (mx2.hub.org [200.46.204.254]) by postgresql.org (Postfix) with ESMTP id DFF1F11F606F for ; Wed, 12 Apr 2006 06:43:45 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.001 X-Spam-Level: X-Spam-Status: No, score=0.001 required=5 tests=[BAYES_50=0.001] Received: from postgresql.org ([200.46.204.71]) by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024) with ESMTP id Wmiqa3sQ0aKX for ; Wed, 12 Apr 2006 06:43:42 -0300 (ADT) X-Greylist: delayed 00:08:16.989032 by SQLgrey- Received: from smtp5.libero.it (smtp5.libero.it [193.70.192.55]) by postgresql.org (Postfix) with ESMTP id 46F3A11F6071 for ; Wed, 12 Apr 2006 06:43:41 -0300 (ADT) Received: from localhost (172.16.1.15) by smtp5.libero.it (7.0.027-DD01) id 43F225CF056E819D for pgsql-www@postgresql.org; Wed, 12 Apr 2006 11:35:22 +0200 Received: from smtp1.libero.it ([172.16.1.225]) by localhost (asav11.libero.it [193.70.192.93]) (amavisd-new, port 10024) with ESMTP id 20697-12-6 for ; Wed, 12 Apr 2006 11:35:22 +0200 (CEST) Received: from firewall (unknown [151.9.34.201]) by smtp1.libero.it (Postfix) with SMTP id D5B5EA8C19 for ; Wed, 12 Apr 2006 11:35:21 +0200 (MEST) Received: (qmail 32034 invoked from network); 12 Apr 2006 09:43:49 -0000 Received: from unknown (HELO andreag) (151.9.34.199) by 0 with SMTP; 12 Apr 2006 09:43:49 -0000 From: "Andrea Grassi" To: Subject: slowness with holdable cursor Date: Wed, 12 Apr 2006 11:33:49 +0200 Message-ID: <000701c65e14$340bc020$e901027b@andreag> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.6604 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal X-AntiVirus: controllato da antivirus McAfee offerto da SogeaSoft X-Scanned: with antispam and antivirus automated system at libero.it X-Archive-Number: 200604/26 X-Sequence-Number: 9802 Hi. I have a problem of fastness with "declare xxx cursor WITH HOLD". My postgres version is 7.4.6 I have a table with 20000 rows named "base_a_artico" If I use "declare a cursor with hold for select cdart,descr from base_a_artico" outside a transaction I wait 2 seconds. If I use the same statement (or the similar without "WITH HOLD") inside a trasaction, I wait only 4 msec (milliseconds) !!! I don't understand why this happens .... I have to set some parameters in the postgresql.conf ? thanks Andrea Grassi Le informazioni contenute in questo messaggio di posta elettronica sono di natura confidenziale; qualsiasi pubblicazione, utilizzo o diffusione anche parziale dello stesso non puņ essere effettuata senza autorizzazione e potrebbe costituire un illecito penale ai sensi del Decreto Legs.vo N° 196/2003 sulla Protezione dei Dati Personali e del Codice Penale, Art. 617-621-635 bis oltre che della legge 547/93. Qualora non siate tra i legittimi destinatari di questa e-mail Vi preghiamo cortesemente di cancellarla dal Vostro sistema dopo aver notificato al mittente, rispondendo alla comunicazione, l'errore da questi commesso.