Home > mailing lists

Load 500 GB test data with Large objects and different types - Mailing list pgsql-admin

From	Raj kumar
Subject	Load 500 GB test data with Large objects and different types
Date	February 16, 2023 21:45:39
Msg-id	CACxU--XLg61GPNkzzxfpgOu9oHLHKJHACNOUFAoVwN5P=jFELw@mail.gmail.com Whole thread Raw
Responses	Re: Load 500 GB test data with Large objects and different types (Lucio Chiessi <lucio.chiessi@trustly.com>)
List	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.

From: srinivas oguri
Date: 14 February 2023, 05:08:33
Subject: Re: pglogical performance for copying large table

From: pradeep pandey
Date: 16 February 2023, 22:56:47
Subject: EOL of Pglogical replication support