solutions for new Postgresql application testing - Mailing list pgsql-performance

From Geoffrey
Subject solutions for new Postgresql application testing
Date
Msg-id 4367785A.9090709@3times25.net
Whole thread Raw
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: 8.x index insert performance
Next
From: Jon Brisbin
Date:
Subject: Re: 8.1beta3 performance