Re: Looking for a large database for testing - Mailing list pgsql-performance

From Jim C. Nasby
Subject Re: Looking for a large database for testing
Date
Msg-id 20050823004335.GG17203@pervasive.com
Whole thread Raw
In response to Looking for a large database for testing  (Sebastian Hennebrueder <usenet@laliluna.de>)
List 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@pervasive.com
Pervasive Software        http://pervasive.com        512-569-9461

pgsql-performance by date:

Previous
From: Neil Conway
Date:
Subject: Re: MemoryContextSwitchTo during table scan?
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Need for speed