Re: Looking for a large database for testing

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: Sebastian Hennebrueder <usenet(at)laliluna(dot)de>
Cc: postgres performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Looking for a large database for testing
Date: 2005-08-23 00:43:35
Message-ID: 20050823004335.GG17203@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(at)pervasive(dot)com
Pervasive Software http://pervasive.com 512-569-9461

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jim C. Nasby 2005-08-23 00:48:56 Re: Need for speed
Previous Message Neil Conway 2005-08-22 22:48:18 Re: MemoryContextSwitchTo during table scan?