From: Mark Rae <mrae@purplebat.com>
To: Sebastian Hennebrueder <usenet@laliluna.de>
Cc: postgres performance <pgsql-performance@postgresql.org>
Subject: Re: Looking for a large database for testing
Date: Tue, 16 Aug 2005 09:39:10 +0100
Message-ID: <20050816083910.GA31460@purplebat.com> (raw)
In-Reply-To: <430195DC.70104@laliluna.de>
References: <430195DC.70104@laliluna.de>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mrae@purplebat.com, usenet@laliluna.de
Subject: Re: Looking for a large database for testing
In-Reply-To: <20050816083910.GA31460@purplebat.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox