Postgres Pro
Downloads
Home   >   mailing lists

Re: Huge sample dataset for testing. - Mailing list pgsql-general

From Tim Uckun
Subject Re: Huge sample dataset for testing.
Date
Msg-id 855e4dcf0904280529j372748f9td1494c75919f9e25@mail.gmail.com
Whole thread Raw
In response to Re: Huge sample dataset for testing.  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Responses Re: Huge sample dataset for testing.
List pgsql-general
Tree view


> 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.

pgsql-general by date:

Previous
From: Developer
Date:
Subject: postgres only in local socket
Next
From: "A. Kretschmer"
Date:
Subject: Re: Huge sample dataset for testing.