Re: Generate test data inserts - 1GB

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Shital A <brightuser2019(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Generate test data inserts - 1GB
Date: 2019-08-09 14:38:01
Message-ID: f522d2fb-f70d-40cb-73a0-d8f267f65947@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 8/9/19 4:12 AM, Shital A wrote:
> Hello
>
> Postgresql 9.6
>
> Need to generate 1GB test data in very less time. I got some techniques
> online but they take around 40mins for 400GB. Any quicker way?

1) Postgres version?

2) Data going into single table or multiple tables?

3) What is the time frame you are trying to achieve?

4) What techniques have you tried?

5) If you need only 1GB why the 400GB number?

>
>
> Thanks.
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-08-09 14:45:38 Re: Understanding PostgreSQL installer debug log
Previous Message Tom Lane 2019-08-09 14:31:56 Re: PostgreSQL lock file