From: Geoffrey <esoteric@3times25.net>
To: pgsql-performance@postgresql.org
Subject: solutions for new Postgresql application testing
Date: Tue, 01 Nov 2005 09:14:50 -0500
Message-ID: <4367785A.9090709@3times25.net> (raw)
We are going live with a application in a few months that is a complete
rewrite of an existing application. We are moving from an existing
proprietary database to Postgresql. We are looking for some
insight/suggestions as to how folks test Postgresql in such a situation.
We really want to run it throught the wringer before going live. I'm
throwing together a test suite that consists of mostly perl scripts.
I'm wondering what other, if any approaches folks have taken in a
similar situation. I know there's nothing like a real live test with
real users, and that will happen, but we want to do some semi-automated
load testing prior.
Anyone ever use any profiling apps (gprof) with any success?
We've got a failover cluster design and would like any insights here as
well.
We're also trying to decide whether a single database with multiple
schemas or multiple databases are the best solution. We've done some
research on this through the archives, and the answer seems to depend on
the database/application design. Still, we welcome any generic ideas on
this issue as well.
I've not provided any specifics on hardware or application as we really
want high level stuff at this time.
Thanks for any pointers or suggestions.
--
Until later, Geoffrey
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: esoteric@3times25.net
Subject: Re: solutions for new Postgresql application testing
In-Reply-To: <4367785A.9090709@3times25.net>
* 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