Re: Huge sample dataset for testing.

From: Tim Uckun <timuckun(at)gmail(dot)com>
To: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Huge sample dataset for testing.
Date: 2009-04-28 12:29:36
Message-ID: 855e4dcf0904280529j372748f9td1494c75919f9e25@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> > I would like to have tables with tens of millions of records if possible.
>
> It is easy to create such a table:
>
> test=# create table huge_data_table as select s, md5(s::text) from
> generate_series(1,10) s;

Thanks I'll try something like that.

I guess can create some random dates or something for other types of fields
too.

I was hoping there was already something like this available though because
it's going to take some time to create relations and such.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2009-04-28 12:36:15 Re: Huge sample dataset for testing.
Previous Message Jasen Betts 2009-04-28 12:21:19 Re: Web + Slicing/Paging datas