X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx2.hub.org [200.46.204.254]) by postgresql.org (Postfix) with ESMTP id 00A0B11F65A3 for ; Thu, 20 Apr 2006 12:21:04 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: -2.599 X-Spam-Level: X-Spam-Status: No, score=-2.599 required=5 tests=[BAYES_00=-2.599] Received: from postgresql.org ([200.46.204.71]) by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024) with ESMTP id UzJOqQLU8c8g for ; Thu, 20 Apr 2006 12:20:56 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mta1.siol.net (mta1.siol.net [193.189.160.88]) by postgresql.org (Postfix) with ESMTP id AD98D11F61BF for ; Thu, 20 Apr 2006 12:20:55 -0300 (ADT) Received: from edge2.siol.net ([10.10.10.211]) by mta1.siol.net with ESMTP id <20060420152053.QJJD21004.mta1.siol.net@edge2.siol.net> for ; Thu, 20 Apr 2006 17:20:53 +0200 Received: from AR6 ([193.77.151.117]) by edge2.siol.net with SMTP id <20060420152053.YSDC7870.edge2.siol.net@AR6> for ; Thu, 20 Apr 2006 17:20:53 +0200 Message-ID: <011b01c6648e$067ee170$1e4ba8c0@AR6> From: "Radovan Antloga" To: Subject: Performance decrease Date: Thu, 20 Apr 2006 17:20:56 +0200 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="windows-1250"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2869 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 X-Archive-Number: 200604/456 X-Sequence-Number: 18540 I'm new to PG and I'm testing default PG settings for now. I have PG 8.1.3. installed with autovacuum=on. My test table has 15830 records with 190 fields. I have different fields types (date, numeric, varchar, integer, smallint,...). I decided to evaluate PG because I need to use schemas. First test I did is not very promising. I tried to update one fields in test table several times to see how PG react on this. I do like this: update table set field = null After first execute I get time 3 seconds. Then I repeat this update. After each update time increase. I get 4 sec, 7 sec, 10 sec, 12 sec, 15 sec, 18 sec, 21 sec. Is this normal (default) behaviour or I must do something to prevent this. Regards, Radovan Antloga