Date: Tue, 16 Aug 2005 09:39:10 +0100
To: Sebastian Hennebrueder <usenet@laliluna.de>
Cc: postgres performance <pgsql-performance@postgresql.org>
Subject: Re: Looking for a large database for testing
Message-ID: <20050816083910.GA31460@purplebat.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>
User-Agent: Mutt/1.5.9i
From: Mark Rae <mrae@purplebat.com>

On Tue, Aug 16, 2005 at 09:29:32AM +0200, Sebastian Hennebrueder wrote:
> 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.

You could try the OMIM database, which is currently 100M
It contains both journal references and large sections of
'plain' text. It also contains a large amount of technical
terms which will really test any kind of soundex matching
if you are using that.

http://www.ncbi.nlm.nih.gov/Omim/omimfaq.html#download

Unfortunately it only comes as a flat text file, but is
very easy to parse.

And if you start reading it, you'll probably learn quite
a lot of things you really didn't want to know!! :-D

    -Mark