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.
On Thu, Feb 16, 2023 at 3:46 PM Raj kumar <rajkumar820999@xxxxxxxxx> wrote:
Hi,What is the easy/best way to load 500gb of data for testing purpose with flexible data types1) Timestamp Datetime2) Blob Large Objects3) Different data types.I tried pgbench and sysbench which only gives int and varchar types.Thanks,Raj Kumar Narendiran.