Re: Generate test data inserts - 1GB

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Shital A <brightuser2019(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Generate test data inserts - 1GB
Date: 2019-08-09 15:55:00
Message-ID: 8515df43-2826-5e9b-60c8-daafe9294a9d@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 8/9/19 8:14 AM, Shital A wrote:
>

> Hello,

>
> 4) What techniques have you tried?
> Insert into with With statement, inserting 2000000 rows at a time. This
> takes 40 mins.
>

To add to my previous post. If you already have data in a Postgres
database then you could do:

pg_dump -d db -t some_table -a -f test_data.sql

That will dump the data only for the table in COPY format. Then you
could apply that to your test database(after TRUNCATE on table, assuming
you want to start fresh):

psql -d test_db -f test_data.sql

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shital A 2019-08-09 16:51:21 Re: Generate test data inserts - 1GB
Previous Message Rob Sargent 2019-08-09 15:44:27 Re: pg_wal fills up on big update query