Search Postgresql Archives

Fwd: Sample databases

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



---------- Forwarded message ----------
From: Vraj Mohan <r.vrajmohan@xxxxxxxxx>
Date: Thu, Jan 17, 2013 at 7:22 AM
Subject: Re:  Sample databases
To: Jeff Janes <jeff.janes@xxxxxxxxx>


On Wed, Jan 16, 2013 at 10:32 PM, Jeff Janes <jeff.janes@xxxxxxxxx> wrote:
> What do you mean by decent data volumes?  Numbers and units are wonderful
> things!

Sorry, I should have been more specific. I was looking for data with
enough richness to explore corner cases in SQL and volume to be able
to study different execution plans. I am guessing here, but would
shoot for something like:
- columns with NULLs
- columns that are foreign keys with not all the values from the
referenced table for exploring outer joins
- tables with ~500,000 rows
- columns with values such that the indexes are highly selective. I
would assume that having over a 100 different values for a column
should achieve this.

> What things are you looking to learn and test automatically?  I like to
> learn about and test performance, and I find pgbench often quite good for
> doing that.

My goal is for a database that can be used for:
- learning SQL, specifically postgresql SQL; going beyond simple
queries and joins to using subqueries, correlated subqueries, window
functions and so on
- writing about postgresql
- testing applications developed for postgresql; I would think that
many of the pgfoundry projects would benefit from this.

> Is there a specific thing about the completeness that concerns you?

I tried pagila and found that it did not create any rows in the film
table when I used pagila-insert-data.sql, After my original post, I
have discovered that pagila-data.sql (which used COPY) works
correctly.

> Have you looked at the Dell DVD store?  It is also on that site you linked
> above, but it seems to be more up to date on Dell's own site.
>

Thanks, I'll take a look at the Dell DVD store.

I plan to contribute to the http://pgfoundry.org/projects/dbsamples/
project. For starters, I will add the suppliers-parts-projects
database from C J Date's "An Introduction to Database Systems".

--Vraj Mohan


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux