Re: Generate test data inserts - 1GB - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Generate test data inserts - 1GB
Date
Msg-id f522d2fb-f70d-40cb-73a0-d8f267f65947@aklaver.com
Whole thread Raw
In response to Generate test data inserts - 1GB  (Shital A <brightuser2019@gmail.com>)
Responses Re: Generate test data inserts - 1GB  (Shital A <brightuser2019@gmail.com>)
List 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.klaver@aklaver.com



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL lock file
Next
From: Adrian Klaver
Date:
Subject: Re: Understanding PostgreSQL installer debug log