Re: Generate test data inserts - 1GB

2019-08-09 Thread Adrian Klaver
On 8/9/19 9:51 AM, Shital A wrote: On Fri, 9 Aug 2019, 21:25 Adrian Klaver, > wrote: On 8/9/19 8:14 AM, Shital A wrote: > > Hello, > > 4) What techniques have you tried? > Insert into with With statement, inserting 200 rows

Re: Generate test data inserts - 1GB

2019-08-09 Thread Rob Sargent
-- Adrian Klaver adrian.kla...@aklaver.com Thanks for the reply Adrian. Missed one requirement. Will these methods generate wal logs needed for replication? Actually the data is to check if replication catches up. Below is scenario : 1.

Re: Generate test data inserts - 1GB

2019-08-09 Thread Shital A
On Fri, 9 Aug 2019, 21:25 Adrian Klaver, wrote: > On 8/9/19 8:14 AM, Shital A wrote: > > > > > Hello, > > > > > 4) What techniques have you tried? > > Insert into with With statement, inserting 200 rows at a time. This > > takes 40 mins. > > > > To add to my previous post. If you already have

Re: Generate test data inserts - 1GB

2019-08-09 Thread Adrian Klaver
On 8/9/19 8:14 AM, Shital A wrote: Hello, 4) What techniques have you tried? Insert into with With statement, inserting 200 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_

Re: Generate test data inserts - 1GB

2019-08-09 Thread Adrian Klaver
On 8/9/19 8:14 AM, Shital A wrote: On Fri, 9 Aug 2019, 20:08 Adrian Klaver, > wrote: 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

Re: Generate test data inserts - 1GB

2019-08-09 Thread Shital A
On Fri, 9 Aug 2019, 20:08 Adrian Klaver, wrote: > 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)

Re: Generate test data inserts - 1GB

2019-08-09 Thread Adrian Klaver
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

Generate test data inserts - 1GB

2019-08-09 Thread Shital A
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? Thanks.