Re: Generate test data inserts - 1GB

Поиск
Список
Период
Сортировка
От Rob Sargent
Тема Re: Generate test data inserts - 1GB
Дата
Msg-id 35286e57-c19c-861b-ebf7-d4f236e85e69@gmail.com
обсуждение исходный текст
Ответ на Re: Generate test data inserts - 1GB  (Shital A <brightuser2019@gmail.com>)
Список pgsql-general




--
Adrian Klaver
adrian.klaver@aklaver.com

Thanks for the reply Adrian. 

Missed one requirement. Will these methods generate wal logs needed for replication? 

Actually the data is to check if replication catches up. Below is scenario :

1. Have a master slave cluster with replication setup

2. Kill master so that standby takes over. We are using pacemaker for auto failure. 
Insert 1 GB data in new master while replication is broken.

3 Start oldnode as standby and check if 1GB data gets replicated.

As such testing might be frequent we needed to spend minimum time in generating data. 
Master slave are in same network. 

Thanks !
How quickly does your production instance grow, in terms of GB/per-unit-time?

В списке pgsql-general по дате отправления:

Предыдущее
От: Shital A
Дата:
Сообщение: Re: Generate test data inserts - 1GB
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Generate test data inserts - 1GB