X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 49FC79DC803; Mon, 13 Mar 2006 15:27:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 27219-02; Mon, 13 Mar 2006 15:27:37 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by postgresql.org (Postfix) with ESMTP id B809A9DC833; Mon, 13 Mar 2006 15:27:34 -0400 (AST) Received: from Courts-MTA by gwmta.wicourts.gov with Novell_GroupWise; Mon, 13 Mar 2006 13:27:35 -0600 Message-Id: <4415733D.EE98.0025.0@wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 7.0 Date: Mon, 13 Mar 2006 13:27:25 -0600 From: "Kevin Grittner" To: ,, Subject: Wisconsin Circuit Court Access (WCCA) on PostgreSQL Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.089 required=5 tests=[AWL=0.089] X-Spam-Score: 0.089 X-Spam-Level: X-Archive-Number: 200603/112 X-Sequence-Number: 20869 The Consolidated Court Automation Programs (CCAP) of the Wisconsin Court System has migrated to PostgreSQL for all of its Circuit Court web operations. Eight production databases have been converted, six of them around 180 GB each, holding statewide information replicated real-time from 72 county databases. The central copies support audit functions, statewide statistics and report generation, and this web site: http://wcca.wicourts.gov/ Given the success of this effort, we expect to be converting the other court databases to PostgreSQL. We've been very happy with both the performance of the product and the support we have received from the mailing lists. Overall, PostgreSQL has been faster than the commercial product from which we converted. Even more important is the fast response we have had when posting problems to the lists. We have normally had a fix within 24 hours. Frankly, the support has been amazing. We wonder how widespread the use of PostgreSQL is within government agencies; I would love to hear from anyone with experience with this. With tight budgets, it seems likely that there may be others moving in this direction.