X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 91629D1B3C7 for ; Wed, 26 May 2004 16:16:20 -0300 (ADT) 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 17717-08 for ; Wed, 26 May 2004 16:16:01 -0300 (ADT) Received: from localhost.localdomain (unknown [200.35.66.77]) by svr1.postgresql.org (Postfix) with ESMTP id 9EF70D1B188 for ; Wed, 26 May 2004 16:15:58 -0300 (ADT) Received: from localhost.localdomain (FWVasa [127.0.0.1]) by localhost.localdomain (8.12.8/8.12.8) with ESMTP id i4QJDFrZ026395; Wed, 26 May 2004 15:13:15 -0400 Received: (from apache@localhost) by localhost.localdomain (8.12.8/8.12.8/Submit) id i4QJDFan026393; Wed, 26 May 2004 15:13:15 -0400 X-Authentication-Warning: localhost.localdomain: apache set sender to mario_soto@venezolanadeavaluos.com using -f Received: from 200.35.66.77 (proxying for 192.168.0.100) (SquirrelMail authenticated user mario_soto) by mail.venezolanadeavaluos.com with HTTP; Wed, 26 May 2004 15:13:14 -0400 (VET) Message-ID: <45130.200.35.66.77.1085598794.squirrel@mail.venezolanadeavaluos.com> Date: Wed, 26 May 2004 15:13:14 -0400 (VET) Subject: Re: performance very slow From: "Mario Soto" To: In-Reply-To: References: <36620.200.35.66.77.1085585190.squirrel@mail.venezolanadeavaluos.com> X-Priority: 3 Importance: Normal Cc: , X-Mailer: SquirrelMail (version 1.2.10) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/800 X-Sequence-Number: 61234 OK. i see the link and change parameters in postgresql.conf i.e. When excecute a insert statement the memory up to 90% to use . it's normal ??????? Thank for yor help and sorry for my bad englis Regards Mario Soto > On Wed, 26 May 2004, Mario Soto wrote: > >> tha machine is a Pentium IV 2,6 GHZ AND 1 GB IN RAM with lINUX RH 9.0. >> >> BUT THE PERFORMANCE IT´S VERY SLOW > > How often do you run VACUUM ANALYZE? You might want to do that every > night or every hour (depending on how much updates you have). > > Some of your config values could and should be tuned, read something > like > > http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html > > Still, if it's very slow it's probably not just a little tweaking of > these variables that solves everything. > > If that is the case you need to find a slow query, run EXPLAIN ANALYZE > on it and try to figure out why it is slow. There is a list to help with > performance issues called pgsql-performance that you might want to post > to (and read its archive). > > But before anything else, make sure you run VACUUM ANALYZE regulary. > > -- > /Dennis Björklund