Re: Test data sets
От | |
---|---|
Тема | Re: Test data sets |
Дата | |
Msg-id | 043701c1d56d$5dfae5c0$6501a8c0@calvin обсуждение исходный текст |
Ответ на | Test data sets (<tsmets@brutele.be>) |
Список | 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@cybershell.com> To: <tsmets@brutele.be> Cc: <pgsql-general@postgresql.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@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 по дате отправления: