Load 500 GB test data with Large objects and different types

From: Raj kumar <rajkumar820999(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>, Raj kumar <rajkumar820999(at)gmail(dot)com>
Subject: Load 500 GB test data with Large objects and different types
Date: 2023-02-16 18:45:39
Message-ID: CACxU--XLg61GPNkzzxfpgOu9oHLHKJHACNOUFAoVwN5P=jFELw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message pradeep pandey 2023-02-16 19:56:47 EOL of Pglogical replication support
Previous Message srinivas oguri 2023-02-14 02:08:33 Re: pglogical performance for copying large table