Search Postgresql Archives

Re: Huge sample dataset for testing.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux