Re: Test data sets

From: <tsmets(at)brutele(dot)be>
To: "Medi Montaseri" <medi(at)cybershell(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Test data sets
Date: 2002-03-27 08:38:58
Message-ID: 043701c1d56d$5dfae5c0$6501a8c0@calvin
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tx,
I did my own Java garbage generator ...
I was looking for a closer to real life set.
U know one of these big company that just mixed up all the addresses / zip
code & town accross countries, hence you have it very hard ot find it back
anybody.

Way much harder than looking on the internet to find him / her !

thomas,

--
Thomas SMETS
rue J. Wytsmanstraat 62
1050 Bruxelles
yahoo-id : smetsthomas
----- Original Message -----
From: "Medi Montaseri" <medi(at)cybershell(dot)com>
To: <tsmets(at)brutele(dot)be>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: 27 March, 2002 8:06 AM
Subject: Re: [GENERAL] Test data sets

> 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(at)brutele(dot)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(at)postgresql(dot)org)
>
> --
> -------------------------------------------------------------------------
> Medi Montaseri medi(at)CyberShell(dot)com
> Unix Distributed Systems Engineer HTTP://www.CyberShell.com
> CyberShell Engineering
> -------------------------------------------------------------------------
>
>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dominique ROUSSEAU 2002-03-27 08:45:07 Re: INSERTs slow
Previous Message Denis Gasparin 2002-03-27 08:11:06 Re: Altering a CHAR(4) column CHAR(5) changing