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 0BCF2D7245 for ; Mon, 22 Aug 2005 21:43:34 -0300 (ADT) 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 56040-07 for ; Tue, 23 Aug 2005 00:43:33 +0000 (GMT) Received: from flake.decibel.org (flake.decibel.org [67.100.216.10]) by svr1.postgresql.org (Postfix) with ESMTP id 87111D7201 for ; Mon, 22 Aug 2005 21:43:32 -0300 (ADT) Received: by flake.decibel.org (Postfix, from userid 1001) id 09AE91529B; Mon, 22 Aug 2005 19:43:35 -0500 (CDT) Date: Mon, 22 Aug 2005 19:43:35 -0500 From: "Jim C. Nasby" To: Sebastian Hennebrueder Cc: postgres performance Subject: Re: Looking for a large database for testing Message-ID: <20050823004335.GG17203@pervasive.com> References: <430195DC.70104@laliluna.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <430195DC.70104@laliluna.de> X-Operating-System: FreeBSD 4.11-RELEASE-p10 i386 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200508/331 X-Sequence-Number: 14078 On Tue, Aug 16, 2005 at 09:29:32AM +0200, Sebastian Hennebrueder wrote: > Hello, > > I would like to test the performance of my Java/PostgreSQL applications > especially when making full text searches. > For this I am looking for a database with 50 to 300 MB having text fields. > e.g. A table with books with fields holding a comment, table of content > or example chapters > or what ever else. > > Does anybody have an idea where I can find a database like this or does > even have something like this? Most benchmarks (such as dbt* and pgbench) have data generators you could use. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com 512-569-9461