Test databases

From: mlw <pgsql(at)mohawksoft(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Test databases
Date: 2003-04-10 12:49:48
Message-ID: 3E95686C.4000406@mohawksoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Not sure if anyone cares, but I know early on I needed a few large
databases to test with, and I have seen a couple requests for database
sources. On my website (www.mohawksoft.com) in "downloads" I posted two
free database loaders.

The first one (mentioned earlier) is the TigerUA database from the U.S.
Census.
The second one is the FreeDB database, www.freedb.com, which is a
database of user entered CD information. There are almost 700K CDs in
them, and over 8 million individual song titles.

These are useful for testing how postgresql works with large data sets.
For instance, using the freedb database, try doing this:

update cdsongs set cdid=5;

Mark.

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Cramer 2003-04-10 13:10:42 building docs from cvs
Previous Message Thomas O'Dowd 2003-04-10 12:19:57 Re: Charset encoding and accents