Re: Huge sample dataset for testing.

Поиск
Список
Период
Сортировка
От Tim Uckun
Тема Re: Huge sample dataset for testing.
Дата
Msg-id 855e4dcf0904280529j372748f9td1494c75919f9e25@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Huge sample dataset for testing.  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Ответы Re: Huge sample dataset for testing.  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Список 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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Developer
Дата:
Сообщение: postgres only in local socket
Следующее
От: "A. Kretschmer"
Дата:
Сообщение: Re: Huge sample dataset for testing.