Re: Test data sets - Mailing list pgsql-general

From Medi Montaseri
Subject Re: Test data sets
Date
Msg-id 3CA16F89.9DE8E13@cybershell.com
Whole thread Raw
In response to Test data sets  (<tsmets@brutele.be>)
List pgsql-general
Sure try this one

#!/bin/perl

for ( my $i = 0 ; $i < 100000000; $i++)
{
    $buf = sprintf("John-%d:addr-%d:whatever-%d\n", $i);
    print $buf;
}

save the output to a file and slurp it in

Or if you want, write a DBI code that does 10000000 inserts.

tsmets@brutele.be wrote:

> I was wandering were I could find data sets to test some of the behavior of
> my DB.
> I basically need a few thousands records  of address like data ...
> May be pumping it from the on-line telephone guides is an option but ... is
> there smthg available as such on the net ?
>
> Tx,
>
> thomas,
>
> --
> Thomas SMETS
> rue J. Wytsmanstraat 62
> 1050 Bruxelles
> yahoo-id : smetsthomas
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

--
-------------------------------------------------------------------------
Medi Montaseri                               medi@CyberShell.com
Unix Distributed Systems Engineer            HTTP://www.CyberShell.com
CyberShell Engineering
-------------------------------------------------------------------------




pgsql-general by date:

Previous
From: Philip Hallstrom
Date:
Subject: Re: resetting sequence
Next
From: Jeff Davis
Date:
Subject: Suggestion for table/index structure?