X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4D66052AAE for ; Tue, 16 Aug 2005 05:24:00 -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 05425-02 for ; Tue, 16 Aug 2005 08:23:56 +0000 (GMT) Received: from dd01.profihoster.net (dd01.profihoster.net [84.233.130.40]) by svr1.postgresql.org (Postfix) with ESMTP id 73D9F52AAB for ; Tue, 16 Aug 2005 05:23:55 -0300 (ADT) Received: from [192.168.54.114] (Iba10.i.pppool.de [85.73.186.16]) by dd01.profihoster.net (Postfix) with ESMTP id 7A5822380EF for ; Tue, 16 Aug 2005 10:23:52 +0200 (CEST) Message-ID: <4301A29C.9010003@laliluna.de> Date: Tue, 16 Aug 2005 10:23:56 +0200 From: Sebastian Hennebrueder User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: de-DE, de, en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Looking for a large database for testing References: <430195DC.70104@laliluna.de> <43019ED4.7070509@wildenhain.de> In-Reply-To: <43019ED4.7070509@wildenhain.de> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit 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/165 X-Sequence-Number: 13912 Tino Wildenhain schrieb: > Sebastian Hennebrueder schrieb: > >> 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? >> > You can download the wikipedia content. Just browse the wikimedia site. > Its some work to change the data to be able to import into postgres, > but at least you have a lot real world data - in many languages. I have just found it. Here there is a link http://download.wikimedia.org/ They have content in multiple languages and dumps up to 20 GB. -- Best Regards / Viele Grüße Sebastian Hennebrueder ---- http://www.laliluna.de Tutorials for JSP, JavaServer Faces, Struts, Hibernate and EJB Get support, education and consulting for these technologies - uncomplicated and cheap.