X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 9A5EF11F61BF for ; Sat, 29 Apr 2006 20:51:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 78352-02 for ; Sat, 29 Apr 2006 20:51:46 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.197]) by postgresql.org (Postfix) with ESMTP id 7ADAE11F6003 for ; Sat, 29 Apr 2006 20:51:44 -0300 (ADT) Received: by nz-out-0102.google.com with SMTP id 9so2064701nzo for ; Sat, 29 Apr 2006 16:51:44 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=UeN6DAVw+HicvYZCKxa4sYMNck8RurQwWHV6cG+EJJZad45u3JNEklCfTAifTXOpXZKsmr9O6ZjuBQ8T223+vI6cWInIVWUJsJu4FBsgerAkiCTqiAVv7kiT/puPwx8bwCP+Rv0oGU/Xs5F75ZJ/J68+JeOhHpaGWyEWGzLMh6g= Received: by 10.36.89.1 with SMTP id m1mr1821118nzb; Sat, 29 Apr 2006 16:51:44 -0700 (PDT) Received: by 10.36.97.2 with HTTP; Sat, 29 Apr 2006 16:51:44 -0700 (PDT) Message-ID: <3c1395330604291651q129b4e14v5f3849f842e8b9d8@mail.gmail.com> Date: Sun, 30 Apr 2006 09:51:44 +1000 From: "chris smith" To: "Greg Stumph" Subject: Re: Worsening performance with 7.4 on flash-based system Cc: pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/699 X-Sequence-Number: 18783 On 4/29/06, Greg Stumph wrote: > Well, since I got no response at all to this message, I can only assume t= hat > I've asked the question in an insufficient way, or else that no one has > anything to offer on our problem. > > This was my first post to the list, so if there's a better way I should b= e > asking this, or different data I should provide, hopefully someone will l= et > me know... > > Thanks, > Greg > > "Greg Stumph" wrote in message > news:e2b80f$245o$1@news.hub.org... > > We are experiencing gradually worsening performance in PostgreSQL 7.4.7= , > > on a system with the following specs: > > Linux OS (Fedora Core 1, 2.4 kernal) > > Flash file system (2 Gig, about 80% full) > > 256 Meg RAM > > 566 MHz Celeron CPU > > > > We use Orbit 2.9.8 to access PostGres. The database contains 62 tables. > > > > When the system is running with a fresh copy of the database, performan= ce > > is fine. At its worst, we are seeing fairly simple SELECT queries takin= g > > up to 1 second to execute. When these queries are run in a loop, the lo= op > > can take up to 30 seconds to execute, instead of the 2 seconds or so th= at > > we would expect. If you're inserting/updating/deleting a table or tables heavily, then you'll need to vacuum it a lot more often than a reasonably static table. Are you running contrib/autovacuum at all? PG 8.0 and above have autovacuum built in but 7.4.x needs to run the contrib version. PS - the latest 7.4 version is .12 - see http://www.postgresql.org/docs/7.4/interactive/release.html for what has changed (won't be much in performance terms but may fix data-loss bugs). -- Postgresql & php tutorials http://www.designmagick.com/