From: | Shital A <brightuser2019(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Generate test data inserts - 1GB |
Date: | 2019-08-09 15:14:10 |
Message-ID: | CAMp7vw-ajbV+RfKgBzhKJ8tEG5KFUX7dGufm-SXDDKMzo5PY5g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, 9 Aug 2019, 20:08 Adrian Klaver, <adrian(dot)klaver(at)aklaver(dot)com> 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) 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
Hello,
Sorry 400GB was a typo. Its 400 MB Details are below:
1) Postgres version?
9.6
2) Data going into single table or multiple tables?
Single table having Multiple columns
3) What is the time frame you are trying to achieve?
As quick as possible.
4) What techniques have you tried?
Insert into with With statement, inserting 2000000 rows at a time. This
takes 40 mins.
5) If you need only 1GB why the 400GB number?
That was 400MB. M checking size using \l+ option.
Thanks.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2019-08-09 15:32:12 | Re: Generate test data inserts - 1GB |
Previous Message | Daniel Fink (PDF) | 2019-08-09 15:04:58 | RE: pg_wal fills up on big update query |