Re: Sample databases?

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: mlw <markw(at)mohawksoft(dot)com>
Cc: Hackers List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Sample databases?
Date: 2000-12-19 19:31:52
Message-ID: 3A3FB7A8.39B89381@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> What do you guys use?

The regression database, which you can augment with some "insert into x
select * from x;" commands. It would also be useful to have a "database
generation" script, but of course this would be cooked data.

> Perhaps we can create a substantial test database? (Millions of records,
> many tables, and a number of relations.) So when we see a problem, we
> can all see it right away. I like "real world" data, because it is often
> more organic than randomized test data, and brings out more issues. Take
> index selection during a select, for instance.

The regression database is such a beast, but is not large enough for the
millions of records kinds of tests.

Suggestions?

- Thomas

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Hoffmann 2000-12-19 19:33:38 Re: Sample databases?
Previous Message Oleg Bartunov 2000-12-19 19:25:21 Re: Who is a maintainer of GiST code ?