Re: Load 500 GB test data with Large objects and different types

Hi Raj. You can use the generate_series() function to create millions of
rows and do an insert from this select.
I'm used to using it in my test data generation.

*Lucio Chiessi*

Senior Database Administrator

Trustly, Inc.

M: +55 27 996360276

<https://www.linkedin.com/company/trustly/>
<https://www.facebook.com/trustly> <https://twitter.com/Trustly>

<https://www.linkedin.com/company/trustly/>
<https://www.facebook.com/trustly> <https://twitter.com/Trustly>

<https://www.trustly.net/>

PayWith*MyBank®* is now part of *Trustly*

On Thu, Feb 16, 2023 at 3:46 PM Raj kumar <rajkumar820999(at)gmail(dot)com> wrote:

> Hi,
>
> What is the easy/best way to load 500gb of data for testing purpose with
> flexible data types
> 1) Timestamp Datetime
> 2) Blob Large Objects
> 3) Different data types.
>
> I tried pgbench and sysbench which only gives int and varchar types.
>
> Thanks,
> Raj Kumar Narendiran.
>

--
Please read our privacy policy here
<https://www.trustly.net/about-us/privacy-policy> on how we process your
personal data in accordance with the General Data Protection Regulation
(EU) 2016/679 (the “GDPR”) and other applicable data protection legislation