From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Greg Stumph <gregstumph@comcast.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Worsening performance with 7.4 on flash-based system
Date: Mon, 01 May 2006 10:55:29 -0500
Message-ID: <1146498929.22037.3.camel@state.g2switchworks.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 Fri, 2006-04-28 at 13:36, Greg Stumph 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...
I'd pick one particular case and do explain analyze on it both right
after a reload, after running for a while, and after a vacuum analyze.
Also, do a vacuum verbose on the database and post the output of that
when the system's slowed down.
Do you make a lot of temp tables? Run a lot of DDL? I don't think we
have enough information to make a real informed decision, but I'm not
sure what questions to ask to find out where the bottleneck is...
Also, this could be the flash controller / card combo causing problems.
Do you start with a freshly formatted card at the beginning? I know
that flash controllers randomize the part of the card that gets written
to so that you don't kill one part of it early due to writing on just on
part. Could be that as the controller maps the card behind the scenes,
the access gets slower on the lower level, and there's nothing
PostgreSQL can do about it.
Can you tell us what your usage patterns are in a bit more detail?
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: smarlowe@g2switchworks.com, gregstumph@comcast.net
Subject: Re: Worsening performance with 7.4 on flash-based system
In-Reply-To: <1146498929.22037.3.camel@state.g2switchworks.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