X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id CCCFAD1E016 for ; Fri, 12 Dec 2003 18:05:36 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 67920-01 for ; Fri, 12 Dec 2003 14:05:05 -0400 (AST) Received: from tino.sinectis.com.ar (tino.sinectis.com.ar [216.244.192.232]) by svr1.postgresql.org (Postfix) with ESMTP id A88A8D1E012 for ; Fri, 12 Dec 2003 14:05:00 -0400 (AST) Received: by tino.sinectis.com.ar (Postfix, from userid 99) id 697FD6C58F; Fri, 12 Dec 2003 15:04:49 -0300 (GMT+3) Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 X-Mailer: Sinectis Webmail 5.6.16-1.4.4 From: nbarraza@uolsinectis.com.ar To: pgsql-performance@postgresql.org Subject: Performance related to size of tables Reply-To: nbarraza@uolsinectis.com.ar Message-Id: <20031212180449.697FD6C58F@tino.sinectis.com.ar> Date: Fri, 12 Dec 2003 15:04:49 -0300 (GMT+3) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/204 X-Sequence-Number: 5064 Hi everyone, I found that performance get worse as the size of a given table increases. I mean, for example I´ve just run some scripts shown in http://www.potentialtech.com/wmoran/postgresql.php I understand that those scripts are designed to see the behavior of postgresql under different filesystems. However, since them generate a lot of I/O activity, I think they can be used to adjust some configuration parameters. In that way, I increased the number of tuples inserted in the initial table to 2000000 and 3000000. What I saw is that the running time goes from 3 min., to 11 min. My question is, is it possible to use that test to tune some parameters?, if the answer is yes, what parameters should I change to get shorter running times? Thanks a lot Nestor