From: chris smith <dmagick@gmail.com>
To: Greg Stumph <gregstumph@comcast.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Worsening performance with 7.4 on flash-based system
Date: Sun, 30 Apr 2006 09:51:44 +1000
Message-ID: <3c1395330604291651q129b4e14v5f3849f842e8b9d8@mail.gmail.com> (raw)
In-Reply-To: <e2tnb7$cpi$1@news.hub.org>
References: <e2b80f$245o$1@news.hub.org>
<e2tnb7$cpi$1@news.hub.org>
On 4/29/06, Greg Stumph <gregstumph@comcast.net> wrote:
> Well, since I got no response at all to this message, I can only assume that
> 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 be
> asking this, or different data I should provide, hopefully someone will let
> me know...
>
> Thanks,
> Greg
>
> "Greg Stumph" <gregstumph@comcast.net> 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, performance
> > is fine. At its worst, we are seeing fairly simple SELECT queries taking
> > up to 1 second to execute. When these queries are run in a loop, the loop
> > can take up to 30 seconds to execute, instead of the 2 seconds or so that
> > 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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dmagick@gmail.com, gregstumph@comcast.net
Subject: Re: Worsening performance with 7.4 on flash-based system
In-Reply-To: <3c1395330604291651q129b4e14v5f3849f842e8b9d8@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox