X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 00C83DB671 for ; Tue, 1 Nov 2005 10:14:42 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 53522-10 for ; Tue, 1 Nov 2005 14:14:36 +0000 (GMT) Received: from rhws.3times25.net (duck.3times25.net [66.23.211.34]) by svr1.postgresql.org (Postfix) with ESMTP id 05C0DDB69F for ; Tue, 1 Nov 2005 10:14:38 -0400 (AST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by rhws.3times25.net (Postfix) with ESMTP id 08F8CDB92C; Tue, 1 Nov 2005 09:14:51 -0500 (EST) Message-ID: <4367785A.9090709@3times25.net> Date: Tue, 01 Nov 2005 09:14:50 -0500 From: Geoffrey User-Agent: Mozilla Thunderbird 1.0.7 (X11/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: solutions for new Postgresql application testing Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.013 required=5 tests=[AWL=0.013] X-Spam-Score: 0.013 X-Spam-Level: X-Archive-Number: 200511/6 X-Sequence-Number: 15263 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